| 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 | 126 | PRSDT | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 106 | PRSDT | | nvarchar | 8 | 0 | | |
3 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 71 | PRSDT | | nvarchar | 8 | 0 | | |
4 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 77 | PRSDT | | nvarchar | 8 | 0 | | |
5 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 57 | PRSDT | | nvarchar | 8 | 0 | | |
TOPAdvertising Management |
6 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 157 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
7 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 63 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
8 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 60 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
9 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 47 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPAgency Business Global Trade |
10 | WBRP | Agency business: Item | 9 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPBilling |
11 | VBRP | Billing Document: Item Data | 19 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
12 | FKK_JFRP_SHORT | Item Data for IS-M/SD Billing Document - Extracts | 13 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
13 | FKK_JLRPCM_SHORT | Item Data for IS-M/SD Commission Settlement - Extracts | 10 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPCosting |
14 | COER | Sales Order Value Revenue | 88 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
15 | VVBKD | Sales Document: Business Data | 21 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPData Collection |
16 | S008 | Communications Table SD -> CO/Projects | 46 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
17 | S260 | SD - Sales order | 69 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
18 | S260BIW1 | SD - Sales order | 69 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
19 | S260BIW2 | SD - Sales order | 69 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
20 | S262 | SD - Billing document | 37 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
21 | S262BIW1 | SD - Billing document | 37 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
22 | S262BIW2 | SD - Billing document | 37 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
23 | S264 | SD- Offer | 71 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
24 | S264BIW1 | S264BIW1 * SD - Quotation | 71 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
25 | S264BIW2 | S264BIW2 * SD - Quotation | 71 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
26 | TXW_S_VBRP | Retrieve VBRP from archive | 31 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPFreight Processing |
27 | VFKK | Shipment Costs: Header Data | 6 | PRSDT | Pricing date | nvarchar | 8 | 0 | | |
28 | VFKP | Shipment Costs: Item Data | 10 | PRSDT | Pricing date | nvarchar | 8 | 0 | | |
TOPIntegration |
29 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 27 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPMedia Product Sales and Distribution |
30 | JKSDORDERINDEX | Index Table for IS-M Orders | 23 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
31 | JKSDRETURNCHECK | IS-M: Quantity Check on Return | 21 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
32 | JKSDUNSOLDITEM | IS-M: Item Data on Unsold Copies/Credit Memos | 75 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPPatient Accounting |
33 | NVBRP | IS-H: Billing document item data | 8 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
34 | JFDFS | IS-M/SD: Billing/Settlement Index | 52 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
35 | JFRP | IS-M/SD: Billing Document - Item Data | 8 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
36 | JKEP | Sales Order: Schedule Line Data | 33 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
37 | JLRP | IS-M/SD: Item Data for Settlement | 9 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPPricing |
38 | PRCD_HEAD | Price Condition Set (Header) | 12 | PRSDT | Condition Pricing Date | nvarchar | 8 | 0 | | |
TOPProduction and Revenue Accounting |
39 | OIUCM_CONTRACT | PRA Contracts | 35 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
40 | VIAKBSEG | Document Line Item from SCS for Interface | 150 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPRevenues and Earnings |
41 | VPKHEAD | Sales Pricing Header Data | 29 | PRSDT | Pricing date | nvarchar | 8 | 0 | | |
TOPSales |
42 | VBKD | Sales Document: Business Data | 21 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPSimulation |
43 | VSVBKD_CN | Version: Sales document - commercial data | 22 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | | |
TOPWarranty Claim Processing |
44 | PNWTYV | Warranty Claim Version (PVS Node) | 16 | PRSDT | Date for Pricing and Exchange Rate | nvarchar | 8 | 0 | | |