S126 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S126 in SAP.
- Table description : Open Variants - Basis 1
- Module : CRM
- Parent Module : CRM
- Package : MCS
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP S126 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| VBELN | Sales Document | VBELN_VA | VBELN |
| POSNR | Sales Document Item | POSNR_VA | POSNR |
| CUOBJ | Configuration | CUOBJ_VA | CUOBJ |
| PERIV | Fiscal Year Variant | PERIV | PERIV |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| BASME | Base Unit of Measure | MEINS | MEINS |
| STWAE | Statistics currency | STWAE | WAERS |
| MCUPD | Indicator whether statistical record was updated | MCUPD | X |
| VKORG | Sales Organization | VKORG | VKORG |
| VTWEG | Distribution Channel | VTWEG | VTWEG |
| SPART | Division | SPART | SPART |
| KUNNR | Sold-to party | KUNAG | KUNNR |
| WERKS | Plant | WERKS_D | WERKS |
| MATNR | Material Number | MATNR | MATNR |
| AEMENGE | Incoming orders quantity | MC_AEMENGE | MENGV15_3 |
| AEMENGE_D | Quantity of incoming orders - delata updating | AEMENGE_D | MENGV15_3 |
| AENETWR | Net value of incoming orders | MC_AENETWR | WERTV10 |
| AENETWR_D | Net value of incoming orders - delta updating | AENETWR_D | WERTV10 |
| AEKZWI1 | Incoming orders: gross | MC_AEKZWI1 | WERTV9 |
| AEKZWI1_D | Gross incoming orders - delta updating | AEKZWI1_D | WERTV9 |
| AEKZWI2 | Incoming orders: net 1 | MC_AEKZWI2 | WERTV9 |
| AEKZWI2_D | Net incoming orders 1 - delta updating | AEKZWI2_D | WERTV9 |
| AEKZWI3 | Incoming orders: net 2 | MC_AEKZWI3 | WERTV9 |
| AEKZWI3_D | Net incoming orders 2 - delta updating | AEKZWI3_D | WERTV9 |
| AEKZWI4 | Incoming orders: freight | MC_AEKZWI4 | WERTV9 |
| AEKZWI4_D | Incoming orders (freight) - delta updating | AEKZWI4_D | WERTV9 |
| AEKZWI5 | Incoming orders: pricing subtotal 5 | MC_AEKZWI5 | WERTV9 |
| AEKZWI5_D | Incoming orders PrSub 5 - delta updating | AEKZWI5_D | WERTV9 |
| AEKZWI6 | Incoming orders: pricing subtotal 6 | MC_AEKZWI6 | WERTV9 |
| AEKZWI6_D | Incoming orders PrSub 6 - delta updating | AEKZWI6_D | WERTV9 |
| AEMENGB | Qty. incoming orders based on confirm. date of sched. line | AEMENGB | MENGV15_3 |
| AEMENGB_D | QtyIO based on confirmation date of sched. line - DeltaUpdat | AEMENGB_D | MENGV15_3 |
| OEIMEB | Open order qty. based on confirmation date of sched. line | OEIMEB | MENGV15_3 |
| OEIMEB_D | Open order quantity based on conf. date of sched. line-delta | OEIMEB_D | MENGV15_3 |
| OEIMEW | Open order qty. based on desired del. date of sched. line | OEIMEW | MENGV15_3 |
| OEIMEW_D | Open order qty. based on desired del.date of sch.line- delta | OEIMEW_D | MENGV15_3 |
| OEIWEB | Open order value based on confirmation date of sched. line | OEIWEB | WERTV10 |
| OEIWEB_D | Open order val. based on conf. date of sched. line - delta | OEIWEB_D | WERTV10 |
| OEIWEW | Open order value based on desired del. date of sched. line | OEIWEW | WERTV10 |
| OEIWEW_D | Open ord. val. based on desired del. date sched.line - delta | OEIWEW_D | WERTV10 |
| LGMNG | Delivery quantity in base unit of measure | MC_LGMNG | MENGV15_3 |
| LGMNG_D | Delivery qty in base unit of measure - Delta update | MC_LGMNG_D | MENGV15_3 |
| UMNETWR | Net value of invoiced sales | MC_UMNETWR | WERTV10 |
| UMNETWR_D | Invoiced sales net value - Delta update | UMNETWR_D | WERTV10 |
S126 related tables
| Table | Note |
|---|---|
| S126 | Open Variants - Basis 1 |
| S127 | Open Variants - Basis 2 |
| AKB_FREEZE | Frozen Basis Objects for Backwards-Compatible Basis (AKB) |
| AKB_FREEZE_EXT | Frozen Basis Objects for Backwards-Compatible Basis (AKB) |
| AKB_FREEZE_SRC | Frozen Basis Objects for Backwards-Compatible Basis (AKB) |
| RSBMON | Monitor Variants for Open Hub Monitor |
| S128 | Open Variants - SIS |
| S129 | Open Variants - Planning |
| S137 | Variants: Basis 2 |
| SHDSCCI | Standard variants (screen variants) |
| TFK021G | Screen variants: Description of variants |
| TFK021X | Screen variants (standard): Meaning of variants |
| AWU_FI | Linkage open FI with workflow (model function module) |
| BWPOS | Valuations for Open Items |
| BWPOSI | Valuations for Open Items |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP