SAP ABAP Table JHTVAABK (IS-M/AM: Contract Settlement Header Data)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | JHTVAABK | Table Relationship Diagram |
Short Description | IS-M/AM: Contract Settlement Header Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | VTNR | ABS_VTNR | ABS_VTNR | NUMC | 6 | 0 | IS-M: Contract Number | JHTVKO | |
3 | ABRGNR | ABRGNR | ABRGNR | NUMC | 4 | 0 | IS-M/AM: Contract Settlement Number | ||
4 | .INCLUDE | 0 | 0 | IS-M: Organizational Data for a Contract | |||||
5 | .INCLUDE | 0 | 0 | IS-M: Sales Area | |||||
6 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
7 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVKOV | |
8 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TVTA | |
9 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVKBZ | |
10 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVBVK | |
11 | ABRECHK | ABRECHK | ABRECHK | CHAR | 1 | 0 | IS-M: Settlement Type | TJH15 | |
12 | JHABRDAT | JHABRDAT | DATUM | DATS | 8 | 0 | IS-M: Contract Settlement Date | ||
13 | R_DATUM | R_DATUM | DATUM | DATS | 8 | 0 | IS-M: Date of Last Interim/Final Settlement | ||
14 | ABS_TYP1 | ABS_TYP | ABS_TYP | CHAR | 1 | 0 | IS-M/AM: Contract Category | TJH11 | |
15 | XBEST_PR | XBEST_PR | XFELD | CHAR | 1 | 0 | IS-M: Apply Best Conditions to Number / Quantity | ||
16 | MENGE1 | ABS_MENGE1 | ABS_MENGE | QUAN | 12 | 3 | IS-M/AM: Agreed Quantity to be Sold | ||
17 | EINH1 | AB_MEINH | MEINS | UNIT | 3 | 0 | IS-M: Contract Units of Measurement | * | |
18 | AB_ZIEL1 | AB_ZIEL1 | WERTV8 | CURR | 15 | 2 | IS-M/AM: Target Quantity for Monetary Contract | ||
19 | AB_WEINH | AB_WEINH | WAERS | CUKY | 5 | 0 | IS-M: Currency Key for Contract | TCURC | |
20 | MENGE2 | ABS_MENGE2 | ABS_MENGE | QUAN | 12 | 3 | IS-M/AM: Agreed Quantity to be Sold | ||
21 | EINH2 | AB_MEINH | MEINS | UNIT | 3 | 0 | IS-M: Contract Units of Measurement | * | |
22 | PR_BASIS | PR_BASIS | PR_BASIS | CHAR | 1 | 0 | IS-M: Basis for scale access (number/quantity) | ||
23 | AB_PREIS | AB_PREIS | WERTV8 | CURR | 15 | 2 | IS-M: Current Valid Price from Contract | ||
24 | AB_KPREIS | AB_KPREIS | WERTV8 | CURR | 15 | 2 | IS-M: Price from Scale | ||
25 | AB_VPREIS | AB_VPREIS | WERTV8 | CURR | 15 | 2 | IS-M: Agreed Price from Contract | ||
26 | RKNUMV | AB_RKNUMV | RABATT | DEC | 5 | 2 | IS-M: Discount from Scale | ||
27 | RABATT | AB_RABATT | RABATT | DEC | 5 | 2 | IS-M: Current Valid Contract Discount Rate | ||
28 | VRABATT | VRABATT | RABATT | DEC | 5 | 2 | IS-M: Agreed Discount | ||
29 | BKNUMV | AB_BKNUMV | RABATT | DEC | 5 | 2 | IS-M/AM: Bonus from Scale | ||
30 | AKTBONUS | AKTBONUS | RABATT | DEC | 5 | 2 | IS-M/AM: Current Valid Contract Bonus | ||
31 | VBONUS | VBONUS | RABATT | DEC | 5 | 2 | IS-M: Agreed Bonus | ||
32 | FREITEXT | ABS_TEXT | FREITEXT | CHAR | 50 | 0 | IS-M: Freely Definable Text | ||
33 | MNGABRM | MNGABRM | ABS_MENGE | QUAN | 12 | 3 | IS-M: Quantity for settlement | ||
34 | MEINHABRM | AB_MEINH | MEINS | UNIT | 3 | 0 | IS-M: Contract Units of Measurement | * | |
35 | UMSABRM | UMSABRM | WERTV8 | CURR | 15 | 2 | IS-M: Sales Volume for Contract Settlement | ||
36 | WEINHABRM | AB_WEINH | WAERS | CUKY | 5 | 0 | IS-M: Currency Key for Contract | TCURC | |
37 | FAKSP | FAKSP | FAKSP | CHAR | 2 | 0 | Lock | TVFS | |
38 | DATEAAFS | DATEAAFS | DATUM | DATS | 8 | 0 | IS-M/AM: Billing Block Date for Contract Settlement | ||
39 | .INCLUDE | 0 | 0 | IS-PAM: Structure Of Totals Fields In COA | |||||
40 | SAERBMO | SRBMO | WERTV8 | CURR | 15 | 2 | Total sales vol.all acc.assignments qualifying for discount | ||
41 | SAERBMM | SRBMM | SAEMM | QUAN | 12 | 3 | IS-M: Total qty all acc.assignments qualifying for discount | ||
42 | SAERBME | SRBME | SAEME | DEC | 5 | 0 | IS-M: Total No.All Acc.Assignments Qualifying for Discount | ||
43 | SAEBOMO | SBOMO | WERTV8 | CURR | 15 | 2 | IS-M: Total sales vol.all accept.assignments qual.for bonus | ||
44 | SAEBOMM | SBOMM | SAEMM | QUAN | 12 | 3 | IS-M: Total quantity of all accpt.assignments qual.for bonus | ||
45 | SAEBOME | SBOME | SAEME | DEC | 5 | 0 | IS-M: Total Number All Acc.Assignments Qualifying for Bonus | ||
46 | SAEMRNRMO | SMRNRMO | WERTV8 | CURR | 15 | 2 | Total sales vol.all orig.acc.assignments count.towards disc. | ||
47 | SAEMRNRMM | SMRNRMM | SAEMM | QUAN | 12 | 3 | Total qty all acc.original assignments count.towards disc. | ||
48 | SAEMRNRME | SMRNRME | SAEME | DEC | 5 | 0 | Total No.of All Acc.Original Assignments Count.Towards Disc. | ||
49 | SAEMBNBMO | SMBNBMO | WERTV8 | CURR | 15 | 2 | Total sales vol.of all acc.orig.assignments count.twrd bonus | ||
50 | SAEMBNBMM | SMBNBMM | SAEMM | QUAN | 12 | 3 | Total qty of all original acc.assignments counting twrd bon. | ||
51 | SAEMBNBME | SMBNBME | SAEME | DEC | 5 | 0 | Total No.of All Acc.Original Assignments Count.Twrds Bonus | ||
52 | SAERFRRMO | SRFRRMO | WERTV8 | CURR | 15 | 2 | Total sales vol.all acc.assignments qual.for dis.frm othr BU | ||
53 | SAERFRRMM | SRFRRMM | SAEMM | QUAN | 12 | 3 | Total qty all acc.assignments qual.for disc.from other BU | ||
54 | SAERFRRME | SRFRRME | SAEME | DEC | 5 | 0 | Total No.All Acc.Assignments Qual.for Discount From Other BU | ||
55 | SAEBFRMO | SBFRMO | WERTV8 | CURR | 15 | 2 | Total sales vol. all acc.assign. qual.for bonus from othr BU | ||
56 | SAEBFRMM | SBFRMM | SAEMM | QUAN | 12 | 3 | Total qty of all accp.assignments qual.for bonus frm othr BU | ||
57 | SAEBFRME | SBFRME | SAEME | DEC | 5 | 0 | Total Number of Assignments Qualify.for Bonus From Other BU | ||
58 | SAEFRMO | SFRMO | WERTV8 | CURR | 15 | 2 | Total sales vol.of all accepted assignments from other BU | ||
59 | SAEFRMM | SFRMM | SAEMM | QUAN | 12 | 3 | IS-M: Total quantity of all accept.assignments from other BU | ||
60 | SAEFRME | SFRME | SAEME | DEC | 5 | 0 | IS-M: Total Number of All Accepted Assignments From Other BU | ||
61 | SAEMFRBMO | SMFRBMO | WERTV8 | CURR | 15 | 2 | Total sales vol.all acc.assign.count.twrds bonus frm othr BU | ||
62 | SAEMFRBMM | SMFRBMM | SAEMM | QUAN | 12 | 3 | Total qty all acc.assignmnts count.twrds bonus from other BU | ||
63 | SAEMFRBME | SMFRBME | SAEME | DEC | 5 | 0 | Total No.All Acc.Assignmnts Count.Twrds Bonus From Other BU | ||
64 | SAEVBMO | SVBMO | WERTV8 | CURR | 15 | 2 | IS-M: Total sales vol.all acc.assignments from other SA | ||
65 | SAEVBMM | SVBMM | SAEMM | QUAN | 12 | 3 | IS-M: Total qty all acc.assignments from other sales area | ||
66 | SAEVBME | SVBME | SAEME | DEC | 5 | 0 | IS-M: Total Number of All Accepted Assignments From Other SA | ||
67 | SAEMAMO | SMAMO | WERTV8 | CURR | 15 | 2 | IS-M: Total sales volume of all accepted manual assignments | ||
68 | SAEMAMM | SMAMM | SAEMM | QUAN | 12 | 3 | IS-M: Total quantity of all manual assignments accepted | ||
69 | SAEMAME | SMAME | SAEME | DEC | 5 | 0 | IS-M: Total Number of All Manual Assignments Accepted | ||
70 | SAEMRMO | SMRMO | WERTV8 | CURR | 15 | 2 | Total sales vol.from all acc.assignments count.toward disc. | ||
71 | SAEMRMM | SMRMM | SAEMM | QUAN | 12 | 3 | Total qty of all acc.assignments counting towards discount | ||
72 | SAEMRME | SMRME | SAEME | DEC | 5 | 0 | IS-M: Total No.of All Acc.Assignments Counting Towards Disc. | ||
73 | SAEMBMO | SMBMO | WERTV8 | CURR | 15 | 2 | IS-M: Total sales vol.of all acc.assignments count.twd bon. | ||
74 | SAEMBMM | SMBMM | SAEMM | QUAN | 12 | 3 | IS-M: Total qty of all accept.assignments counting twrd bon. | ||
75 | SAEMBME | SMBME | SAEME | DEC | 5 | 0 | IS-M: Total No.All Accept.Assignments Which Count Twrds Bon. | ||
76 | SFKRBMO | SRBMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all billed assignments qualifying for disc. | ||
77 | SFKRBMM | SRBMM_FK | SAEMM | QUAN | 12 | 3 | Total qty all billed assignments qualifying for discount | ||
78 | SFKRBME | SRBME_FK | SAEME | DEC | 5 | 0 | IS-M: Total No.All Bill.Assignments Qualifying for Discount | ||
79 | SFKBOMO | SBOMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all billed assignments qualifying for bonus | ||
80 | SFKBOMM | SBOMM_FK | SAEMM | QUAN | 12 | 3 | Total qty of all billed assignments qualifying for bonus | ||
81 | SFKBOME | SBOME_FK | SAEME | DEC | 5 | 0 | Total Number of All Billed Assignments Qualifying for Bonus | ||
82 | SFKMRNRMO | SMRNRMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all billed orig.assignments count.twrd disc. | ||
83 | SFKMRNRMM | SMRNRMM_FK | SAEMM | QUAN | 12 | 3 | Total qty all billed original assignments count.twrd disc. | ||
84 | SFKMRNRME | SMRNRME_FK | SAEME | DEC | 5 | 0 | Total No.of All Billed Original Assignments Count.Twrd Disc. | ||
85 | SFKMBNBMO | SMBNBMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all bill.original assignments count.twd bon. | ||
86 | SFKMBNBMM | SMBNBMM_FK | SAEMM | QUAN | 12 | 3 | Total qty of all billed original assignments count.twrd bon. | ||
87 | SFKMBNBME | SMBNBME_FK | SAEME | DEC | 5 | 0 | Total No.of All Billed Original Assignments Count.Twrd Bonus | ||
88 | SFKRFRRMO | SRFRRMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all bill.assignm.qual.for disc from other BU | ||
89 | SFKRFRRMM | SRFRRMM_FK | SAEMM | QUAN | 12 | 3 | Total qty all billed assignments qual.for disc.from other BU | ||
90 | SFKRFRRME | SRFRRME_FK | SAEME | DEC | 5 | 0 | Total No.All Billed Assignments Qual.for Disc.From Other BU | ||
91 | SFKBFRMO | SBFRMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all bill.assign.qual.for bonus from other BU | ||
92 | SFKBFRMM | SBFRMM_FK | SAEMM | QUAN | 12 | 3 | Total qty all billed assignments qual.for bonus frm other BU | ||
93 | SFKBFRME | SBFRME_FK | SAEME | DEC | 5 | 0 | Total No.All Billed Assignments Qual.for Bonus From Other BU | ||
94 | SFKFRMO | SFRMO_FK | WERTV8 | CURR | 15 | 2 | Total sales volume of all billed assignments from other BU | ||
95 | SFKFRMM | SFRMM_FK | SAEMM | QUAN | 12 | 3 | Total quantity of all billed assignments from other BU | ||
96 | SFKFRME | SFRME_FK | SAEME | DEC | 5 | 0 | Total Number of All Billed Assignments From Other BU | ||
97 | SFKMFRBMO | SMFRBMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all bill.assign.count.twrd bon.from othr BU | ||
98 | SFKMFRBMM | SMFRBMM_FK | SAEMM | QUAN | 12 | 3 | Total qty all billed assignments count.twrd bonus frm oth.BU | ||
99 | SFKMFRBME | SMFRBME_FK | SAEME | DEC | 5 | 0 | Total No.of All Bill.Assignments From Othr BU Count.Twrd Bon | ||
100 | SFKVBMO | SVBMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol. from all billed assignments from other SAs | ||
101 | SFKVBMM | SVBMM_FK | SAEMM | QUAN | 12 | 3 | Total quantity all billed assignments from other SA | ||
102 | SFKVBME | SVBME_FK | SAEME | DEC | 5 | 0 | Total Number of All Billed Assignments From Other SA | ||
103 | SFKMAMO | SMAMO_FK | WERTV8 | CURR | 15 | 2 | Total sales volume of all billed manual assignments | ||
104 | SFKMAMM | SMAMM_FK | SAEMM | QUAN | 12 | 3 | IS-M: Total quantity of all billed manual assignments | ||
105 | SFKMAME | SMAME_FK | SAEME | DEC | 5 | 0 | IS-M: Total Number of All Billed Manual Assignments | ||
106 | SFKMRMO | SMRMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all billed assignments count.toward discount | ||
107 | SFKMRMM | SMRMM_FK | SAEMM | QUAN | 12 | 3 | Total quantity of all billed assignments counting twrd disc. | ||
108 | SFKMRME | SMRME_FK | SAEME | DEC | 5 | 0 | Total Number of All Billed Assignments Counting Toward Disc. | ||
109 | SFKMBMO | SMBMO_FK | WERTV8 | CURR | 15 | 2 | Total sales vol.all billed assignments counting twrd bonus | ||
110 | SFKMBMM | SMBMM_FK | SAEMM | QUAN | 12 | 3 | Total quantity of all billed assignments counting twrd bon. | ||
111 | SFKMBME | SMBME_FK | SAEME | DEC | 5 | 0 | Total Number of All Billed Assignments That Count Twrd Bonus | ||
112 | .INCLUDE | 0 | 0 | Created-By Data (Medium Scope) | |||||
113 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
114 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
115 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
116 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
117 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
118 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JHTVAABK | ABRECHK | TJH15 | ABRECHK | 1 | CN | |
2 | JHTVAABK | ABS_TYP1 | TJH11 | ABS_TYP | KEY | 1 | CN |
3 | JHTVAABK | AB_WEINH | TCURC | WAERS | 1 | CN | |
4 | JHTVAABK | FAKSP | TVFS | FAKSP | KEY | 1 | CN |
5 | JHTVAABK | MANDT | T000 | MANDT | KEY | 1 | CN |
6 | JHTVAABK | SPART | TVTA | SPART | REF | 1 | CN |
7 | JHTVAABK | VKBUR | TVKBZ | VKBUR | REF | 1 | CN |
8 | JHTVAABK | VKGRP | TVBVK | VKGRP | REF | 1 | CN |
9 | JHTVAABK | VKORG | TVKO | VKORG | REF | 1 | CN |
10 | JHTVAABK | VTNR | JHTVKO | VTNR | KEY | 1 | CN |
11 | JHTVAABK | VTWEG | TVKOV | VTWEG | REF | 1 | CN |
12 | JHTVAABK | WEINHABRM | TCURC | WAERS | 1 | CN |
History
Last changed by/on | SAP | 20050520 |
SAP Release Created in |