SAP ABAP Table ISMAM_TXW_JHTFK (DART IS-M/AM: Billing/Settlement Document - Header)

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	ISMAM_TXW_JHTFK	Table Relationship Diagram
Short Description	DART IS-M/AM: Billing/Settlement Document - Header

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	*
3	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
4	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
5	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
6	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
7	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
8	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
9	SFAKN	☐	JJBELNRSV	JJBELNR	CHAR	10	0	IS-M: Reversal Reference	JHTFK
10	FKART	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
11	FKDAT	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
12	FKTYP	☐	JHFKTYP	JHFKTYP	CHAR	1	0	IS-M/AM: Billing Category	TJH19
13	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
14	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
15	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
16	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
17	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
18	ADRNR	☐	ISM_CPDADDRNUM	AD_ADDRNUM	CHAR	10	0	IS-M: One-Time Customer Address	ADRC
19	STTYP	☐	STORNOTYP	STORNOTYP	CHAR	1	0	IS-M: Reversal Type
20	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
21	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
22	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
23	BRTWK	☐	ISMAM_TXW_JHBRTWRK	CHAR18	CHAR	18	0	IS-M: Gross Value in Document Currency (Header)
24	NETWK	☐	ISMAM_TXW_NETWR	CHAR18	CHAR	18	0	Net Value in Document Currency
25	MWSBK	☐	ISMAM_TXW_MWSBP	CHAR18	CHAR	18	0	Tax Amount in Document Currency
26	RFBSK	☐	JHRFBSK	JHRFBSK	CHAR	1	0	IS-M/AM: Status for Transfer to Accounting / HR
27	STAFI	☐	ISMSTAFI	ISMSTAFI	CHAR	1	0	IS-M: Status of the Financial Accounting Document
28	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
29	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
30	KUNRG	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
31	KUNRE	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
32	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	*
33	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
34	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
35	KREZE	☐	JHKREZE	GPNR	CHAR	10	0	IS-M: Payee	JGTGPNR
36	KRERS	☐	JHKRERS	GPNR	CHAR	10	0	IS-M: Invoicing Party	JGTGPNR
37	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
38	VTYP	☐	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
39	PERNR	☐	JJPERNR	JPERNR	CHAR	20	0	IS-M: Personnel Number
40	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
41	ABRGNR	☐	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number	JHTVAABK
42	SD_VBELN_VF	☐	JHVBELN_VF	VBELN	CHAR	10	0	IS-M: SD Billing Number Referenced	*
43	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISMAM_TXW_JHTFK	ABRGNR	JHTVAABK	ABRGNR	REF	1	CN
2	ISMAM_TXW_JHTFK	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	ISMAM_TXW_JHTFK	BUKRS	T001	BUKRS	REF	1	CN
4	ISMAM_TXW_JHTFK	BUKRS	T001	MANDT	REF	1	CN
5	ISMAM_TXW_JHTFK	EKORG	T024E	EKORG	REF	1	CN
6	ISMAM_TXW_JHTFK	FKART	TJH05	FKART	REF	1	CN
7	ISMAM_TXW_JHTFK	FKTYP	TJH19	FKTYP
8	ISMAM_TXW_JHTFK	KRERS	JGTGPNR	GPNR	REF	1	CN
9	ISMAM_TXW_JHTFK	KREZE	JGTGPNR	GPNR	REF	1	CN
10	ISMAM_TXW_JHTFK	KUNRE	JGTGPNR	GPNR	REF	1	CN
11	ISMAM_TXW_JHTFK	KUNRG	JGTGPNR	GPNR	REF	1	CN
12	ISMAM_TXW_JHTFK	LAND1	T005	LAND1	REF	1	CN
13	ISMAM_TXW_JHTFK	LOGSYS	TBDLS	LOGSYS
14	ISMAM_TXW_JHTFK	MANDT	T000	MANDT	KEY	1	CN
15	ISMAM_TXW_JHTFK	SFAKN	JHTFK	VBELN	REF	C	CN
16	ISMAM_TXW_JHTFK	VKORG	TVKO	VKORG	REF	1	CN
17	ISMAM_TXW_JHTFK	VNR	JJTVV	VNR	REF	1	CN
18	ISMAM_TXW_JHTFK	VTNR	JHTVKO	VTNR	REF	1	CN
19	ISMAM_TXW_JHTFK	WAERK	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	471