| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 108 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 108 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
3 | CNVTDMS_05_IKPF | Fill Header Physical Inventory Document | 3 | IBLNR | BELNR for CNVTDMS_05_* | nvarchar | 10 | 0 | | |
4 | CNV_20000_IKPF | Backup copy of IKPF (header for phys. inventory document) | 2 | IBLNR | Physical inventory document | nvarchar | 10 | 0 | | |
5 | TXSTA | MM Inventory Mngmt: Work Table for Phys. Inv. Doc. Archiving | 1 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPActual CostingMaterial Ledger |
6 | CKMLDUV | Distribution of Usage Diff.(Status for each ISEG entry) | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
7 | CKMLDUVCO | Usage Differences for Each Account Assignment Object | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
8 | EKLPCI | History of Charges for Installment Plan Items (LPC in USA) | 4 | IBLNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | |
TOPDistribution of Usage Variances |
9 | CKMLDUVN | Distribution of Usage Diff.(Status for each ISEG entry) | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
10 | CKMLDUVNCO | Usage Differences for Each Account Assignment Object | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPEquipment |
11 | EQUZ | Equipment time segment | 39 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
12 | IEQT_WL_ITEMS | Interim Statuses - Items | 57 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
13 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 58 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPHydrocarbon Product Management |
14 | ISEGO1 | Appendix for Physical Inventory Conversion Parameters | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
15 | ISEGO2 | Appendix for Physical Inventory Additional Quantities | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPIndustry Solution Catch Weight Management |
16 | /CWM/QM_COUNT | Count Data Table for Insp. Lot-Related Phys. Inv. in CWM | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPInterface to Terminal Automation System |
17 | OIK02B | IS-OIL/TAS: Status of processed functions - messages | 27 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPInventory Management |
18 | IKPF | Header: Physical Inventory Document | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
19 | ISEG | Physical Inventory Document Items | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
20 | T159I | Test Data for Batch Input in Inventory Management (Phys.Inv) | 11 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPInvoicing |
21 | EKLPCINV | History of Charges for Installment Plan Items (LPC in USA) | 4 | IBLNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | |
TOPLocalization |
22 | J_3R_INVDIFF | Offsetting inventory differences of goods | 2 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPSAP Retail Store |
23 | WSTI_PDC_EVENT | Retail Store Physical Inventory: PDC Transactions | 6 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |
TOPSerial Numbers |
24 | SER07 | Document Header for Serial Numbers in Physical Inventory | 3 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | | |