SAP ABAP Table S126 (Open Variants - Basis 1), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `S126` {Open Variants - Basis 1}

Home

                title {label: "SAP ABAP table S126 {Open Variants - Basis 1}", size: "20"}

# Entities

[S126] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*SSOUR {label: "CHAR (4)"}
*VRSIO {label: "CHAR (3)"}
*SPMON {label: "NUMC (6)"}
*SPTAG {label: "DATS (8)"}
*SPWOC {label: "NUMC (6)"}
*SPBUP {label: "NUMC (6)"}
*+VBELN {label: "CHAR (10)"}
*+POSNR {label: "NUMC (6)"}
*CUOBJ {label: "NUMC (18)"}
+BASME {label: "UNIT (3)"}
+STWAE {label: "CUKY (5)"}
+VKORG {label: "CHAR (4)"}
+VTWEG {label: "CHAR (2)"}
+SPART {label: "CHAR (2)"}
+KUNNR {label: "CHAR (10)"}
+WERKS {label: "CHAR (4)"}
+MATNR {label: "CHAR (18)"}

[KNA1] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KUNNR {label: "CHAR (10)"}

[MARA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MATNR {label: "CHAR (18)"}

[T000] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}

[T001W] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*WERKS {label: "CHAR (4)"}

[T006] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MSEHI {label: "UNIT (3)"}

[TCURC] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*WAERS {label: "CUKY (5)"}

[TSPA] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*SPART {label: "CHAR (2)"}

[TVKO] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*VKORG {label: "CHAR (4)"}

[TVKOV] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+VKORG {label: "CHAR (4)"}
*+VTWEG {label: "CHAR (2)"}

[VBUK] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*VBELN {label: "CHAR (10)"}

[VBUP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+VBELN {label: "CHAR (10)"}
*POSNR {label: "NUMC (6)"}

# Relationships

S126 *--* T006 {label: "S126-BASME = T006-MSEHI"}
S126 *--* KNA1 {label: "S126-KUNNR = KNA1-KUNNR"}
S126 *--* T000 {label: "S126-MANDT = T000-MANDT"}
S126 *--* MARA {label: "S126-MATNR = MARA-MATNR"}
S126 *--* VBUP {label: "S126-POSNR = VBUP-POSNR"}
S126 *--* TSPA {label: "S126-SPART = TSPA-SPART"}
S126 *--* TCURC {label: "S126-STWAE = TCURC-WAERS"}
S126 *--* VBUK {label: "S126-VBELN = VBUK-VBELN"}
S126 *--* TVKO {label: "S126-VKORG = TVKO-VKORG"}
S126 *--* TVKOV {label: "S126-VTWEG = TVKOV-VTWEG"}
S126 *--* T001W {label: "S126-WERKS = T001W-WERKS"}

E-R Diagram for table S126 (Open Variants - Basis 1)

Foreign Key tables (11)

KNA1 {General Data in Customer Master}
MARA {General Material Data}
T000 {Clients}
T001W {Plants/Branches}
T006 {Units of Measurement}
TCURC {Currency Codes}
TSPA {Organizational Unit: Sales Divisions}
TVKO {Organizational Unit: Sales Organizations}
TVKOV {Org. Unit: Distribution Channels per Sales Organization}
VBUK {Sales Document: Header Status and Administrative Data}
VBUP {Sales Document: Item Status}

SAP ABAP Table S126 {Open Variants - Basis 1}

Foreign Key tables (11)

SAP ABAP Table `S126` {Open Variants - Basis 1}