| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000468 | T179 | 5 | PRODH | | nvarchar | 18 | 0 | | |
2 | /1CADMC/00000469 | T179T | 6 | PRODH | | nvarchar | 18 | 0 | | |
3 | /BIC/B0000177000 | PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item | 45 | PRODH | | nvarchar | 18 | 0 | | |
4 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 82 | PRODH | | nvarchar | 18 | 0 | | |
5 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 76 | PRODH | | nvarchar | 18 | 0 | | |
6 | /BIC/B0000180000 | PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch. | 55 | PRODH | | nvarchar | 18 | 0 | | |
7 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 51 | PRODH | | nvarchar | 18 | 0 | | |
8 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 72 | PRODH | | nvarchar | 18 | 0 | | |
9 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 75 | PRODH | | nvarchar | 18 | 0 | | |
10 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 55 | PRODH | | nvarchar | 18 | 0 | | |
11 | /SMD/MD_____00BZ | SID-Tabelle fuer Product hierarchy | 3 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
12 | /SMD/MD_____00Y5 | SID-Tabelle fuer Product hierarchy | 3 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
13 | S628BIW1 | S628BIW1 * APO Demand | 12 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
14 | S628BIW2 | S628BIW2 * APO Demand | 12 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
15 | S628E | S628 - Strukturinformationen | 7 | PRODH | Produkthierarchie | nvarchar | 18 | 0 | | |
16 | S999 | Copy of S628 for APO Pump Demo | 12 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
17 | S999E | S999 - Structural information | 7 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
18 | ZEIM_LIPS | SD document: Delivery: Item data | 16 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
19 | ZEIM_VBAP | Sales Document: Item Data | 17 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPAdvertising Management |
20 | JHAMOT | IS-M/AM: Ad Spec | 69 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
21 | JHAMOTO | IS-M/AM: Online Ad Spec | 15 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
22 | JHAMOTW | IS-M/AM: OPM Ad Spec (Commercial) | 14 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
23 | JHAPA | IS-M/AM: Order-Publishing-Media Ad Item | 61 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
24 | JHAPD | IS-M/AM: OPM Service Item | 36 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
25 | JHAPP | Order-Publishing-Media Package Item | 6 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
26 | JHAPS | IS-M/AM: OPM Ad Insert Item | 65 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
27 | JHAPV | IS-M/AM: OPM Distribution Item | 54 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
28 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 54 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
29 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 51 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
30 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 59 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
31 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 56 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
32 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 68 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
33 | JHTVABRUF | IS-M/AM: Contract Access | 10 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
34 | JHTVBPO | IS-M/AM: Contract Requirement Element | 27 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
35 | JJCPRESPONSIB | IS-M: Responsibility in Contact Person Relationship | 9 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
36 | JJT179 | IS-M/AM: Product Hierarchy | 2 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
37 | JJT179T | Materials: Product Hierarchies: Texts | 3 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
38 | JJTAZ | IS-M/AM: Media Contact Person Responsibility | 9 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
39 | JJTKONZU | IS-M/AM: Sales Activity Assignments | 6 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
40 | JJTPH | IS-M/AM: BP Product Hierarchy Assignment | 3 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
41 | TJJKAMP | IS-M/AM: Campaign (Customer) | 8 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
TOPBasic Functions |
42 | T179T | Materials: Product hierarchies: Texts | 3 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPBilling |
43 | VBRP | Billing Document: Item Data | 38 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPConditions |
44 | KOTE999 | Sales org./Distr. Chl/Customer/Prod.hier. | 7 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
45 | VVBAP | Sales Document: Item Data | 17 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPData Collection |
46 | S125 | Forecast history for ex. system | 14 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
47 | S125E | S125 - Structural information | 9 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
48 | S260 | SD - Sales order | 36 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
49 | S260BIW1 | SD - Sales order | 36 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
50 | S260BIW2 | SD - Sales order | 36 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
51 | S261 | SD - Delivery note | 53 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
52 | S261BIW1 | SD - Delivery note | 53 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
53 | S261BIW2 | SD - Delivery note | 53 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
54 | S262 | SD - Billing document | 41 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
55 | S262BIW1 | SD - Billing document | 41 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
56 | S262BIW2 | SD - Billing document | 41 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
57 | S263 | SD - Sales order/delivery note | 32 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
58 | S263BIW1 | SD - Sales order/delivery note | 32 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
59 | S263BIW2 | SD - Sales order/delivery note | 32 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
60 | S264 | SD- Offer | 38 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
61 | S264BIW1 | S264BIW1 * SD - Quotation | 38 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
62 | S264BIW2 | S264BIW2 * SD - Quotation | 38 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
63 | S628 | APO Demand | 12 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPData Retention Tool |
64 | TXW_S_VBAP | Retrieve VBAP from archive | 10 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
65 | TXW_S_VBRP | Retrieve VBRP from archive | 43 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPIntegration |
66 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 39 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPLogistics - General |
67 | WBHI | Trading Contract: Item Data | 38 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPMarketing, Accounting and Pricing |
68 | A420 | SalesOrg/DistCh/CustGrp/ProdHier/PricDRC | 8 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
69 | A421 | SalesOrg/DistCh/CustGrp/Plant/ProdHier/PricDRC | 9 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
70 | A428 | SalesOrg/DistChann/CustGrp/DRCMetrInd/ProdHier | 8 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPMaterial Maintenance |
71 | T179 | Materials: Product Hierarchies | 2 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPMaterial Master |
72 | MVKE | Sales Data for Material | 20 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
73 | MVKE_TMP | File for Incorrect Data in Direct Input | 23 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
74 | MVVE | Sales Data for Material | 20 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPRecycling Administration Core Functions |
75 | J_7LC06 | REA Data Filter: Product Hierarchies | 3 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
76 | J_7LVBRPOS | NON-SD Interface: Billing: Item Data | 12 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
77 | /BEV1/RBVBAP | Sales Document: Item Data | 17 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPResourcen Management |
78 | RMXTT_PRODH | Trial: Assignment of Product <-> Product Hierarchy | 2 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPSales |
79 | VBAP | Sales Document: Item Data | 17 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
80 | VBSP | SD Document Item for Models of Material Structures | 10 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPShipping |
81 | LIPS | SD document: Delivery: Item data | 16 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |
TOPSimulation |
82 | VSVBAP_CN | Version: Sales document: Item data | 18 | PRODH | Product hierarchy | nvarchar | 18 | 0 | | |