| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPF15/RM | F15 Rückmeldung Klärungsbestand | 7 | HERKUNFT | | nvarchar | 2 | 0 | | |
2 | /SAPF15/SM | F15 SEPA Mandat | 30 | HERKUNFT | Herkunft SEPA Mandatsbeleg | nvarchar | 1 | 0 | | |
3 | TQ32 | Assignment of inspection type to origin | 2 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
4 | TQ33 | Relevant fields for origin | 2 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
5 | TQ55 | Assign inspection lot origin for update group | 2 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
TOPAdvertising Management |
6 | JJTPRDH_AVORZ | IS-M/AM: Product Hierarchy (S&P): Assignments Worklist | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
7 | JJTPRDH_DACHPR | IS-M/AM Product Hierarchy (S&P): Umbrella Products | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
8 | JJTPRDH_PRFAG | IS-M/AM Prd.Hier.(S&P): Product/External Agency Assignment | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
9 | JJTPRDH_PRFAM | IS-M/AM Product Hierarchy (S&P): Product Families | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
10 | JJTPRDH_PRFGP | IS-M/AM: Prdh(S&P) Product/External Business Partner Assgmt | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
11 | JJTPRDH_PRGR | IS-M/AM Product Hierarchy (S&P): Product Groups | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
12 | JJTPRDH_PROD | IS-M/AM: Products (S&P Product Hierarchy) | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
13 | JJTPRDH_VKTAB | IS-M/AM Product Hierarchy (S&P): Link Table | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
14 | JJTPRDH_WB | IS-M/AM (S&P Product Hierarchy): Economic Sectors | 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | | |
TOPBasic Data for Certificates |
15 | QCVK | Certificate profile header | 19 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
16 | QCVV | Certificate Profile: List of Preliminary Products | 10 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
17 | PDS_OPER | PDS Data for Operations and Dependent Data | 14 | HERKUNFT | Routing Source | nvarchar | 1 | 0 | | |
TOPData Collection |
18 | S072 | Individual Records for Inspection Lot | 21 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
TOPEmpties Management |
19 | /BEV1/EMLGKTO | Empties Account | 9 | HERKUNFT | ID for Delivery Note/Invoice | nvarchar | 1 | 0 | | |
TOPInput Tax Treatment |
20 | VIBEITEM | Gebuchte Berichtigungen | 29 | HERKUNFT | Herkunft der Buchung | nvarchar | 1 | 0 | | |
TOPInspection Lot Completion |
21 | TQ07M | QM: Inventory postings with usage decision | 3 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
TOPProcess Data Documentation |
22 | MCHPVS | Batch Record: Shadow Table for Link to Archive | 12 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
TOPQM Control in Procurement |
23 | TQ32A | Inspection type to status assignment from status profile | 4 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
TOPQuality Inspection |
24 | QALS | Inspection lot record | 5 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
25 | TQ31 | Inspection Lot Origins | 1 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
26 | TQ31T | Descriptions of Inspection Lot Origins | 2 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
27 | TQ32C | Lot creation allowed values for the origin | 1 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
28 | TQ32C_T | Texts for lot creation indicator | 2 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
29 | TQHU2 | QM assignment of packing object for inspection lot origin | 2 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
30 | /BEV1/RBWE | Itemized Proof Rebate Settlement | 53 | HERKUNFT | Origin Rebate Basis/Rebate Planning | nvarchar | 4 | 0 | | |
TOPResults Recording |
31 | QIWL | Transfer table for QM subsystems | 20 | HERKUNFT | Inspection Lot Origin | nvarchar | 2 | 0 | | |
TOPTreasury |
32 | INDEXW | Index Values (Secur. Index) | 6 | HERKUNFT | Source | nvarchar | 10 | 0 | | |
33 | THERK | Price source | 2 | HERKUNFT | Source | nvarchar | 10 | 0 | | |