| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000187000 | PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item) | 6 | BEDAT | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000188000 | PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header) | 9 | BEDAT | | nvarchar | 8 | 0 | | |
3 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 6 | BEDAT | | nvarchar | 8 | 0 | | |
4 | FIEUD_MMINV_I | SAFT:MM: Item Details for XML Purchase Invoice | 10 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
5 | FIWTQAD_CERT | Withholding tax certificate details | 9 | BEDAT | Purchasing Document Date | nvarchar | 8 | 0 | | |
6 | IDSAU_WT_CERT | Withholding tax certificate details | 9 | BEDAT | Purchasing Document Date | nvarchar | 8 | 0 | | |
7 | P2RB_I0125 | Garnishment payroll Belgium | 35 | BEDAT | Date signature | nvarchar | 8 | 0 | | |
8 | PA0297 | HR Master Record: Infotype 0297 Work conditions | 47 | BEDAT | Start Date | nvarchar | 8 | 0 | | |
TOPAllocation |
9 | AUBSI | Worklist for PO (Follow-on Document Generation) | 2 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
10 | AUFI | Allocation Table, Document Sub-item, Stores | 27 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
11 | AULW | Delivery Phases | 21 | BEDAT | Order date/ latest date for generating follow-on documents | nvarchar | 8 | 0 | | |
12 | AUVW | Delivery Phase for Distribution Center | 17 | BEDAT | Order date/ latest date for generating follow-on documents | nvarchar | 8 | 0 | | |
TOPBasic Functions |
13 | FPLA | Billing Plan | 6 | BEDAT | Start date for billing plan/invoice plan | nvarchar | 8 | 0 | | |
14 | FPLAPO | Billing Plan | 6 | BEDAT | Start date for billing plan/invoice plan | nvarchar | 8 | 0 | | |
15 | VBSK | Collective Processing for a Sales Document Header | 25 | BEDAT | Date of deliveries in picking waves | nvarchar | 8 | 0 | | |
16 | VFPLA | Billing Plan | 6 | BEDAT | Start date for billing plan/invoice plan | nvarchar | 8 | 0 | | |
TOPBelgium |
17 | PA0125 | HR Master Record: Infotype 0125 (Garnishment B) | 42 | BEDAT | Date signature | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
18 | FRE_OP_ITEM_IN | F&R CON R/3 - Order Proposal Inbound Item Buffer | 13 | BEDAT | Order date of schedule line | nvarchar | 8 | 0 | | |
TOPData Collection |
19 | S270 | Do not use! | 44 | BEDAT | Document date | nvarchar | 8 | 0 | | |
20 | S270BIW1 | Do not use! | 44 | BEDAT | Document date | nvarchar | 8 | 0 | | |
21 | S270BIW2 | Do not use! | 44 | BEDAT | Document date | nvarchar | 8 | 0 | | |
22 | S275 | Transfer BW: Einkaufsdaten | 34 | BEDAT | Datum van inkoopdocument | nvarchar | 8 | 0 | | |
23 | S275BIW1 | S275BIW1 * Transfer to BW: Purchasing Data | 34 | BEDAT | Purchasing Document Date | nvarchar | 8 | 0 | | |
24 | S275BIW2 | S275BIW2 * Transfer to BW: Purchasing Data | 34 | BEDAT | Purchasing Document Date | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
25 | TXW_S_EKKO | Retrieve EKKO from archive | 10 | BEDAT | Purchasing Document Date | nvarchar | 8 | 0 | | |
TOPDefense Forces and Public Security |
26 | /ISDFPS/ZEBAN | Copy of EBAN | 61 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
TOPMaterials Management |
27 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 66 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
TOPPayroll |
28 | PA0637 | Személyügyi törzsrekord 0637 infótípus | 28 | BEDAT | Bejelentés idopontja | nvarchar | 8 | 0 | | |
TOPPOS Interface |
29 | WVFB | DRS Interface, Intermediate Buffer, Order Item FM | 34 | BEDAT | Order date of schedule line | nvarchar | 8 | 0 | | |
30 | WVFB2 | SRS: received external requirement numbers/phys. inv. nos | 5 | BEDAT | Order date of schedule line | nvarchar | 8 | 0 | | |
TOPProduct Cost Planning |
31 | KALA | Costing Run: General Data/Parameters | 10 | BEDAT | Requirements Date | nvarchar | 8 | 0 | | |
32 | KALM | Costing Run: Costing Objects | 34 | BEDAT | Requirements Date | nvarchar | 8 | 0 | | |
33 | KALO | Costing Run: Costing Objects (KVMK) | 28 | BEDAT | Requirements Date | nvarchar | 8 | 0 | | |
34 | KEKO | Product Costing - Header Data | 20 | BEDAT | Requirements Date | nvarchar | 8 | 0 | | |
TOPPromotion |
35 | WAKP | Promotion Item Data | 46 | BEDAT | Order date with vendor | nvarchar | 8 | 0 | | |
TOPPurchase Orders |
36 | WBO1 | Log header file for simulative list for load building | 18 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
TOPPurchasing |
37 | EBAN | Purchase Requisition | 61 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
38 | EIPA | Order Price History: Info Record | 8 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
39 | EKAB | Release Documentation | 6 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
40 | EKET | Scheduling Agreement Schedule Lines | 19 | BEDAT | Order date of schedule line | nvarchar | 8 | 0 | | |
41 | EKETH | Scheduling Agreement Schedules: History Tables | 19 | BEDAT | Order date of schedule line | nvarchar | 8 | 0 | | |
42 | EKKO | Purchasing Document Header | 26 | BEDAT | Purchasing Document Date | nvarchar | 8 | 0 | | |
43 | MEREQX | Purchase Requisition Change Parameter | 61 | BEDAT | Updated information in related user data field | nvarchar | 1 | 0 | | |
44 | WDFR_DISP | Perishables Planning Header | 91 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
45 | WRF_PRCT_WL_ITEM | Original Table for Worklist Items | 10 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
46 | WRF_PRCT_WL_SHDW | Shadow Table for Worklist Items | 13 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
TOPPurchasing Information System |
47 | MCEKS | R/2 PURCHIS Data (Status: Last Data Transmission) | 28 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
TOPSAP Retail Store |
48 | WOSA | SAP Retail Store, Store Orders: Entities Table | 8 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
TOPShipping |
49 | LIPSPO | LIPS Reference Data Purchase Order | 13 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
TOPSimulation |
50 | VSEBAN_CN | Version: Purchase requisition | 62 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |
51 | VSFPLA_CN | Version: Billing schedule | 7 | BEDAT | Start date for billing plan/invoice plan | nvarchar | 8 | 0 | | |
TOPTraders and Schedulers Workbench |
52 | S431 | PURCHIS: (OIL-TSW) Purchasing document stats by TSW object | 27 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | |