Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Defense Forces and Public Security | ||||||||||
1 | /ISDFPS/ZEBAN | Copy of EBAN | 45 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
External Services | ||||||||||
2 | TMP_SPEC | Model Service Specifications | 22 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
Master Data | ||||||||||
3 | PLAF | Planned Order | 29 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
Material | ||||||||||
4 | RSADD | Additional fields for reservation | 17 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
Materials Management | ||||||||||
5 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 50 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
Purchasing | ||||||||||
6 | EBAN | Purchase Requisition | 45 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
7 | MEREQX | Purchase Requisition Change Parameter | 45 | FLIEF | Updated information in related user data field | nvarchar | 1 | 0 | ||
Self-Service Procurement | ||||||||||
8 | /SRMERP/D_SC_ITM | Shopping Cart Item | 55 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
Simulation | ||||||||||
9 | VSEBAN_CN | Version: Purchase requisition | 46 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
10 | VSPLAF_CN | Version: Planned order | 30 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | ||
11 | VSRSADD_CN | Version: Additional fields for reservation | 18 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 |