| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
2 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
3 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
4 | BSEG | Accounting Document Segment | 69 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
5 | BSID_BAK | Accounting: Secondary Index for Customers | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
6 | BSIK_BAK | Accounting: Secondary index for vendors | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
7 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
8 | BSSEG | Accounting Document Segment | 58 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
9 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
10 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
11 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 58 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
12 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 58 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
13 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 58 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
14 | REGUP | Processed items from payment program | 79 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
15 | T037S | Account Assignment References acc. to Transaction Type | 9 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
16 | ZEIM_AFPO | Order item | 7 | PROJN | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
TOPActual CostingMaterial Ledger |
17 | CKMLMV013 | Assignment table: Process for production order | 13 | PROJN | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
TOPBasic Functions |
18 | ANLA | Asset Master Record Segment | 45 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
19 | VBBE | Sales Requirements: Individual Records | 22 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPCross-Application Components |
20 | BBSID | Accounting: Secondary index for customers | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPData Collection |
21 | CF003 | Projects | 45 | PROJN | Project number | nvarchar | 16 | 0 | | |
TOPData Retention Tool |
22 | TXW_S_BSEG | Retrieve BSEG from archive | 71 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
23 | TXW_S_MSEG | Retrieve MSEG from archive | 45 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPFinancial Accounting |
24 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
25 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
26 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
27 | BSID | Accounting: Secondary Index for Customers | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
28 | BSIK | Accounting: Secondary Index for Vendors | 31 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
29 | BSIS | Accounting: Secondary Index for G/L Accounts | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPGeneral Ledger Accounting |
30 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
31 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPInformation System |
32 | DSKOP | Balance Audit Trail | 70 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPInventory Management |
33 | MSEG | Document Segment: Material | 57 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
34 | MWXMSEG | ZMSEG: Interface for Posting of Value | 57 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
35 | MWZMSEG | ZMSEG:Interface for Posting of Value | 57 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
36 | RESB | Reservation/dependent requirements | 37 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
37 | RKPF | Document Header: Reservation | 10 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
38 | T8J3E | JV Non-operated Billing Operator Codes | 5 | PROJN | JV Project | nvarchar | 8 | 0 | | |
39 | T8J4B | JV Cash Call Batch table | 8 | PROJN | Project Number | nvarchar | 8 | 0 | | |
40 | T8J4D | Non-op Billing Item Table (Deprecated -> replaced by T8J4H) | 11 | PROJN | WBS Element | nvarchar | 8 | 0 | | |
41 | T8J4H | Non-Op saved bills - Detail Info (for holding bills) | 19 | PROJN | Project Number | nvarchar | 8 | 0 | | |
TOPMaster Data |
42 | PLAF | Planned Order | 25 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPProduction Orders |
43 | AFPO | Order item | 7 | PROJN | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
44 | AFVC | Operation within an order | 80 | PROJN | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
TOPProject System |
45 | PSHLPDB_HIER_TMP | Table to store temporary hierarchy data | 22 | PROJN | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
46 | PSHLP_HIER_DB | Local cache:Project/Independent Network hierarchy | 22 | PROJN | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
TOPPurchasing |
47 | EBKN | Purchase Requisition Account Assignment | 13 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
48 | EKKN | Account Assignment in Purchasing Document | 14 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPReal Estate Management |
49 | VIBEBE | Correction items for input tax treatment | 4 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
50 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 60 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
TOPSimulation |
51 | VSAFPO_CN | Version: Order items in PP orders | 8 | PROJN | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
52 | VSAFVC_CN | Version: Operation in order | 81 | PROJN | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
53 | VSEBKN_CN | Version: Purchase requisition account assignment | 14 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
54 | VSPLAF_CN | Version: Planned order | 26 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |
55 | VSRESB_CN | Version: Reservation/Dependent requirements | 38 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | |