| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____0124 | SID-Tabelle fuer Price List | 3 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
2 | A006 | Price List Type/Currency/Material | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPAdvertising Management |
3 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 88 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
4 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 44 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
5 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 89 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPAssortment List |
6 | WBBH | Assortment list header | 27 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
7 | WBB_SAVE2 | Temporary Assortment List Objects: Store-Specific | 23 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPBasic Data |
8 | TN121 | IS-H: Assign Person to Position | 6 | PLTYP | IS-H: Type of Responsibility for a Position | nvarchar | 1 | 0 | | |
9 | TN124 | IS-H: Position | 5 | PLTYP | IS-H: Type of Responsibility for a Position | nvarchar | 1 | 0 | | |
10 | TN128 | IS-H: Assignment Position/Org. Unit/Institution | 7 | PLTYP | IS-H: Type of Responsibility for a Position | nvarchar | 1 | 0 | | |
TOPBenefits |
11 | PA0167 | HR Master Record: Infotype 0167 (Health Plans) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
12 | PA0168 | HR Master Record: Infotype 0168 (Insurance Plans) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
13 | PA0169 | HR Master Record: Infotype 0169 (Savings Plan) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
14 | PA0170 | HR Master Record: Infotype 0170 (Flexible Spending Accounts) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
15 | PA0172 | HR Master Record: Infotype 0172 (FSA Claims) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
16 | PA0212 | HR Master Record: Infotpye 0212 (COBRA Health Plan) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
17 | PA0236 | HR Master Record: Infotype 0236 (Credit Plans) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
18 | PA0377 | HR Master Record: Infotype 0377 (Miscellaneous Plans) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
19 | PA0379 | HR Master Record: Infotype 0379 (Stock Purchase Plans) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
20 | PA0671 | HR Master Record - Infotype 0671 (COBRA Flex. Spending Acct) | 25 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
21 | T5UB1 | Benefit plan type | 3 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
22 | T5UB6 | Benefit Standard Health Selection | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
23 | T5UB7 | Benefit standard insurance selection | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
24 | T5UBA | Benefit plan | 6 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
25 | T5UC1 | Benefit plan type texts | 4 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
26 | T74AA | COBRA-qualified dependent/plan type assignment | 4 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
27 | T74FM | Benefit Standard Savings Selection | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
28 | T74FN | Benefit Standard Spending Account Selection | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
29 | T74FO | Benefit standard credit selection | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
30 | T74FP | Benefit Standard Miscellaneous Selection | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
31 | T74FQ | Benefit standard stock purchase selection | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
32 | T74HB | Benefit adjustment authorization | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
TOPBilling |
33 | A144 | Sales Deal Basic Data | 14 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
34 | A149 | Customer-dependent data determination | 11 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
35 | VBRK | Billing Document: Header Data | 19 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPConditions |
36 | A106 | Price List/Material Group | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
37 | A306 | Price list category/currency/material with release status | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPConstruction Equipment Management |
38 | J_3GPRLIST | CEM Price List Data | 3 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
39 | VVBKD | Sales Document: Business Data | 7 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPCustomer Master |
40 | KNVV | Customer Master Sales Data | 16 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPDistributor-Reseller-Management |
41 | KOTW001 | Matl grp 2/Matl grp 3/Price list | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPFree Goods |
42 | KOTN202 | SalesOrg./SalesChan/PriceList/BonusBuy/Material/SalesUnit | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPGeneral Parts |
43 | T74_FBN00 | Flexible Benefits Plan Type Attribute | 3 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
TOPJapan |
44 | T5J98 | HR Conversion IT0144 to IT0169 JP | 6 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
TOPMarketing, Accounting and Pricing |
45 | OICPL | Customer price list | 2 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPMaterial Maintenance |
46 | T189 | Conditions: Price List Categories | 2 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
47 | T189T | Conditions: Price List Categories: Texts | 3 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPNetherlands |
48 | P05FBN_PLTYP_EIG | Characteristics of Plan Type | 3 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
TOPPatient Accounting |
49 | NVBRK | IS-H: Billing document header data | 13 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
50 | JFRK | IS-M/SD: Billing - Header Data | 16 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
51 | JKKD | Sales Order: Business Data | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPPrice Planning Workbench |
52 | WRF_PPW_PPDCALC | PPD Calculation Set | 9 | PLTYP | Price List Category | nvarchar | 2 | 0 | | |
53 | WRF_PPW_PPDOSIT | PPD Organization Set - Item | 6 | PLTYP | Price List Category | nvarchar | 2 | 0 | | |
54 | WRF_PPW_WORKLERR | PPW Worklist Error Table | 8 | PLTYP | Price List Category | nvarchar | 2 | 0 | | |
55 | WRF_PPW_WORKLIST | PPW Worklist | 8 | PLTYP | Price List Category | nvarchar | 2 | 0 | | |
TOPPromotion |
56 | WAKH | Promotion Header Data, IS-R | 75 | PLTYP | Price list type: promotion header | nvarchar | 2 | 0 | | |
57 | WMFL | Markdown Planning - Price Lists | 5 | PLTYP | Markdown Planning: Price List | nvarchar | 2 | 0 | | |
TOPPublic sector Sweden |
58 | T5SK0_CE | KPA events | 7 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
59 | T5SK1_CE | KPA absences | 7 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
60 | T5SK2_CE | KPA income | 5 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
TOPRecycling Administration Core Functions |
61 | J_7LE04 | REA Partner Master Record: Volume/Area Classes | 5 | PLTYP | Price List Item Category | nvarchar | 1 | 0 | | |
62 | J_7LP02 | REA Price List: Items | 7 | PLTYP | Price List Item Category | nvarchar | 1 | 0 | | |
63 | J_7LV1P | REA Document: Item Data | 16 | PLTYP | Price List Item Category | nvarchar | 1 | 0 | | |
TOPRetail Pricing |
64 | A154 | SalesOrg./Dist.Channel/PriceList/Material/SalesUnit/Customer | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
65 | A155 | Sales Org./Dist. Channel/Price List/Material/Sales Unit | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
66 | TWEGO | Sales Price Calculation: Assignment of price point group | 5 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
67 | TWKAO | Sales Price Calculation: Assignment of pricing type | 4 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
68 | WELP | Competitor: Price Entry Document (Item) | 10 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
69 | WKBP | Pricing document: item | 53 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
70 | WPFDO | Family Pricing: Diff. Dist. Chain-Depnd. Price Relationships | 6 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPSales |
71 | VBKD | Sales Document: Business Data | 7 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPSimulation |
72 | VSVBKD_CN | Version: Sales document - commercial data | 8 | PLTYP | Price list type | nvarchar | 2 | 0 | | |
TOPSweden |
73 | T5SPP | HR-SE: Information needed to be reported to Alecta | 15 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |
TOPTraders and Schedulers Workbench |
74 | OIJBRDH | RD header f.batch:Don't use(obsolete) & don't delete(XPRA) | 36 | PLTYP | OIL-TSW: Planning type | nvarchar | 3 | 0 | | |
75 | OIJLOCMAT | OIL-TSW: Location Rundown/Planning material table | 25 | PLTYP | OIL-TSW: Planning type | nvarchar | 3 | 0 | | |
76 | OIJRDH | Rundown header: Don't use (obsolete) & don't delete (XPRA) | 35 | PLTYP | OIL-TSW: Planning type | nvarchar | 3 | 0 | | |
77 | OIJTSMAT | OIL-TSW: TS Rundown/Planning material table | 24 | PLTYP | OIL-TSW: Planning type | nvarchar | 3 | 0 | | |
78 | OIJ_RDHEAD | Stock Projection header | 38 | PLTYP | OIL-TSW: Planning type | nvarchar | 3 | 0 | | |
TOPUSA |
79 | T5UPBSPA16 | Federal Health Plan Mapping (PS) | 3 | PLTYP | Benefit plan type | nvarchar | 4 | 0 | | |