| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PPH_PFE_CHANGE | Table for PFE changes | 4 | BERID | MRP Area | nvarchar | 10 | 0 | | |
2 | T449U | Settings for Collective Display of MRP List | 32 | BERID | MRP Area | nvarchar | 10 | 0 | | |
3 | ZEIM_AFPO | Order item | 89 | BERID | MRP Area | nvarchar | 10 | 0 | | |
4 | ZEIM_LIPS | SD document: Delivery: Item data | 206 | BERID | MRP Area | nvarchar | 10 | 0 | | |
5 | ZEIM_VBAP | Sales Document: Item Data | 204 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPAvailability Check |
6 | LATP_ENQ | Persistent Lock Records for ATP in R/3 from External Systems | 11 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPBasic Functions |
7 | VBBE | Sales Requirements: Individual Records | 7 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPConsumption-Based Planning See Also PP-MRP |
8 | DBPROF | Forecast Error with MRP Areas | 3 | BERID | MRP Area | nvarchar | 10 | 0 | | |
9 | DBPRON | Reproc. of Forecast Errors and Excpn Messages with MRP Area | 3 | BERID | MRP Area | nvarchar | 10 | 0 | | |
10 | MAHD | Alternative Required Time Series for the Forecast | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
11 | MAHD_OVAL | Original Values for Alternative RPM Time Series for Forecast | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
12 | VVBAP | Sales Document: Item Data | 204 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPDefense Forces and Public Security |
13 | /ISDFPS/ZEBAN | Copy of EBAN | 112 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPDemand Management |
14 | PBID | Planned independent requirements index: MRP area | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
15 | T459U | Settings for Maintaining Planned Independent Requirements | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPManufacturer Part Number |
16 | ADPIC_HOLD_MPN | Store MPN subitems for MIGO hold / restore functionality | 26 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPMaster Data |
17 | DBPR | Material Index MRP Area for Forecast | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
18 | DBVL | Planning File Entry, MRP Area, Long-Term Planning | 6 | BERID | MRP Area | nvarchar | 10 | 0 | | |
19 | DBVM | Planning File Entry, MRP Area | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
20 | DVER | Material Consumption for MRP Area | 3 | BERID | MRP Area | nvarchar | 10 | 0 | | |
21 | EMRP_RUN | Blocking argument for MRP | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
22 | KBVL | Individual Customer Plng File Entry, MRP Area Long-Term Plng | 6 | BERID | MRP Area | nvarchar | 10 | 0 | | |
23 | KBVM | Individual Customer Planning File Entry, MRP Area | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
24 | MDCOV | Table with Range of Coverage Information | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
25 | MDDMAP | Mapping Table for External User for MRP Evaluations | 8 | BERID | MRP Area | nvarchar | 10 | 0 | | |
26 | MDFDDB | Firming Data of MRP - MRP Area | 3 | BERID | MRP Area | nvarchar | 10 | 0 | | |
27 | MDKPDB | Header Data for MRP Document | 4 | BERID | MRP Area | nvarchar | 10 | 0 | | |
28 | MDLG | Customizing: MRP Area Storage Location | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
29 | MDLL | Customizing: MRP Area Subcontractor | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
30 | MDLV | Customizing MRP Area | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
31 | MDLW | Customizing: MRP Area Plants | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
32 | MDMA | MRP Area for Material | 3 | BERID | MRP Area | nvarchar | 10 | 0 | | |
33 | MDMULTLEVDELAY | Multilevel Delay Calculated via Order Report | 19 | BERID | MRP Area | nvarchar | 10 | 0 | | |
34 | MDSEQ | Customizing: Sequence of MRP in Scope of Planning | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
35 | PLAF | Planned Order | 109 | BERID | MRP Area | nvarchar | 10 | 0 | | |
36 | T439C | Scope of Planning MRP Unit: Sequence | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPMaterial Requirements Planning |
37 | CIFMDLGVR | Versions of Table MDLG | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
38 | CIFMDLVVR | Versions of Table MDLV | 2 | BERID | MRP Area | nvarchar | 10 | 0 | | |
39 | CIFMDMAVR | Versions of Table MDMA | 4 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPMaterials Management |
40 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 118 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPProduction Orders |
41 | AFPO | Order item | 89 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPPurchasing |
42 | EBAN | Purchase Requisition | 112 | BERID | MRP Area | nvarchar | 10 | 0 | | |
43 | EKPO | Purchasing Document Item | 199 | BERID | MRP Area | nvarchar | 10 | 0 | | |
44 | MEREQX | Purchase Requisition Change Parameter | 112 | BERID | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
45 | /BEV1/RBVBAP | Sales Document: Item Data | 204 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPSales |
46 | VBAP | Sales Document: Item Data | 204 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPSCM Basis |
47 | CIF_IMMRPA | Integration Model Reference Table for MRP Areas | 2 | BERID | MRP Area | nvarchar | 20 | 0 | | |
48 | CIF_IMMTMRPA | Integration Model Reference Table for Material | 3 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPShipping |
49 | LIPS | SD document: Delivery: Item data | 206 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPSimulation |
50 | VSAFPO_CN | Version: Order items in PP orders | 90 | BERID | MRP Area | nvarchar | 10 | 0 | | |
51 | VSEBAN_CN | Version: Purchase requisition | 113 | BERID | MRP Area | nvarchar | 10 | 0 | | |
52 | VSPLAF_CN | Version: Planned order | 110 | BERID | MRP Area | nvarchar | 10 | 0 | | |
53 | VSVBAP_CN | Version: Sales document: Item data | 205 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPStructures Workbench |
54 | /ISDFPS/FORSUPLC | Control Data: Logistics | 5 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPSupersession Chains |
55 | PICRL | Parts Interchangeability Relation (Plant/MRP Area) | 7 | BERID | MRP Area | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
56 | OIJBER | Berth Table | 2 | BERID | Berth identifier | nvarchar | 20 | 0 | | |
57 | OIJBERLOC | Index table for berths at TSW locations | 3 | BERID | Berth identifier | nvarchar | 20 | 0 | | |
58 | OIJBERMAT | Assignment of material to berths | 2 | BERID | Berth identifier | nvarchar | 20 | 0 | | |
59 | OIJBERSOC | Assignment of berths to tanks | 3 | BERID | Berth identifier | nvarchar | 20 | 0 | | |
60 | OIJNE | Nomination Events | 50 | BERID | Berth identifier | nvarchar | 20 | 0 | | |
61 | OIJNOMI_LDS | Load / Discharge scheduling for nominations | 13 | BERID | Berth identifier | nvarchar | 20 | 0 | | |