SAP Table S126
Open Variants - Basis 1
S126 (Open Variants - Basis 1) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S126 to other SAP tables.
S126 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
SSOUR
Statistic(s) origin
|
SSOUR |
CHAR
|
4 | 0 | ||||||||
|
VRSIO
Version number in the information structure
|
VRSIO |
CHAR
|
3 | 0 | ||||||||
|
SPMON
Period to analyze - month
|
SPMON |
NUMC
|
6 | 0 | ||||||||
|
SPTAG
Period to analyze - current date
|
SPTAG |
DATS
|
8 | 0 | ||||||||
|
SPWOC
Period to analyze - week
|
SPWOC |
NUMC
|
6 | 0 | ||||||||
|
SPBUP
Period to analyze - posting period
|
SPBUP |
NUMC
|
6 | 0 | ||||||||
|
VBELN
Sales Document
|
VBELN_VA | VBUK |
CHAR
|
10 | 0 | |||||||
|
POSNR
Sales Document Item
|
POSNR_VA | VBUP |
NUMC
|
6 | 0 | |||||||
|
CUOBJ
Configuration
|
CUOBJ_VA |
NUMC
|
18 | 0 | ||||||||
|
PERIV
Fiscal Year Variant
|
PERIV |
CHAR
|
2 | 0 | ||||||||
|
VWDAT
Pointer to administrative data
|
VWDAT |
NUMC
|
10 | 0 | ||||||||
|
BASME
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |||||||
|
STWAE
Statistics currency
|
STWAE | TCURC |
CUKY
|
5 | 0 | |||||||
|
MCUPD
Indicator whether statistical record was updated
|
MCUPD |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |||||||
|
VTWEG
Distribution Channel
|
VTWEG | TVKOV |
CHAR
|
2 | 0 | |||||||
|
SPART
Division
|
SPART | TSPA |
CHAR
|
2 | 0 | |||||||
|
KUNNR
Sold-to party
|
KUNAG | KNA1 |
CHAR
|
10 | 0 | |||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||
|
AEMENGE
Incoming orders quantity
|
MC_AEMENGE |
QUAN
|
15 | 3 | ||||||||
|
AEMENGE_D
Quantity of incoming orders - delata updating
|
AEMENGE_D |
QUAN
|
15 | 3 | ||||||||
|
AENETWR
Net value of incoming orders
|
MC_AENETWR |
CURR
|
19 | 2 | ||||||||
|
AENETWR_D
Net value of incoming orders - delta updating
|
AENETWR_D |
CURR
|
19 | 2 | ||||||||
|
AEKZWI1
Incoming orders: gross
|
MC_AEKZWI1 |
CURR
|
17 | 2 | ||||||||
|
AEKZWI1_D
Gross incoming orders - delta updating
|
AEKZWI1_D |
CURR
|
17 | 2 | ||||||||
|
AEKZWI2
Incoming orders: net 1
|
MC_AEKZWI2 |
CURR
|
17 | 2 | ||||||||
|
AEKZWI2_D
Net incoming orders 1 - delta updating
|
AEKZWI2_D |
CURR
|
17 | 2 | ||||||||
|
AEKZWI3
Incoming orders: net 2
|
MC_AEKZWI3 |
CURR
|
17 | 2 | ||||||||
|
AEKZWI3_D
Net incoming orders 2 - delta updating
|
AEKZWI3_D |
CURR
|
17 | 2 | ||||||||
|
AEKZWI4
Incoming orders: freight
|
MC_AEKZWI4 |
CURR
|
17 | 2 | ||||||||
|
AEKZWI4_D
Incoming orders (freight) - delta updating
|
AEKZWI4_D |
CURR
|
17 | 2 | ||||||||
|
AEKZWI5
Incoming orders: pricing subtotal 5
|
MC_AEKZWI5 |
CURR
|
17 | 2 | ||||||||
|
AEKZWI5_D
Incoming orders PrSub 5 - delta updating
|
AEKZWI5_D |
CURR
|
17 | 2 | ||||||||
|
AEKZWI6
Incoming orders: pricing subtotal 6
|
MC_AEKZWI6 |
CURR
|
17 | 2 | ||||||||
|
AEKZWI6_D
Incoming orders PrSub 6 - delta updating
|
AEKZWI6_D |
CURR
|
17 | 2 | ||||||||
|
AEMENGB
Qty. incoming orders based on confirm. date of sched. line
|
AEMENGB |
QUAN
|
15 | 3 | ||||||||
|
AEMENGB_D
QtyIO based on confirmation date of sched. line - DeltaUpdat
|
AEMENGB_D |
QUAN
|
15 | 3 | ||||||||
|
OEIMEB
Open order qty. based on confirmation date of sched. line
|
OEIMEB |
QUAN
|
15 | 3 | ||||||||
|
OEIMEB_D
Open order quantity based on conf. date of sched. line-delta
|
OEIMEB_D |
QUAN
|
15 | 3 | ||||||||
|
OEIMEW
Open order qty. based on desired del. date of sched. line
|
OEIMEW |
QUAN
|
15 | 3 | ||||||||
|
OEIMEW_D
Open order qty. based on desired del.date of sch.line- delta
|
OEIMEW_D |
QUAN
|
15 | 3 | ||||||||
|
OEIWEB
Open order value based on confirmation date of sched. line
|
OEIWEB |
CURR
|
19 | 2 | ||||||||
|
OEIWEB_D
Open order val. based on conf. date of sched. line - delta
|
OEIWEB_D |
CURR
|
19 | 2 | ||||||||
|
OEIWEW
Open order value based on desired del. date of sched. line
|
OEIWEW |
CURR
|
19 | 2 | ||||||||
|
OEIWEW_D
Open ord. val. based on desired del. date sched.line - delta
|
OEIWEW_D |
CURR
|
19 | 2 | ||||||||
|
LGMNG
Delivery quantity in base unit of measure
|
MC_LGMNG |
QUAN
|
15 | 3 | ||||||||
|
LGMNG_D
Delivery qty in base unit of measure - Delta update
|
MC_LGMNG_D |
QUAN
|
15 | 3 | ||||||||
|
UMNETWR
Net value of invoiced sales
|
MC_UMNETWR |
CURR
|
19 | 2 | ||||||||
|
UMNETWR_D
Invoiced sales net value - Delta update
|
UMNETWR_D |
CURR
|
19 | 2 | ||||||||
S126 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| S126 | BASME | S126 | MANDT |
T006
Units of Measurement
|
MANDT |
| S126 | BASME | S126 | BASME |
T006
Units of Measurement
|
MSEHI |
| S126 | KUNNR | S126 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| S126 | KUNNR | S126 | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| S126 | MANDT | S126 | MANDT |
T000
Clients
|
MANDT |
| S126 | MATNR | S126 | MANDT |
MARA
General Material Data
|
MANDT |
| S126 | MATNR | S126 | MATNR |
MARA
General Material Data
|
MATNR |
| S126 | POSNR | S126 | POSNR |
VBUP
Sales Document: Item Status
|
POSNR |
| S126 | POSNR | S126 | MANDT |
VBUP
Sales Document: Item Status
|
MANDT |
| S126 | POSNR | S126 | VBELN |
VBUP
Sales Document: Item Status
|
VBELN |
| S126 | SPART | S126 | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| S126 | SPART | S126 | SPART |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| S126 | STWAE | S126 | MANDT |
TCURC
Currency Codes
|
MANDT |
| S126 | STWAE | S126 | STWAE |
TCURC
Currency Codes
|
WAERS |
| S126 | VBELN | S126 | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| S126 | VBELN | S126 | VBELN |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| S126 | VKORG | S126 | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| S126 | VKORG | S126 | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| S126 | VTWEG | S126 | VKORG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VKORG |
| S126 | VTWEG | S126 | VTWEG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VTWEG |
| S126 | VTWEG | S126 | MANDT |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
MANDT |
| S126 | WERKS | S126 | WERKS |
T001W
Plants/Branches
|
WERKS |
| S126 | WERKS | S126 | MANDT |
T001W
Plants/Branches
|
MANDT |