SAP ABAP Table JHTVAARI (IS-M/AM: Contract Settlement Payer/Advertiser Record)
Hierarchy
☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category TRANSP    Transparent table 
Transparent table JHTVAARI   Table Relationship Diagram
Short Description IS-M/AM: Contract Settlement Payer/Advertiser Record    
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 JHTVAABK
3 ABRGNR ABRGNR ABRGNR NUMC 4   0   IS-M/AM: Contract Settlement Number JHTVAABK
4 .INCLUDE       0   0   IS-M/AM: Key Fields for P/A Record  
5 REGULIERER REGULIERER GPNR CHAR 10   0   IS-M: Payer JJVDB_MK
6 INSERENT INSERENT GPNR CHAR 10   0   IS-M: Advertiser JJVDB_MK_FK
7 TRENNUNG JH_TRENNUNG CHAR10 CHAR 10   0   IS-M/AM: Split Criteria for Payer/Advertiser Records  
8 .INCLUDE       0   0   IS-M: Sales area data for COA settlement table  
9 .INCLUDE       0   0   IS-M: Sales Area  
10 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
11 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
12 SPART SPART SPART CHAR 2   0   Division TSPA
13 ABS_TYP ABS_TYP ABS_TYP CHAR 1   0   IS-M/AM: Contract Category TJH11
14 ABINHNR ABINHNR GPNR CHAR 10   0   IS-M/AM: Number of Contract Holder JGTGPNR
15 AB_BRUTTO AB_BRUTTO WERTV8 CURR 15   2   IS-M: Contract Gross  
16 AB_WEINH AB_WEINH WAERS CUKY 5   0   IS-M: Currency Key for Contract TCURC
17 ABRMM ABRMM SAEMM QUAN 12   3   IS-M: Quantity (mm, Pages, Seconds)  
18 ABRME ABRME SAEME DEC 5   0   IS-M: Number  
19 EINH1 AB_MEINH MEINS UNIT 3   0   IS-M: Contract Units of Measurement *
20 EINH2 AB_MEINH MEINS UNIT 3   0   IS-M: Contract Units of Measurement *
21 PR_BASIS PR_BASIS PR_BASIS CHAR 1   0   IS-M: Basis for scale access (number/quantity)  
22 ABRECHK ABRECHK ABRECHK CHAR 1   0   IS-M: Settlement Type TJH15
23 ABR_STATUS ABR_STATUS ABR_STATUS CHAR 1   0   IS-M: Contract Settlement Status  
24 STORNOGRD STOGRD_PAM STOGRD_PAM CHAR 3   0   IS-M: Cancellation Reason TJHSTOG
25 FAKSP FAKSP FAKSP CHAR 2   0   Lock TVFS
26 DATEAAFS DATEAAFS DATUM DATS 8   0   IS-M/AM: Billing Block Date for Contract Settlement  
27 RAB_IST RAB_IST WERTV7 CURR 13   2   IS-M: Contract Discount Granted to Date  
28 RAB_SOLL RAB_SOLL WERTV7 CURR 13   2   IS-M: Current Contract Discount  
29 BON_IST BON_IST WERTV7 CURR 13   2   IS-M: Contract Bonus Granted to Date  
30 BON_SOLL BON_SOLL WERTV7 CURR 13   2   IS-M/AM: Current Contract Bonus  
31 ABETR_IST ABETR_IST WERTV8 CURR 15   2   IS-M: Contract Settlement Amount Paid to Date  
32 ABETR_SOLL ABETR_SOLL WERTV8 CURR 15   2   IS-M: Current Contract Settlement Amount  
33 GL_BETRAG GL_BETRAG WERTV8 CURR 15   2   IS-M: Credit/Debit Memo Amount for Contract Settlement  
34 SFKRBMO SRBMO WERTV8 CURR 15   2   Total sales vol.all acc.assignments qualifying for discount  
35 SFKRBMM SRBMM SAEMM QUAN 12   3   IS-M: Total qty all acc.assignments qualifying for discount  
36 SFKRBME SRBME SAEME DEC 5   0   IS-M: Total No.All Acc.Assignments Qualifying for Discount  
37 SFKBOMO SBOMO WERTV8 CURR 15   2   IS-M: Total sales vol.all accept.assignments qual.for bonus  
38 SFKBOMM SBOMM SAEMM QUAN 12   3   IS-M: Total quantity of all accpt.assignments qual.for bonus  
39 SFKBOME SBOME SAEME DEC 5   0   IS-M: Total Number All Acc.Assignments Qualifying for Bonus  
40 JHABRDAT JHABRDAT DATUM DATS 8   0   IS-M: Contract Settlement Date  
41 AAB_BEARB AAB_BEARB XUBNAME CHAR 12   0   IS-M: Contract Settlement Processed By USR02
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JHTVAARI AAB_BEARB USR02 BNAME 1 CN
2 JHTVAARI ABINHNR JGTGPNR GPNR REF 1 CN
3 JHTVAARI ABRECHK TJH15 ABRECHK REF 1 CN
4 JHTVAARI ABRGNR JHTVAABK ABRGNR KEY 1 CN
5 JHTVAARI ABS_TYP TJH11 ABS_TYP KEY 1 CN
6 JHTVAARI AB_WEINH TCURC WAERS REF 1 CN
7 JHTVAARI FAKSP TVFS FAKSP 1 CN
8 JHTVAARI INSERENT JJVDB_MK_FK GPNR KEY 1 CN
9 JHTVAARI MANDT T000 MANDT KEY 1 CN
10 JHTVAARI REGULIERER JJVDB_MK GPNR KEY 1 CN
11 JHTVAARI SPART TSPA SPART 1 CN
12 JHTVAARI STORNOGRD TJHSTOG STORNOGRD 1 CN
13 JHTVAARI VKORG TVKO VKORG 1 CN
14 JHTVAARI VTNR JHTVAABK VTNR KEY 1 CN
15 JHTVAARI VTWEG TVTW VTWEG 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in