| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 232 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
2 | A4AA | PurchOrg/Vendor/Plant/Info Record/Material/Segment | 9 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
3 | EINSGT | Purchasing Info Record: Segmentation Specific Data | 6 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
4 | SGT_BOMC | Segmentation for BOM items | 6 | SGT_SCAT | Segmentation Value | nvarchar | 16 | 0 | | |
5 | SGT_CMRP | MRP: Req.-Stock-Segmentation-Allocation | 7 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
6 | SGT_CRSC | MRP Sourcing Proposals: Req.- into Stock-Seg. Conversion | 5 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
7 | SGT_CSRC | MRP Secondary Requirements Creation: St.- into Req.-Seg.Co | 4 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
8 | SGT_MADKA | Segmentation Dependent Valuation data | 4 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
9 | SGT_MARM | Segmentation | Weights and Volumes | 4 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
10 | SGT_MLGN | Segmentation dependent Material Data for Each Warehouse no | 4 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
11 | SGT_MLGT | Segmentation dependent Material Data for Each Storage Type | 5 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
12 | SGT_PLKOS | Task list - header - Segmentation | 6 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
13 | SGT_VALS | Segmentation-Valid Combinations | 4 | SGT_SCAT | Segmentation Value | nvarchar | 16 | 0 | | |
14 | ZEIM_AFPO | Order item | 91 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
15 | ZEIM_LIPS | SD document: Delivery: Item data | 286 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPBilling |
16 | VBRP | Billing Document: Item Data | 196 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPConfirmations |
17 | AFFW | Goods Movements with Errors from Confirmations | 79 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPInventory Management |
18 | ISEG | Physical Inventory Document Items | 57 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
19 | MSEG | Document Segment: Material | 199 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
20 | RESB | Reservation/dependent requirements | 191 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPInvoice Verification |
21 | RSEG | Document Item: Incoming Invoice | 94 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPMaster Data |
22 | PLAF | Planned Order | 122 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPMaterial Master |
23 | MCH1 | Batches (if Batch Management Cross-Plant) | 35 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
24 | MCHA | Batches | 37 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
25 | MCHB | Batch Stocks | 38 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
26 | MSKA | Sales Order Stock | 33 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
27 | MSKU | Special Stocks with Customer | 27 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPMaterials Management |
28 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 191 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPProduct Cost Planning |
29 | KALM | Costing Run: Costing Objects | 75 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
30 | KEKO | Product Costing - Header Data | 127 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPProduction Orders |
31 | AFPO | Order item | 91 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPPurchasing |
32 | EBAN | Purchase Requisition | 157 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
33 | EKBE | History per Purchasing Document | 76 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
34 | EKBEH | Removed PO History Records | 76 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
35 | EKPO | Purchasing Document Item | 345 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPRepetitive Manufacturing |
36 | COMPMOVE | Goods Movement of Components | 62 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPShipping |
37 | LIPS | SD document: Delivery: Item data | 286 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPSimulation |
38 | VSAFPO_CN | Version: Order items in PP orders | 92 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
TOPWarehouse Management |
39 | LINV | Inventory data per quant | 39 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
40 | LQUA | Quants | 58 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
41 | LQUAB | Total quant counts for certain strategies | 15 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
42 | LSEG | Document for Inward and Outward Movements | 27 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
43 | LTAP | Transfer order item | 161 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
44 | LTBP | Transfer requirement item | 47 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |
45 | LUBU | Posting Change Document | 52 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | |