| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZEIM_VBAP | Sales Document: Item Data | 294 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
TOPExchanges |
2 | A337 | ContractNr/Plant | 4 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
TOPMarketing, Accounting and Pricing |
3 | A402 | SalesOrg/DistribCh/SDContractNo/Material | 6 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
4 | A403 | SalesOrg/DistribCh/SDContractNo/Plant/Material | 6 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
TOPProduction and Revenue Accounting |
5 | A405 | ContractNr/Well/WC/Material (obsolete -> replaced by A416) | 4 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
6 | A411 | ContractNr/MP ID/Material (obsolete -> replaced by A438) | 4 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
7 | A417 | ContractNr/Material (obsolete -> replaced by A440) | 4 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
8 | OIU_RV_CNDKY | Condition PPN field cross reference | 5 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
TOPRevenue |
9 | OIURV03_FRMHDR | Valuation Transaction Level 3 - Formula | 38 | OICONTNR | Contract Number | nvarchar | 10 | 0 | | |
TOPSales |
10 | VBAP | Sales Document: Item Data | 301 | OICONTNR | Outline agreement: contract | nvarchar | 10 | 0 | | |
TOPValuation |
11 | OIURV_DOC_FRMHDR | Valuation Transaction Level 3 - Formula | 38 | OICONTNR | Contract Number | nvarchar | 10 | 0 | | |
12 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 25 | OICONTNR | Contract Number | nvarchar | 10 | 0 | | |