| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 119 | FKDAT | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 99 | FKDAT | | nvarchar | 8 | 0 | | |
3 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 64 | FKDAT | | nvarchar | 8 | 0 | | |
4 | /BIC/B0000184000 | PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data | 14 | FKDAT | | nvarchar | 8 | 0 | | |
5 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 12 | FKDAT | | nvarchar | 8 | 0 | | |
6 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 12 | FKDAT | | nvarchar | 8 | 0 | | |
7 | J_1I_LICHDR | EXIM : License Header | 22 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
8 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 250 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
9 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 250 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPAdvertising Management |
10 | JHAGVX | IS-M/AM: Order Sales Agent Assignment Settlement Index | 12 | FKDAT | IS-M: Planned Billing/Settlement Date | nvarchar | 8 | 0 | | |
11 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 39 | FKDAT | IS-M: Actual Billing/Settlement Date | nvarchar | 8 | 0 | | |
12 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 36 | FKDAT | IS-M: Actual Billing/Settlement Date | nvarchar | 8 | 0 | | |
13 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 17 | FKDAT | IS-M: Actual Billing/Settlement Date | nvarchar | 8 | 0 | | |
14 | JHTFX | IS-M/AM: Billing Index - Order Billing | 5 | FKDAT | IS-M: Planned Billing/Settlement Date | nvarchar | 8 | 0 | | |
15 | JHTVAABP | IS-M/AM: Contract Settlement Item Data | 25 | FKDAT | IS-M: Actual Billing/Settlement Date | nvarchar | 8 | 0 | | |
TOPBasic Functions |
16 | FDS1 | Cash Management & Forecast: Line Items of SD Documents | 14 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
17 | FPLT | Billing Plan: Dates | 6 | FKDAT | Settlement date for deadline | nvarchar | 8 | 0 | | |
18 | FPLTPO | Billing Plan: Dates | 6 | FKDAT | Settlement date for deadline | nvarchar | 8 | 0 | | |
19 | VFPLT | Billing Plan: Dates | 6 | FKDAT | Settlement date for deadline | nvarchar | 8 | 0 | | |
TOPBilling |
20 | TVFKD | Billing Document: Billing Date by Number Range | 3 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
21 | VBRK | Billing Document: Header Data | 12 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
22 | VRKPA | Sales Index: Bills by Partner Functions | 5 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
23 | VRPMA | SD Index: Billing Items per Material | 4 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
24 | FKK_JFRK_SHORT | Header Data for IS-M/SD Billing Document - Extracts | 9 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPCosting |
25 | COER | Sales Order Value Revenue | 38 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
26 | VVBKD | Sales Document: Business Data | 22 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPData Collection |
27 | S008 | Communications Table SD -> CO/Projects | 49 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
28 | S260 | SD - Sales order | 70 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
29 | S260BIW1 | SD - Sales order | 70 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
30 | S260BIW2 | SD - Sales order | 70 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
31 | S262 | SD - Billing document | 26 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
32 | S262BIW1 | SD - Billing document | 26 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
33 | S262BIW2 | SD - Billing document | 26 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
34 | S264 | SD- Offer | 72 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
35 | S264BIW1 | S264BIW1 * SD - Quotation | 72 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
36 | S264BIW2 | S264BIW2 * SD - Quotation | 72 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
37 | TXW_S_VBRK | Retrieve VBRK from archive | 14 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPDelivery Confirmation |
38 | DELCONHD | Delivery Confirmation: Basis of Logistic.Match. - Header | 8 | FKDAT | Billing Document Date | nvarchar | 8 | 0 | | |
TOPEmpties Management |
39 | /BEV1/EMLGBWDP | Empties Movement Account Customer | 17 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
40 | /BEV1/EMLGFAD | Empties Movement - Customer Billing Status | 11 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
41 | /CCEE/SIFIPE7 | Pro forma invoice for temporary export of goods | 8 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPIntegration |
42 | FKK_VBRK_SHORT | Header Data for SD Billing Document - Extracts | 11 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPInvoice Forecasting |
43 | IFW_HEADER | Invoice forecasting header | 7 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPLocalization |
44 | J_3RFGTDINV | GTD usage in billing documents | 13 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPMedia Product Sales and Distribution |
45 | JKSDCREDITMEMO | IS-M/SD Worklist of Mass Credit Memos | 15 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
46 | JKSDUNSOLD | IS-M: Header Data on Unsold Copies | 18 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPPatient Accounting |
47 | NVBRK | IS-H: Billing document header data | 12 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
48 | TN22P | IS-H: Control Parameters FI Posting Down Payment | 14 | FKDAT | IS-H: Rule for Due Date | nvarchar | 1 | 0 | | |
49 | TN22Q | IS-H: Control Parameters FI Posting Copayment Request | 10 | FKDAT | IS-H: Rule for Due Date | nvarchar | 1 | 0 | | |
50 | TN22R | IS-H: Control Params FI Posting Copayment/Copay.Cred.Memo | 11 | FKDAT | IS-H: Rule for Due Date | nvarchar | 1 | 0 | | |
51 | TN22S | IS-H: Control Parameters FI Posting Down Payment Request | 12 | FKDAT | IS-H: Rule for Due Date | nvarchar | 1 | 0 | | |
TOPPeriodical Sales and Distribution |
52 | JFDFS | IS-M/SD: Billing/Settlement Index | 7 | FKDAT | IS-M: Billing/Settlement Date | nvarchar | 8 | 0 | | |
53 | JFRK | IS-M/SD: Billing - Header Data | 10 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
54 | JLRP | IS-M/SD: Item Data for Settlement | 155 | FKDAT | IS-M: Billing/Settlement Date | nvarchar | 8 | 0 | | |
55 | TJF31 | IS-M/SD: Collective Transfer Run to RF/FI | 6 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPProfitability Analysis |
56 | CEERROR | CO-PA: Incorrect records from SD | 58 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPRecycling Administration Core Functions |
57 | J_7LVBRK | NON-SD Interface: Billing: Header Data | 9 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
58 | /BEV1/BO_DATA | Proof Table for Rebate Processing | 12 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
59 | /BEV1/RBWE | Itemized Proof Rebate Settlement | 36 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
60 | /BEV3/CHFKFKDRK | Document Print History | 4 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPRevenues and Earnings |
61 | AD01DLIEF | DI flow: Individual flow | 21 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPSales |
62 | VBKD | Sales Document: Business Data | 22 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
63 | VKDFS | SD Index: Billing Initiator | 4 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
64 | TN22F | IS-H: Steuerungsparameter FI-Buchung amb. Zuzahl.anforderung | 8 | FKDAT | IS-H: Regel für Fälligkeitsdatum | nvarchar | 1 | 0 | | |
65 | TN22G | IS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung | 10 | FKDAT | IS-H: Regel für Fälligkeitsdatum | nvarchar | 1 | 0 | | |
TOPService Station Retailing |
66 | OIRA_PRINTINDEX | Print group index data | 12 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
67 | OIRA_PRNDOC_HEAD | Print document header data | 8 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
68 | OIRPBL | Sales Index: Billing by Business Location | 3 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPShipping |
69 | LIKP | SD Document: Delivery Header Data | 47 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
70 | VBLK | SD Document: Delivery Note Header | 6 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPSimulation |
71 | VSFPLT_CN | Version: Billing schedule: Dates | 7 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
72 | VSVBKD_CN | Version: Sales document - commercial data | 23 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | |
TOPWarranty Claim Processing |
73 | PNWTYV | Warranty Claim Version (PVS Node) | 13 | FKDAT | Billing Document Date | nvarchar | 8 | 0 | | |