SD

Tables (5)

ADRC (Address)

  • ADDRNUMBER (Address No) — Primary key — NOT NULL
  • DATE_FROM (Valid From Data) — Primary key
  • Key (NO USE) — Primary key — NOT NULL
  • KUNNR (Customer Account) — Foreign key → KNA1.KUNNR — NOT NULL

KNA1 (General Data)

  • KUNNR (Customer Account) — Primary key — NOT NULL
  • KTOKD (Account group) — NOT NULL
  • ADRNR (Address No)
  • NAME1 (Name)

KNB1 (Company Code)

  • KUNNR (Customer Account) — Primary key — NOT NULL
  • BUKRS (Company Code) — Primary key — NOT NULL
  • AKONT (Recon.Account)
  • ZTERM (Terms of Payment)
  • KUNNR (Customer Account2) — Foreign key → KNA1.KUNNR — NOT NULL

KNVP (Partner Function)

  • KUNNR (Customer Account) — Primary key — NOT NULL
  • VKORG (Sales Org.) — Primary key — NOT NULL
  • VTWEG (Distribution Channel) — Primary key — NOT NULL
  • SPART (Division) — Primary key — NOT NULL
  • PARVW (Partner Function) — Primary key — NOT NULL
  • KUNN2 (Partner Account) — 10 — NOT NULL
  • KUNNR (Customer Account2) — Foreign key → KNVV.KUNNR — NOT NULL
  • VKORG (Sales Org.2) — Foreign key → KNVV.VKORG — NOT NULL
  • VTWEG (Distribution Channel2) — Foreign key → KNVV.VTWEG — NOT NULL
  • SPART (Division2) — Foreign key → KNVV.SPART

KNVV (Sales Distribution)

  • KUNNR (Customer Account) — Primary key — NOT NULL
  • VKORG (Sales Org.) — Primary key — NOT NULL
  • VTWEG (Distribution Channel) — Primary key — NOT NULL
  • SPART (Division) — Primary key
  • WAERS (Currency)
  • KUNNR (Customer Account2) — Foreign key → KNA1.KUNNR — NOT NULL