| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/DQQ9 | Clearing Rules | 5 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
2 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 106 | VGTYP | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 91 | VGTYP | | nvarchar | 1 | 0 | | |
4 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 85 | VGTYP | | nvarchar | 1 | 0 | | |
5 | MSPT_OIGSI | Shipment Item to store deleted records | 6 | VGTYP | SD document category | nvarchar | 1 | 0 | | |
6 | T028B | Transaction Type of Sender Bank | 4 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
7 | TCO60 | Sequence keys for input facility and verification | 6 | VGTYP | Activity type: Internal, external or general cost | nvarchar | 1 | 0 | | |
8 | ZEIM_LIPS | SD document: Delivery: Item data | 100 | VGTYP | SD document category | nvarchar | 1 | 0 | | |
9 | ZEIM_VBAK | Sales Document: Header Data | 89 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
10 | ZEIM_VBAP | Sales Document: Item Data | 159 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPAdvertising Management |
11 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 58 | VGTYP | IS-M: Preceding Sales Document Category | nvarchar | 1 | 0 | | |
TOPBasic Functions |
12 | FEBKO | Electronic Bank Statement Header Records | 45 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
13 | T028G | Allocate External to Internal Transactions | 2 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
14 | T028X | Returns Reasons | 2 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
TOPBilling |
15 | VBRP | Billing Document: Item Data | 27 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
16 | TFK028G | Allocate Ext.Trans.Code from Elec.Acct.Statement to FICA Obj | 2 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
17 | TFK028G_B | Brazil: Assign External Transactions to Internal Codes | 2 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
18 | VVBAK | Sales Document: Header Data | 89 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
19 | VVBAP | Sales Document: Item Data | 159 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPCross-Application Topics |
20 | /SPE/CD_PROC_ITM | Cross-Docking Process: Item Information | 11 | VGTYP | SD document category | nvarchar | 1 | 0 | | |
TOPData Collection |
21 | S260 | SD - Sales order | 86 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
22 | S260BIW1 | SD - Sales order | 86 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
23 | S260BIW2 | SD - Sales order | 86 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
24 | S261 | SD - Delivery note | 47 | VGTYP | Activity or element category | nvarchar | 3 | 0 | | |
25 | S261BIW1 | SD - Delivery note | 47 | VGTYP | Activity or element category | nvarchar | 3 | 0 | | |
26 | S261BIW2 | SD - Delivery note | 47 | VGTYP | Activity or element category | nvarchar | 3 | 0 | | |
27 | S264 | SD- Offer | 88 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
28 | S264BIW1 | S264BIW1 * SD - Quotation | 88 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
29 | S264BIW2 | S264BIW2 * SD - Quotation | 88 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPData Retention Tool |
30 | TXW_S_LIPS | Retrieve LIPS from archive | 14 | VGTYP | SD document category | nvarchar | 1 | 0 | | |
31 | TXW_S_VBAP | Retrieve VBAP from archive | 19 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
32 | TXW_S_VBRP | Retrieve VBRP from archive | 14 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
33 | T028V | Transaction Types | 2 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
34 | T028W | Transaction Types: Names | 3 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
TOPFunds Management |
35 | FMLGD_H_CUST | Note to Payee Control | 3 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
36 | FMLGD_H_MSGNR | Message Control | 3 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
TOPFunds Management-Specific Postings |
37 | FMPDCUST | Customizing for Payment Distributions | 5 | VGTYP | Transaction Type for Clearing Control | nvarchar | 8 | 0 | | |
TOPIntegration |
38 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 10 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPLocalization |
39 | J_1B_ERROR | Definition of error code per bank and return code | 2 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
40 | J_1B_ERTXT | Defintion of error code per bank and return code | 3 | VGTYP | Transaction type | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
41 | JLRP | IS-M/SD: Item Data for Settlement | 18 | VGTYP | SD document category | nvarchar | 1 | 0 | | |
TOPRecycling Administration Core Functions |
42 | J_7LBDCMSG | REA Conditions: Error Messages BDC Condition Adjustment | 24 | VGTYP | Transaction Category | nvarchar | 1 | 0 | | |
43 | J_7LC41 | REA Data Filter: Country Allocations | 3 | VGTYP | Transaction Category | nvarchar | 1 | 0 | | |
44 | J_7LC43 | REA Data Filter: Filter Type Definition | 7 | VGTYP | Transaction Category | nvarchar | 1 | 0 | | |
45 | J_7LC43W | REA Data Filter: Filter Type Definition | 7 | VGTYP | Transaction Category | nvarchar | 1 | 0 | | |
46 | J_7LC44 | REA Data Filter: Field Definition Country Assignment | 4 | VGTYP | Transaction Category | nvarchar | 1 | 0 | | |
47 | J_7LV1M | REA Document: Quantity Flow on Article Level | 15 | VGTYP | Transaction Category | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
48 | /BEV1/RBVBAK | Sales Document: Header Data | 89 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
49 | /BEV1/RBVBAP | Sales Document: Item Data | 159 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPSales |
50 | VBAK | Sales Document: Header Data | 89 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
51 | VBAP | Sales Document: Item Data | 159 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPShipping |
52 | LIPS | SD document: Delivery: Item data | 100 | VGTYP | SD document category | nvarchar | 1 | 0 | | |
TOPSimulation |
53 | VSVBAK_CN | Version: Sales document: Header data | 90 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
54 | VSVBAP_CN | Version: Sales document: Item data | 160 | VGTYP | Document category of preceding SD document | nvarchar | 1 | 0 | | |
TOPTransportation and Distribution |
55 | OIGSI | Shipment Item | 6 | VGTYP | SD document category | nvarchar | 1 | 0 | | |