SAP ABAP Table BAPIBUSISM010_ITEM (IS-M/AM: Items for the Billing Document)
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 INTTAB    Structure 
Structure BAPIBUSISM010_ITEM   Table Relationship Diagram
Short Description IS-M/AM: Items for the Billing Document    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 BILLINGDOCNO JJBELNR JJBELNR CHAR 10   0   IS-M/AM: Billing Document JHTFK
2 ITEMNO JJPOSNR JJPOSNR NUMC 6   0   IS-M/AM: Item (number) in settlement document JHTFP
3 DISTR_CHAN VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
4 DIVISION SPART SPART CHAR 2   0   Division TSPA
5 CUST_GROUP KDGRP KDGRP CHAR 2   0   Customer group T151
6 PRICE_GRP KONDA KONDA CHAR 2   0   Price Group (Customer) T188
7 APPLICATIO KAPPL KAPPL CHAR 2   0   Application T681A
8 PRICINGPROCEDURE KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing T683
9 SHORT_TEXT ISM_ARKTX TEXT40 CHAR 40   0   IS-M: Short Text for Document Item (Billing Doc.,Settlement)  
10 DOCUMENT_NO AVM_NR AVM_NR CHAR 10   0   IS-M/AM: Sales Document Number JHAK
11 ITEM_NUMBER POS_NR AVM_PNR NUMC 3   0   IS-M: Order Item Number JHAP
12 BILLING_DATASET_NO GRUPPABRNR GRUPPABR NUMC 3   0   IS-M/AM: Billing Dataset JHAGA
13 SCHEDULE_LINE_NO EIN_NR AVMENR NUMC 6   0   IS-M: Schedule Line JHAE
14 ORDER_TYPE AUART_PAM AUART_PAM CHAR 4   0   IS-M: Sales Document Type TJHAK
15 BOOKING_UNIT BELEGEINH BELEINH CHAR 10   0   IS-M/AM: Booking Unit JJTBE
16 BASIC_BOOKING_UNIT BE_BASIS BELEINH CHAR 10   0   IS-M: Basic Booking Unit JJTBE
17 PUBLICATION JHDRERZ DRERZ CHAR 8   0   IS-M: Publication JDTDRER
18 EDITION PVA PVA CHAR 8   0   Edition JDTPVA
19 PRICE_CONTENT_COMPONENT IKO_PREIS INHALTSKOM CHAR 8   0   IS-M: Content component for pricing call JJTIKO
20 BUSINESS_CONTENT_COMPONENT INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component *
21 SPECIAL_PUBLICATION_CONT_COMP INHK_SOVER INHALTSKOM CHAR 8   0   IS-M: Special Publication Content Component *
22 AD_FIXED_FORMAT AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions *
23 AD_SHAPE AZART_FORM AZART_FORM CHAR 4   0   IS-M: Shape Ad Type TJJ17
24 AD_COLOR_SCHEME AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type TJJ11
25 AD_DESIGN_TYPE AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
26 DATE_SPECIFICATION TERMINSPEZ TERMINSPEZ CHAR 6   0   IS-M/AM: Specify Dates for Date Combinations TJJ71
27 ISSUE_VARIANT_TYPE VAVARTYP VAVARTYP CHAR 2   0   Issue Variant Type TJD05
28 BOX_NO_INDICATOR CHIFFRE_KZ CHIFFRE_KZ CHAR 1   0   IS-M: Box Number Indicator TJH59
29 DISCOUNT AB_RABATT RABATT DEC 5   2   IS-M: Current Valid Contract Discount Rate  
30 ADVERTISER INSERENT GPNR CHAR 10   0   IS-M: Advertiser JJVDB_MK_FK
31 ADVERTISER_EXTERNAL BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
32 KEYWORD STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
33 SERVICE MATNR_DIEN MATNR_DIEN CHAR 18   0   IS-M: Service material number JJTDIEN
34 SERVICE_TYPE DIENTYP DIENTYP CHAR 4   0   IS-M: Service Type TJH71
35 MATERIAL MATNR MATNR CHAR 18   0   Material Number MARA
36 EAN_UPC EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
37 SERV_DATE FBUDA DATUM DATS 8   0   Date When Services Rendered  
38 ACCT_ASSGT KTGRM KTGRM CHAR 2   0   Account assignment group for this material TVKM
39 ACCT_ASSGT_BOOKINGUNIT KTGRB KTGRB CHAR 2   0   IS-M: Booking Unit Account Assignment Group TJJ39
40 PRICING PRSFD PRSFD CHAR 1   0   Carry out pricing  
41 EXCHG_RATE KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
42 PRICE_DATE PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
43 DEBIT_CREDIT_INDICATOR JHSHKZG JHSHKZG CHAR 1   0   IS-M: Debit/Credit indicator  
44 SCALE_QTY SMENG MENG13 QUAN 13   3   Scale quantity in base unit of measure  
45 INV_QTY FKIMG MENG13 QUAN 13   3   Actual billed quantity  
46 BASE_UOM MEINS MEINS UNIT 3   0   Base Unit of Measure T006
47 BASE_UOMISO MEINS_ISO ISOCD_UNIT CHAR 3   0   Base unit of measure in ISO code *
48 GROSS_WT BRGEW MENG13 QUAN 13   3   Gross weight  
49 NET_WEIGHT NTGEW MENG13 QUAN 13   3   Net weight  
50 UNIT_OF_WT GEWEI MEINS UNIT 3   0   Weight Unit T006
51 UNIT_OF_WTISO MEINS_ISO ISOCD_UNIT CHAR 3   0   Base unit of measure in ISO code *
52 PREC_DOCNO JHVGBEL JHVGBEL CHAR 10   0   IS-M: Document Number of Template Document  
53 PREC_ITEMNO JHVGPOS JHVGPOS NUMC 6   0   IS-M: Item Number of the Template Business Item  
54 PREC_BDSNO GRABR_VG GRUPPABR NUMC 3   0   IS-M: Group/Settlement Number of Template Document *
55 PREC_SD_DOC_CAT ISPVBTYP_V ISPVBTYP CHAR 1   0   IS-M: Preceding Sales Document Category  
56 PREC_OBJECTTYPE JHOBJAR_V JHOBJKT CHAR 2   0   IS-M: Preceding object type TJH97
57 PREC_BILLINGCATEGORY JHVGFKTYP JHFKTYP CHAR 1   0   IS-M: Billing Category for Preceding Billing Document TJH19
58 SALES_OFF VKBUR VKBUR CHAR 4   0   Sales office TVBUR
59 SALES_GRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
60 SALES_UNIT VRKME MEINS UNIT 3   0   Sales unit T006
61 SALES_UNITISO MEINS_ISO ISOCD_UNIT CHAR 3   0   Base unit of measure in ISO code *
62 PLANT WERKS_D WERKS CHAR 4   0   Plant *
63 ITEM_TYPE AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
64 PRODUCT_HIERARCHY J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy *
65 ITEM_CATEGORY PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
66 TAXCLASS_MAT1 TAXM1 TAXKM CHAR 1   0   Tax classification material *
67 TAXCLASS_MAT2 TAXM2 TAXKM CHAR 1   0   Tax classification material *
68 TAXCLASS_MAT3 TAXM3 TAXKM CHAR 1   0   Tax classification material *
69 TAXCLASS_MAT4 TAXM4 TAXKM CHAR 1   0   Tax Classification 4 Material *
70 TAXCLASS_MAT5 TAXM5 TAXKM CHAR 1   0   Tax classification 5 for material *
71 TAXCLASS_MAT6 TAXM6 TAXKM CHAR 1   0   Tax classification 6 for material *
72 TAXCLASS_MAT7 TAXM7 TAXKM CHAR 1   0   Tax classification 7 for material *
73 TAXCLASS_MAT8 TAXM8 TAXKM CHAR 1   0   Tax Classification 8 Material *
74 TAXCLASS_MAT9 TAXM9 TAXKM CHAR 1   0   Tax Classification 9 Material *
75 BUS_AREA GSBER GSBER CHAR 4   0   Business Area TGSB
76 ORDERID AUFNR AUFNR CHAR 12   0   Order Number AUFK
77 COSTCENTER KOSTL KOSTL CHAR 10   0   Cost Center CSKS
78 PROFIT_CTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
79 RK_ORDERNO J_RK_AUFNR J_RK_AUFNR CHAR 8   0   Order Number of RK Order for Account Assignment  
80 RK_ITEMNO J_RK_POSNR J_RK_POSNR NUMC 2   0   Item Number of RK Order for Account Assignment  
81 COSTCENTER_R2 KOSTL_R2 KOSTL_R2 CHAR 8   0   Cost center in R/2  
82 STATGRP_BOOKINGUNIT BEGRP_STAT BEGRP_STAT CHAR 4   0   IS-M: BU Grouping for Statistics TJJ67
83 UPDATE_GRP JHSTAFO STAFO CHAR 6   0   IS-M: Update group for statistics update TMCB
84 CASH_DISC SKTOF XFELD CHAR 1   0   Cash discount indicator  
85 REVENUE_TYPE ISMRR_RELTYP ISMRR_RELTYP CHAR 1   0   IS-M/AM: Revenue Recognition Category  
86 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
87 CREATEDBY ERFUSER USNAM CHAR 12   0   Created By  
88 CREATEDON ERFDATE DATUM DATS 8   0   Created On  
89 CREATEDAT ERFTIME UZEIT TIMS 6   0   Time Created  
90 CHANGEDBY AENUSER USNAM CHAR 12   0   Last Changed By  
91 CHANGEDON AENDATE DATUM DATS 8   0   Date of Last Change  
92 CHANGEDAT AENTIME UZEIT TIMS 6   0   Time of Last Change  
93 SOLD_TO_PARTY GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party *
94 SOLD_TO_PARTY_EXTERNAL BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
95 DEST_CNTRY LLAND LAND1 CHAR 3   0   Destination Country T005
96 DEST_CNTRYISO LAND1_ISO INTCA CHAR 2   0   Country key in ISO code  
97 PRICELIST_ORDER PLTYP_AUFT PLTYP CHAR 2   0   Price list type of sales order T189
98 MANUAL_PRICE MPROK MPROK CHAR 1   0   Status manual price change  
99 STATISTICAL_VALUE KOWRR KOWRR CHAR 1   0   Statistical values  
100 REBATE_BASIS ISM_INVOICE_REBATE_BASIS BAPICURR DEC 23   4   IS-M: Bonus Basis in Billing Document BAPICURR)  
101 SUBTOTAL1 ISM_INVOICE_SUBTOTAL1 BAPICURR DEC 23   4   IS-M: Condition Subtotal 1 from Pricing Procedure (BAPICURR)  
102 SUBTOTAL2 ISM_INVOICE_SUBTOTAL2 BAPICURR DEC 23   4   IS-M: Condition Subtotal 2 from Pricing Procedure (BAPICURR)  
103 SUBTOTAL3 ISM_INVOICE_SUBTOTAL3 BAPICURR DEC 23   4   IS-M: Condition Subtotal 3 from Pricing Procedure (BAPICURR)  
104 SUBTOTAL4 ISM_INVOICE_SUBTOTAL4 BAPICURR DEC 23   4   IS-M: Condition Subtotal 4 from Pricing Procedure (BAPICURR)  
105 SUBTOTAL5 ISM_INVOICE_SUBTOTAL5 BAPICURR DEC 23   4   IS-M: Condition Subtotal 5 from Pricing Procedure (BAPICURR)  
106 SUBTOTAL6 ISM_INVOICE_SUBTOTAL6 BAPICURR DEC 23   4   IS-M: KCondition Subtotal 6 from Pricing Procedure (BAPICURR  
107 COST ISM_INVOICE_COST BAPICURR DEC 23   4   IS-M: Cost in Document Currency  
108 CASHDISCOUNT_BASIS ISM_INVOICE_CASHDISCOUNT_BASIS BAPICURR DEC 23   4   IS-M: Cash Discount Amouunt in Document Currency (BAPICURR)  
109 GROSS_VALUE ISM_INVOICE_GROSS_VALUE BAPICURR DEC 23   4   IS-M: Gross Value of Billing Item (BAPICURR)  
110 NET_VALUE ISM_INVOICE_NET_VALUE BAPICURR DEC 23   4   IS-M: Net Value in Billing Document (BAPICURR)  
111 TAX_AMOUNT ISM_INVOICE_TAX_AMOUNT BAPICURR DEC 23   4   IS-M: Tax Amount in Billing Document (BAPICURR)  
112 CREDIT_PRICE ISM_INVOICE_CREDIT_PRICE BAPICURR DEC 23   4   IS-M: Credit Price for Item (BAPICURR)  
113 PRICING_INCOMPLETE ISM_UVPRS XFELD CHAR 1   0   Incomplete with Regard to Pricing  
114 GENERALLY_INCOMPLETE JHUVALL XFELD CHAR 1   0   IS-M: Generally incomplete  
115 REVENUEDIST_PERFORMED JHXERLV JHXERLV CHAR 1   0   IS-M: Revenue Distribution Status  
116 PERIODEND_PERFORMED JHXPEAB XFELD CHAR 1   0   IS-M: Period end accrual performed indicator  
117 TAXJURCODE TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
118 SALES_QTY_NUM UMVKZ UMBSZ DEC 5   0   Numerator (factor) for conversion of sales quantity into SKU  
119 SALES_QTY_DENOM UMVKN UMBSN DEC 5   0   Denominator (divisor) for conversion of sales qty. into SKU  
120 EXCHG_RATE_STATISTICS STCUR_AP KURRF DEC 9   5   Exchange rate for statistics (Exch.rate at time of creation)  
121 PROFIT_SEGM_NO RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
122 CO_AREA KOKRS CACCD CHAR 4   0   Controlling Area TKA01
123 ALLOC_NMBR JHZUONR ZUONR CHAR 18   0   IS-M: Assignment number in FI document  
124 CONDITION_UPDATE KOUPD XFELD CHAR 1   0   Condition update  
125 ITEM_IS_CANCLED JH_XCNCL XFELD CHAR 1   0   IS-M/AM: Reversal Indicator for Billing Item  
126 SALES_AGT_CONTRACT_REQ_NO VM_BEDNR VM_BEDNR NUMC 6   0   IS-M: Number of Media Sales Agent Contract Requirement *
127 COMMISSION_CATEGORY PROVTYP PROVTYP CHAR 1   0   IS-M/AM: Commission Category  
128 SALES_AGT_ASSIGNMENT_NO JH_VZUONR JH_VZUONR NUMC 2   0   IS-M/AM: Sales Agent Assignment Number (Corrections) *
129 CALCULTATION_TYPE JBERART BERART CHAR 1   0   IS-M/AM: Calculation Type for Media Sales Agent Commission  
130 COMMISSION_KEY JPROVSCHL PRSCHL CHAR 5   0   IS-M/AM: Commission Key for Media Sales Agent TJH23
131 SCALE_BASIS JHSCBAS JHSCBAS CHAR 1   0   IS-M/AM: Scale Base Value for Commission Key  
132 SALES_AGT_TYPE JVERMART JVERMART CHAR 2   0   IS-M: Media Sales Agent Type: General/City/Special Agent TJJ09
133 SHARE_OF_COMMISSION VPROZP DEC4_3 DEC 7   3   IS-M: Sales Agent Share of Commission (in %)  
134 COMMISSION_BASIS ISM_COMMISSION_BASIS BAPICURR DEC 23   4   IS-M: Commission/Bonus Basis, Percentage Calculat.(BAPICURR)  
135 REQUIREMENT_TYPE VMBEDART JVMBEDART CHAR 2   0   IS-M/AM: Requirement Type in Media Sales Agent Contract TJJ73
136 DEPCOUNTRY ALAND LAND1 CHAR 3   0   Departure country (country from which the goods are sent) T005
137 DEPCOUNTRYISO LAND1_ISO INTCA CHAR 2   0   Country key in ISO code  
138 CANBEINCREM_INDICATOR XJSTEIG XFELD CHAR 1   0   IS-M: Can be Incremented Indicator  
139 SALESORG_ORDER JHVKORGAUF VKORG CHAR 4   0   IS-M: Sales Organization for Customer Order TVKO
140 REVENUEDIST_PERCENTAGE ISPPROZERL ISPPROZERL DEC 8   5   IS-M: Percentage rate from rev.distributed billing item  
141 ACCT_ASSGT_EDITION JPVAKNTGRP KTGRM CHAR 2   0   Account assignment grouping for edition TVKM
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BAPIBUSISM010_ITEM ACCT_ASSGT TVKM KTGRM REF 1 CN
2 BAPIBUSISM010_ITEM ACCT_ASSGT_BOOKINGUNIT TJJ39 KTGRB REF 1 CN
3 BAPIBUSISM010_ITEM ACCT_ASSGT_EDITION TVKM KTGRM REF 1 CN
4 BAPIBUSISM010_ITEM ADVERTISER JJVDB_MK_FK GPNR REF 1 CN
5 BAPIBUSISM010_ITEM AD_COLOR_SCHEME TJJ11 AZART_FARB REF 1 CN
6 BAPIBUSISM010_ITEM AD_DESIGN_TYPE TJJ19 AZART_GEST REF 1 CN
7 BAPIBUSISM010_ITEM AD_SHAPE TJJ17 AZART_FORM REF 1 CN
8 BAPIBUSISM010_ITEM APPLICATIO T681A KAPPL REF 1 CN
9 BAPIBUSISM010_ITEM BASE_UOM T006 MSEHI REF 1 CN
10 BAPIBUSISM010_ITEM BASIC_BOOKING_UNIT JJTBE BELEINH REF 1 CN
11 BAPIBUSISM010_ITEM BILLINGDOCNO JHTFK VBELN KEY 1 CN
12 BAPIBUSISM010_ITEM BILLING_DATASET_NO JHAGA GRUPPABRNR REF 1 CN
13 BAPIBUSISM010_ITEM BOOKING_UNIT JJTBE BELEINH REF 1 CN
14 BAPIBUSISM010_ITEM BOX_NO_INDICATOR TJH59 CHIFFRE_KZ REF 1 CN
15 BAPIBUSISM010_ITEM BUS_AREA TGSB GSBER REF 1 CN
16 BAPIBUSISM010_ITEM COMMISSION_KEY TJH23 PRSCHL REF C CN
17 BAPIBUSISM010_ITEM COSTCENTER CSKS KOSTL REF 1 CN
18 BAPIBUSISM010_ITEM CO_AREA TKA01 KOKRS REF 1 CN
19 BAPIBUSISM010_ITEM CUST_GROUP T151 KDGRP REF 1 CN
20 BAPIBUSISM010_ITEM DATE_SPECIFICATION TJJ71 TERMINSPEZ REF 1 CN
21 BAPIBUSISM010_ITEM DEPCOUNTRY T005 LAND1    
22 BAPIBUSISM010_ITEM DEST_CNTRY T005 LAND1 REF 1 CN
23 BAPIBUSISM010_ITEM DISTR_CHAN TVTW VTWEG REF 1 CN
24 BAPIBUSISM010_ITEM DIVISION TSPA SPART REF 1 CN
25 BAPIBUSISM010_ITEM DOCUMENT_NO JHAK AVM_NR REF 1 CN
26 BAPIBUSISM010_ITEM EDITION JDTPVA PVA REF 1 CN
27 BAPIBUSISM010_ITEM ISSUE_VARIANT_TYPE TJD05 VAVARTYP REF 1 CN
28 BAPIBUSISM010_ITEM ITEMNO JHTFP POSNR KEY 1 CN
29 BAPIBUSISM010_ITEM ITEM_CATEGORY TJHAP PSTYV REF 1 CN
30 BAPIBUSISM010_ITEM ITEM_NUMBER JHAP POS_NR REF 1 CN
31 BAPIBUSISM010_ITEM ITEM_TYPE TJH17 AVMPOS_ART REF 1 CN
32 BAPIBUSISM010_ITEM MATERIAL MARA MATNR REF 1 CN
33 BAPIBUSISM010_ITEM ORDERID AUFK AUFNR REF 1 CN
34 BAPIBUSISM010_ITEM ORDER_TYPE TJHAK AUART REF 1 CN
35 BAPIBUSISM010_ITEM PREC_BILLINGCATEGORY TJH19 FKTYP REF 1 CN
36 BAPIBUSISM010_ITEM PREC_OBJECTTYPE TJH97 OBJKT REF 1 CN
37 BAPIBUSISM010_ITEM PRICELIST_ORDER T189 PLTYP REF 1 CN
38 BAPIBUSISM010_ITEM PRICE_CONTENT_COMPONENT JJTIKO INHALTSKOM REF 1 CN
39 BAPIBUSISM010_ITEM PRICE_GRP T188 KONDA REF 1 CN
40 BAPIBUSISM010_ITEM PRICINGPROCEDURE T683 KALSM REF 1 CN
41 BAPIBUSISM010_ITEM PROFIT_CTR CEPC PRCTR REF 1 CN
42 BAPIBUSISM010_ITEM PUBLICATION JDTDRER DRERZ REF 1 CN
43 BAPIBUSISM010_ITEM REQUIREMENT_TYPE TJJ73 BEDART REF 1 CN
44 BAPIBUSISM010_ITEM SALESORG_ORDER TVKO VKORG REF 1 CN
45 BAPIBUSISM010_ITEM SALES_AGT_TYPE TJJ09 JVERMART REF C CN
46 BAPIBUSISM010_ITEM SALES_GRP TVKGR VKGRP REF 1 CN
47 BAPIBUSISM010_ITEM SALES_OFF TVBUR VKBUR REF 1 CN
48 BAPIBUSISM010_ITEM SALES_UNIT T006 MSEHI REF 1 CN
49 BAPIBUSISM010_ITEM SCHEDULE_LINE_NO JHAE EIN_NR 1 CN
50 BAPIBUSISM010_ITEM SERVICE JJTDIEN MATNR REF 1 CN
51 BAPIBUSISM010_ITEM SERVICE_TYPE TJH71 DIENTYP REF 1 CN
52 BAPIBUSISM010_ITEM STATGRP_BOOKINGUNIT TJJ67 BEGRP_STAT REF 1 CN
53 BAPIBUSISM010_ITEM UNIT_OF_WT T006 MSEHI REF 1 CN
54 BAPIBUSISM010_ITEM UPDATE_GRP TMCB STAFO REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 464