| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ARBA/AN_ISUINV | Temp table for BTE ISU | 7 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
2 | /ARBA/INVCOMMENT | Invoice Status update comments table | 3 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
3 | /ARBA/INVSTATUPD | Temp table for BTE ISU | 5 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
4 | /BIC/B0000190000 | PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data | 10 | DOC_DATE | | nvarchar | 8 | 0 | | |
5 | /BIC/B0000191000 | PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups | 10 | DOC_DATE | | nvarchar | 8 | 0 | | |
6 | /BIC/B0000192000 | PSA for 0MM_PUR_SRV_LEVEL T90CLNT090 PO Service Level | 12 | DOC_DATE | | nvarchar | 8 | 0 | | |
7 | /GBT/O_DLVY_HDR | Delivery | 19 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
8 | /OPT/VT_DOC_HEA1 | Document Header - copy of /opt/vt_doc_head | 21 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
9 | /OPT/VT_DOC_HEAD | Document Header | 21 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
10 | BBP_PCGEN | Procurement Card Statements: General Data | 5 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
11 | CMCBD_DOCUMENT | Cash Budgeting Document | 5 | DOC_DATE | Posting Date | nvarchar | 8 | 0 | | |
12 | FIEUD_SBINV_H | SAFT: Self Billing Invoices (Header)- (MM) | 9 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
13 | J_3RFSPD_ITEM | Supporting document statement Items data | 11 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
14 | PCARD_ARIDX | Index for single doc access fpr arc object bbp_pc_arc | 4 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
15 | RAM1 | test | 3 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
16 | REQHEADS | Temporary Header Data: Requirement Coverage Request (Limit) | 60 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
17 | FDM_DOC_MIRROR | Document Information (Raw Data in Substitute System) | 25 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPBasic Functions |
18 | TTXU | External tax interface: Audit file update information | 7 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPBasis Components |
19 | /XFT/INV_Q | Invoice receipt queue: Header | 38 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
20 | /XFT/INV_Q_S | Invoice receipt queue: Header | 38 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPBudgeting and Availability Control |
21 | GMBDGTHEADER | Budget Document Header | 20 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
22 | GMHBDGTHEADER | Budget Header: Held Documents | 21 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
23 | DFKKORDER | Requests: Header Data | 7 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
24 | DFKKORDERAPPROVE | Requests to be Approved | 5 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
25 | DFKKORDER_S | Request Templates: Header Data | 7 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
26 | /OPT/S_PO_HIST | VSS Staging Table: PO history | 12 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
27 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 31 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
28 | /OPT/VIM_HD_NPO | VIM IE Monitor: Header Data for Parked NPO Invoices | 10 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
29 | /OPT/VIM_HD_PO | VIM IE Monitor: Header Data for Parked PO Invoices | 13 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPDealer Portal |
30 | /SAPDII/SPP_MATE | Materials table | 6 | DOC_DATE | Date | nvarchar | 8 | 0 | | |
TOPDistributor-Reseller-Management |
31 | /SAPHT/DRMR3XN | DRM relevant ERP Transactions | 33 | DOC_DATE | Document creation date | nvarchar | 8 | 0 | | |
TOPDown Payment Chains |
32 | /SAPPCE/TDPC20 | Down Payment Chain: Document Header | 9 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPDSD Connector |
33 | /DSD/ME_OPIM_HD | DSD CN: Open Items header data | 5 | DOC_DATE | DSD Connector: Document Date | nvarchar | 8 | 0 | | |
TOPIncentive and Commission Management ICM |
34 | CACSFI_DOCFI_HD | Settlement to FI: Reference Document Header | 5 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
35 | T8JFRM | Farm In/Out & Re-Determination (Farm) Main Table | 12 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
36 | T8JFRM_STP | Farm In/Out & Re-Determination (Farm) Main Table | 8 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPLoans Management |
37 | VDCHK_GROSS_NET | Storage of data for report RFVD_GROSS_TO_NET | 13 | DOC_DATE | Due date | nvarchar | 8 | 0 | | |
TOPMaster Data |
38 | CMS_AST_DOC | Asset Documents | 6 | DOC_DATE | Document Date | nvarchar | 8 | 0 | | |
39 | CMS_CAG_DOC | Collateral Agreement Documents | 6 | DOC_DATE | Document Date | nvarchar | 8 | 0 | | |
40 | CMS_OMS_DOC_LNK | Documents Link | 6 | DOC_DATE | Document Date | nvarchar | 8 | 0 | | |
TOPReal Estate |
41 | CMS_RE_PRT_DOC | Real Estate Document details | 7 | DOC_DATE | Document Date | nvarchar | 8 | 0 | | |
TOPSAP Retail Store |
42 | WGMH_SRS | Head for SRS PDC Goodsmovement | 13 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
43 | WSGM_HEAD_DB_TMP | SRS GM: Temporary Persistence for Header Data | 7 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
44 | WSGR_HEAD_DB_TMP | SRS GM: Temporary Persistence for Header Data | 14 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
TOPSecurities |
45 | CMS_SEC_ACC_DOC | Link between securities account and Documents is stored here | 6 | DOC_DATE | Document Date | nvarchar | 8 | 0 | | |
TOPVehicle Management System |
46 | VLCBATCHACT | VELO : Variant for Action Execution in Batch | 22 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | |