| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | TJH05 | IS-M/AM: Billing: Document Types | 20 | KALVG | Doc.Proced.for Det.Pricing Proc.for Sales Agent Settlement | nvarchar | 1 | 0 | | |
2 | TJH17 | IS-M/AM: OPM Item Type | 7 | KALVG | Doc.Procedure Proposal (to Determine Pricing Procedure) | nvarchar | 1 | 0 | | |
3 | TJHAK | IS-M/AM: Order-Publishing-Media: Sales Document Type | 12 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
4 | TJHK1 | IS-M/AM: Pricing Procedure: Determine for Pricing | 5 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
5 | TJHK3 | Determine Pricing Procedure for Media Sales Agt Settlement | 4 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
6 | TJHPSF | IS-M/AM: Order Item Procedure Determination | 5 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
TOPAgency Business Global Trade |
7 | TMFK | Agency Business: Billing Document Types | 21 | KALVG | Document schema for determining calculation schema | nvarchar | 2 | 0 | | |
8 | TMKSF | Calculation schema, vendor billing document | 3 | KALVG | Document schema for determining calculation schema | nvarchar | 2 | 0 | | |
9 | TMKV | Agency Business: Calculation Schema Transaction | 2 | KALVG | Document schema for determining calculation schema | nvarchar | 2 | 0 | | |
10 | TMKVT | Agency Business: Calculation Schema Transaction Texts | 3 | KALVG | Document schema for determining calculation schema | nvarchar | 2 | 0 | | |
TOPAssortment Maintenance |
11 | TWPA | General Parameters for Retail Control | 28 | KALVG | Document schema for determining calculation schema | nvarchar | 1 | 0 | | |
TOPBasic Functions |
12 | TVAK | Sales Document Types | 31 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
13 | TVFK | Billing: Document Types | 25 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
14 | TVKVT | Pricing Procedures: Procedure: Texts | 3 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
TOPConditions |
15 | T683V_CMP | Campaign Determination Procedure: Sales Doc. Determination | 5 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
TOPCPE in SD |
16 | CPEC_SD_FA_PROC | CPE in SD: Determination of Procedure for Formula Assembly | 5 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
TOPMaterial Maintenance |
17 | T683V | Pricing Procedures: Determination in Sales Docs. | 5 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
18 | TVKV | Pricing Procedures: Transaction | 2 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
19 | TN21 | IS-H: Billing Types | 5 | KALVG | IS-H: Doc.Pricing Proc. (Det. Pricing Procedure Pat.Billing) | nvarchar | 1 | 0 | | |
TOPPeriodical Sales and Distribution |
20 | TJAK | IS-M/SD: Sales Document Type | 18 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
21 | TJFK | IS-M/SD: Billing Document Types | 24 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
22 | TJK05 | Pricing Procedures: Determination in Sales Documents | 5 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
TOPProduct Catalog |
23 | WWMI | Product catalog | 10 | KALVG | Document schema for determining a calculation schema | nvarchar | 1 | 0 | | |
TOPRetail Pricing |
24 | TWRPGP | General Parameters for Pricing | 13 | KALVG | Document schema for determining calculation schema | nvarchar | 1 | 0 | | |
TOPService Station Retailing |
25 | OIRCPRUPD | SSR Pricing - Update type definition | 2 | KALVG | SSR Pricing - Margins procedure assigned to business type | nvarchar | 1 | 0 | | |
26 | OIRCT683V | SSR Pricing - Margin procedure determination | 2 | KALVG | SSR Pricing - Margins procedure assigned to business type | nvarchar | 1 | 0 | | |
27 | OIRCT685 | SSR Pricing - Condition type definition | 2 | KALVG | SSR Pricing - Margins procedure assigned to business type | nvarchar | 1 | 0 | | |
28 | OIRCT685_H | SSR Pricing - Condition type definition | 2 | KALVG | SSR Pricing - Margins procedure assigned to business type | nvarchar | 1 | 0 | | |
29 | OIRCTVKV | SSR Pricing - Business type Margin Procedure | 2 | KALVG | SSR Pricing - Margins procedure assigned to business type | nvarchar | 1 | 0 | | |
30 | OIRCTVKVT | SSR Pricing - Business type Margin Procedure: Texts | 3 | KALVG | SSR Pricing - Margins procedure assigned to business type | nvarchar | 1 | 0 | | |
31 | OIRECCTYP | SSR PC: Company code / credit card types | 29 | KALVG | Document procedure (for determining pricing procedure) | nvarchar | 1 | 0 | | |
TOPTraders and Schedulers Workbench |
32 | OIRARNBT | Retail Network Business Types | 3 | KALVG | SSR Pricing - Margins procedure assigned to business type | nvarchar | 1 | 0 | | |