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