| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000182000 | PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data | 19 | KUNAG | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 20 | KUNAG | | nvarchar | 10 | 0 | | |
3 | /BIC/B0000184000 | PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data | 20 | KUNAG | | nvarchar | 10 | 0 | | |
4 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 16 | KUNAG | | nvarchar | 10 | 0 | | |
5 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 16 | KUNAG | | nvarchar | 10 | 0 | | |
6 | MEV_D_AD_ITEM_SD | Period-End Valuation: Accruals Document Item SD | 14 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
7 | MEV_D_WL_ITEM | Period-end valuation: Worklist item | 41 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
8 | S730E | S730 - Structural information | 5 | KUNAG | Ship-to party | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
9 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 245 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
10 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 245 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
11 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 43 | KUNAG | Business Partner: Sold-to Party | nvarchar | 10 | 0 | | |
12 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 40 | KUNAG | Business Partner: Sold-to Party | nvarchar | 10 | 0 | | |
13 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 101 | KUNAG | Business Partner: Sold-to Party | nvarchar | 10 | 0 | | |
TOPAllocation |
14 | AUVDI | Worklist for Deliveries (Follow-on Doc. Generation) | 14 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPBasic Functions |
15 | FDS1 | Cash Management & Forecast: Line Items of SD Documents | 10 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPBilling |
16 | A146 | Customer Hierarchy | 11 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
17 | A147 | Customer Hierarchy (Sales Deal) | 11 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
18 | A149 | Customer-dependent data determination | 7 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
19 | VBRK | Billing Document: Header Data | 53 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
20 | VBRL | Sales Document: Invoice List | 9 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
21 | VRKPA | Sales Index: Bills by Partner Functions | 9 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
22 | VRPMA | SD Index: Billing Items per Material | 8 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPConditions |
23 | A901 | Sales org./Distr. Chl/Sold-to pt/Region | 6 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
24 | A907 | Sales org./Distr. Chl/Sold-to pt | 6 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
25 | A909 | Sales org./Distr. Chl/Sold-to pt/Incoterms/Inco. 2 | 6 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPConsumption-Based Planning See Also PP-MRP |
26 | EDMMS | Assignment of EDI partner to purchasing org. and plant | 3 | KUNAG | Sold-to party at customer, transferred via EDI by vendor | nvarchar | 20 | 0 | | |
TOPContract Accounts Receivable and Payable |
27 | FKK_JFRK_SHORT | Header Data for IS-M/SD Billing Document - Extracts | 11 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPCosting |
28 | COER | Sales Order Value Revenue | 29 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPData Collection |
29 | S008 | Communications Table SD -> CO/Projects | 25 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
30 | S108 | Additionals | 7 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
31 | S108E | S108 - Structural Information | 6 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
32 | S123 | Customer / material group | 13 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
33 | S123E | S123 - Structural Information | 8 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
34 | S124 | Customer / material | 9 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
35 | S124E | S124 - Structural Information | 4 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
36 | S130 | Replenishment | 10 | KUNAG | Ship-to party | nvarchar | 10 | 0 | | |
37 | S130E | S130 - Structural Information | 5 | KUNAG | Ship-to party | nvarchar | 10 | 0 | | |
38 | S261 | SD - Delivery note | 31 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
39 | S261BIW1 | SD - Delivery note | 31 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
40 | S261BIW2 | SD - Delivery note | 31 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
41 | S262 | SD - Billing document | 23 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
42 | S262BIW1 | SD - Billing document | 23 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
43 | S262BIW2 | SD - Billing document | 23 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
44 | S730 | copy of S130 Repl.m 4 VMI XI | 10 | KUNAG | Ship-to party | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
45 | TXW_S_LIKP | Retrieve LIKP from archive | 10 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
46 | TXW_S_VBRK | Retrieve VBRK from archive | 19 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPDelivery Confirmation |
47 | DELCONHD | Delivery Confirmation: Basis of Logistic.Match. - Header | 4 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPDistributor-Reseller-Management |
48 | A313 | SD Doc./Item/Personnel/Sold-to pt/No.ser.no./Customer | 9 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPEmpties Management |
49 | /BEV1/EMLGBSD | Customer Empties Stock per Month | 7 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
50 | /BEV1/EMLGBWDP | Empties Movement Account Customer | 10 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
51 | /BEV1/EMLGKTO | Empties Account | 4 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPIntegration |
52 | FKK_VBRK_SHORT | Header Data for SD Billing Document - Extracts | 16 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPInvoice Forecasting |
53 | IFW_WORKLIST | Invoice forecasting worklist | 10 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPLocalization |
54 | J_1IEXCHDR | Excise invoice header detail | 26 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
55 | J_1ILICHDR | Excise Bonding: License Header | 9 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
56 | J_3RSCCDHEADER | Cargo Customs Declaration Header | 18 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPMedia Product Sales and Distribution |
57 | JKSDCREDITMEMO | IS-M/SD Worklist of Mass Credit Memos | 14 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
58 | JKSDUNSOLD | IS-M: Header Data on Unsold Copies | 17 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPPatient Accounting |
59 | NVBRK | IS-H: Billing document header data | 41 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
60 | A386 | Sales Org./Dist.Chl./Division/Sold-To Pty | 7 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
61 | JFRK | IS-M/SD: Billing - Header Data | 43 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPProfitability Analysis |
62 | CEERROR | CO-PA: Incorrect records from SD | 52 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPPurchasing |
63 | EKPV | Shipping Data For Stock Transfer of Purchasing Document Item | 8 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPRecycling Administration Core Functions |
64 | J_7LVBRK | NON-SD Interface: Billing: Header Data | 16 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPRevenue recognition |
65 | VBREVE | Revenue Recognition: Revenue Recognition Lines | 24 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
66 | VBREVK | Revenue Recognition: Control Lines | 13 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPRoute Settlement |
67 | /DSD/SL_DIFIAC | DSD Settlement: Interim Accounts | 2 | KUNAG | Tolerance Group Customizing: Driver | nvarchar | 10 | 0 | | |
68 | /DSD/SL_IACFIN | Settlement: Interim Accounts, Final Difference | 2 | KUNAG | Tolerance Group Customizing: Driver | nvarchar | 10 | 0 | | |
69 | /DSD/SL_PMSIAC | DSD Settlement: Driver and Customer Accounts (Collection) | 3 | KUNAG | Sold-to Party Receipts/Expenditures | nvarchar | 10 | 0 | | |
TOPSales |
70 | SLS_TMPL_HEAD | Sales: Template Head | 5 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
71 | SLS_TMPL_KEY | Sales: Template Key | 3 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPSelf-Billing Proced. |
72 | T665D | SD Self-Billing Procedure: Contractor Processing Parameters | 2 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
73 | VSBHDR | IDoc Self-Billing Procedure w. Automatic Postings | 20 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
74 | VSBOII | Self-Billing: Index of Generated Open Items | 3 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPShipping |
75 | LIKP | SD Document: Delivery Header Data | 31 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
76 | VLKPA | SD Index: Deliveries by Partner Functions | 9 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
77 | VLPMA | SD Index: Delivery Items by Material | 8 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
78 | S430 | SIS: (OIL-TSW) Sales document statistics by TSW object | 14 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | |