| 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 | | |
