SAP ABAP Table BAPIBUSISM010_HEAD (IS-M/AM: Billing Document Header (BO AdMgmtBillingDoc))

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_HEAD	Table Relationship Diagram
Short Description	IS-M/AM: Billing Document Header (BO AdMgmtBillingDoc)

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	*
2	CREATEDBY	☐	ERFUSER	USNAM	CHAR	12	0	Created By
3	CREATEDON	☐	ERFDATE	DATUM	DATS	8	0	Created On
4	CREATEDAT	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
5	CHANGEDBY	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
6	CHANGEDON	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
7	CHANGEDAT	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
8	CANCELREFDOC	☐	JJBELNRSV	JJBELNR	CHAR	10	0	IS-M: Reversal Reference	*
9	COLL_AUTH	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
10	BANK_CTRY	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
11	BANK_CTRYISO	☐	LAND1_ISO	INTCA	CHAR	2	0	Country key in ISO code
12	BANK_ACCT	☐	BANKN	BANKN	CHAR	18	0	Bank account number
13	BANK_NO	☐	BANKL	BANKL	CHAR	15	0	Bank number
14	CTRL_KEY	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
15	PARTNER_BK	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
16	BILLINGTYPE	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
17	BILLINGDATE	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
18	BILLINGCATEGORY	☐	JHFKTYP	JHFKTYP	CHAR	1	0	IS-M/AM: Billing Category	TJH19
19	INCOTERMS1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
20	INCOTERMS2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
21	EXCHG_RATE	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
22	DEST_CNTRY	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
23	DEST_CNTRYISO	☐	LAND1_ISO	INTCA	CHAR	2	0	Country key in ISO code
24	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
26	TAX_CLASS1	☐	JTACLGP1	JTACLGP	CHAR	1	0	IS-M: Tax classification for business partner
27	TAX_CLASS2	☐	JTACLGP2	JTACLGP	CHAR	1	0	IS-M: Tax classification 2 for business partner
28	TAX_CLASS3	☐	JTACLGP3	JTACLGP	CHAR	1	0	IS-M: Tax classification 3 for business partner
29	TAX_CLASS4	☐	JTACLGP4	JTACLGP	CHAR	1	0	IS-M: Tax classification 4 for business partner
30	TAX_CLASS5	☐	JTACLGP5	JTACLGP	CHAR	1	0	IS-M: Tax classification 5 for business partner
31	TAX_CLASS6	☐	JTACLGP6	JTACLGP	CHAR	1	0	IS-M: Tax classification 6 for business partner
32	TAX_CLASS7	☐	JTACLGP7	JTACLGP	CHAR	1	0	IS-M: Tax classification 7 for business partner
33	TAX_CLASS8	☐	JTACLGP8	JTACLGP	CHAR	1	0	IS-M: Tax classification 8 for business partner
34	TAX_CLASS9	☐	JTACLGP9	JTACLGP	CHAR	1	0	IS-M: Tax classification 9 for business partner
35	TRANSFERTYPE	☐	JHUEBART	JHUEBART	CHAR	1	0	IS-M: Transfer type	TJH41
36	CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
37	CURRENCYISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
38	PMNTTRMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
39	ADD_VAL_DY	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
40	FIX_VAL_DY	☐	VALDT	DATUM	DATS	8	0	Fixed value date
41	PAYMENTMETHOD	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
42	DUNN_KEY	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
43	DUNN_BLOCK	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
44	DUNN_AREA	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
45	CPDADDRESS	☐	ISM_CPDADDRNUM	AD_ADDRNUM	CHAR	10	0	IS-M: One-Time Customer Address	*
46	CC_TYPE	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
47	CC_NUMBER	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
48	CC_VALID_T	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
49	CC_NAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
50	AUTHORTYPE	☐	CCAUA	CCAUA	CHAR	1	0	Payment cards: Authorization type
51	AUTH_DATE	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
52	AUTH_TIME	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
53	AUTH_CALLSTATUS	☐	CCALL	CCALL	CHAR	1	0	Payment cards: Status when external system is called?
54	CC_REACT	☐	REACT_SD	REACT_SD	CHAR	1	0	Payment cards: Response to authorization checks
55	AUTHAMOUNT	☐	ISM_INVOICE_AUTHAMOUNT	BAPICURR	DEC	23	4	IS-M: Payment Cards: Authorized Amount (BAPICURR)
56	CC_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
57	CC_CURRENCYISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
58	CC_AUTTH_NO	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
59	AUTH_REFNO	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
60	CC_SETTLED	☐	SETTL	XFELD	CHAR	1	0	Payment cards: Settlement carried out
61	CC_ACCOUNT	☐	CCACT	SAKNR	CHAR	10	0	G/L Account Number for Payment Card Receivables	*
62	CANCELLATIONTYPE	☐	STORNOTYP	STORNOTYP	CHAR	1	0	IS-M: Reversal Type
63	MN_INVOICE	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
64	EXPORTINDICATOR	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
65	EXPORT_NO	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	*
66	POSTINGPERIOD	☐	POPER	POPER	NUMC	3	0	Posting period
67	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
68	FIS_PERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
69	REF_DOC_NO	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
70	ALLOC_NMBR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
71	AC_DOC_NO	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
72	EXCH_RATE_FI	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
73	FIXED_EXCH_RATE	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
74	GROSSVALUE	☐	ISM_INVOICE_GROSSVALUE	BAPICURR	DEC	23	4	IS-M: Gross Value in Billing Document (BAPICURR)
75	NET_VALUE	☐	ISM_INVOICE_NET_VALUE	BAPICURR	DEC	23	4	IS-M: Net Value in Billing Document (BAPICURR)
76	TAX_AMOUNT	☐	ISM_INVOICE_TAX_AMOUNT	BAPICURR	DEC	23	4	IS-M: Tax Amount in Billing Document (BAPICURR)
77	STATISTICSCURRENCY	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
78	STATISTICSCURRENCYISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
79	UPDATE_GRP	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
80	POSTINGSTATUS	☐	JHRFBSK	JHRFBSK	CHAR	1	0	IS-M/AM: Status for Transfer to Accounting / HR
81	FIDOCUMENTSTATUS	☐	ISMSTAFI	ISMSTAFI	CHAR	1	0	IS-M: Status of the Financial Accounting Document
82	SALESDOCCATEGORY	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
83	BILL_SCHED	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
84	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
85	ACCNT_ASGN	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
86	PRICE_LIST	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
87	PAYER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
88	PAYER_EXTERNAL	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
89	BILL_TO_PARTY	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
90	BILL_TO_PARTY_EXTERNAL	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
91	VAT_REG_NO	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
92	VAT_ORIGIN	☐	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
93	VAT_CNTRY	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	T005
94	VAT_CNTRYISO	☐	LAND1_ISO	INTCA	CHAR	2	0	Country key in ISO code
95	TAX_DEPART_CTY	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	T005
96	TAX_DEPART_CTYISO	☐	LAND1_ISO	INTCA	CHAR	2	0	Country key in ISO code
97	COUNTY_CDE	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
98	CITY_CODE	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
99	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
100	COMBIN_CRITERIA	☐	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
101	LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
102	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
103	PAYEE	☐	JHKREZE	GPNR	CHAR	10	0	IS-M: Payee	JGTGPNR
104	PAYEE_EXTERNAL	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
105	INVOICINGPARTY	☐	JHKRERS	GPNR	CHAR	10	0	IS-M: Invoicing Party	JGTGPNR
106	INVOICINGPARTY_EXTERNAL	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
107	SALES_AGT_CONTRACT_NO	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
108	SALES_AGT_CONTRACT_CATEGORY	☐	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
109	ACCNT_ASGN_SAGENT	☐	KTGRV	KTGRV	CHAR	2	0	IS-M: Account Assignment Group for Sales Agent Contract	TJJAF
110	TRANSFERDESTINATION	☐	UEBERLZIEL	UEBERLZIEL	CHAR	1	0	IS-M: Transfer Destination
111	PERSONNELNO	☐	JJPERNR	JPERNR	CHAR	20	0	IS-M: Personnel Number
112	COA_NUMBER	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	*
113	COA_SETTLEMENTNO	☐	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number	*
114	PERCENT	☐	FAB_PROZNT	DEC3_3	DEC	6	3	IS-M: Percentage Rate for Receivables Charge-Off
115	REF_SD_DOC	☐	JHVBELN_VF	VBELN	CHAR	10	0	IS-M: SD Billing Number Referenced	*
116	REF_DOC_NO_LONG	☐	XBLNR_LONG	XBLNR_LONG	CHAR	35	0	Reference Document Number (for Dependencies see Long Text)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIBUSISM010_HEAD	ACCNT_ASGN	TVKT	KTGRD	REF	1	CN
2	BAPIBUSISM010_HEAD	ACCNT_ASGN_SAGENT	TJJAF	KTGRV	REF	1	CN
3	BAPIBUSISM010_HEAD	BANK_CTRY	T005	LAND1	REF	1	CN
4	BAPIBUSISM010_HEAD	BILLINGCATEGORY	TJH19	FKTYP	REF	1	CN
5	BAPIBUSISM010_HEAD	BILLINGTYPE	TJH05	FKART	REF	1	CN
6	BAPIBUSISM010_HEAD	BILL_SCHED	TFACD	IDENT	REF	1	CN
7	BAPIBUSISM010_HEAD	BILL_TO_PARTY	JGTGPNR	GPNR	REF	1	CN
8	BAPIBUSISM010_HEAD	CC_CURRENCY	TCURC	WAERS	REF	1	CN
9	BAPIBUSISM010_HEAD	CC_TYPE	TVCIN	CCINS	REF	1	CN
10	BAPIBUSISM010_HEAD	CITY_CODE	T005G	CITYC	REF	1	CN
11	BAPIBUSISM010_HEAD	COMP_CODE	T001	BUKRS	REF	1	CN
12	BAPIBUSISM010_HEAD	COUNTY_CDE	T005E	COUNC	REF	1	CN
13	BAPIBUSISM010_HEAD	CURRENCY	TCURC	WAERS	REF	1	CN
14	BAPIBUSISM010_HEAD	DEST_CNTRY	T005	LAND1	REF	1	CN
15	BAPIBUSISM010_HEAD	DUNN_AREA	T047M	MABER	REF	1	CN
16	BAPIBUSISM010_HEAD	DUNN_BLOCK	T040S	MANSP	REF	1	CN
17	BAPIBUSISM010_HEAD	DUNN_KEY	T040	MSCHL	REF	1	CN
18	BAPIBUSISM010_HEAD	EXCHG_RATE	TCURV	KURST	REF	1	CN
19	BAPIBUSISM010_HEAD	INCOTERMS1	TINC	INCO1	REF	1	CN
20	BAPIBUSISM010_HEAD	INVOICINGPARTY	JGTGPNR	GPNR	REF	1	CN
21	BAPIBUSISM010_HEAD	LOG_SYSTEM	TBDLS	LOGSYS
22	BAPIBUSISM010_HEAD	PAYEE	JGTGPNR	GPNR	REF	1	CN
23	BAPIBUSISM010_HEAD	PAYER	JGTGPNR	GPNR	REF	1	CN
24	BAPIBUSISM010_HEAD	PAYMENTMETHOD	T042Z	ZLSCH	REF	1	CN
25	BAPIBUSISM010_HEAD	PRICE_LIST	T189	PLTYP	REF	1	CN
26	BAPIBUSISM010_HEAD	PURCH_ORG	T024E	EKORG	REF	1	CN
27	BAPIBUSISM010_HEAD	REGION	T005S	BLAND	REF	1	CN
28	BAPIBUSISM010_HEAD	SALESORG	TVKO	VKORG	REF	1	CN
29	BAPIBUSISM010_HEAD	SALES_AGT_CONTRACT_NO	JJTVV	VNR	REF	1	CN
30	BAPIBUSISM010_HEAD	STATISTICSCURRENCY	TCURC	WAERS	REF	1	CN
31	BAPIBUSISM010_HEAD	TAX_DEPART_CTY	T005	LAND1	REF	1	CN
32	BAPIBUSISM010_HEAD	TRANSFERTYPE	TJH41	UEBAR	REF	1	CN
33	BAPIBUSISM010_HEAD	UPDATE_GRP	TMCB	STAFO	REF	1	CN
34	BAPIBUSISM010_HEAD	VAT_CNTRY	T005	LAND1	REF

History

Last changed by/on	SAP	20130529
SAP Release Created in	464