SAP ABAP Table RJHFKVB (IS-PAM: Update program JHTFK)

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	RJHFKVB	Table Relationship Diagram
Short Description	IS-PAM: Update program JHTFK

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	.INCLUDE	☐				0	0	IS-M/AM: Settlement Documents (Billing, Commission) - Header
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	*
4	.INCLUDE	☐				0	0	IS-M/AM: Settlement Documents - Header- Data Part
5	.INCLUDE	☐				0	0	IS-PAM: Settlement Documents - Header - Gen.Customer Fields
6	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
7	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
8	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
9	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
10	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
11	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
12	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
13	.INCLUDE	☐				0	0	IS-M: Settlement Document - Customer Hdr Fields -Interface
14	SFAKN	☐	JJBELNRSV	JJBELNR	CHAR	10	0	IS-M: Reversal Reference	JHTFK
15	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
16	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
17	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
18	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
19	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
20	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
21	FKART	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
22	FKDAT	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
23	FKTYP	☐	JHFKTYP	JHFKTYP	CHAR	1	0	IS-M/AM: Billing Category	TJH19
24	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
25	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
26	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
27	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
28	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
29	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
30	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
31	.INCLUDE	☐				0	0	IS-M/AM: Tax classification for business partner
32	TAXK1	☐	JTACLGP1	JTACLGP	CHAR	1	0	IS-M: Tax classification for business partner
33	TAXK2	☐	JTACLGP2	JTACLGP	CHAR	1	0	IS-M: Tax classification 2 for business partner
34	TAXK3	☐	JTACLGP3	JTACLGP	CHAR	1	0	IS-M: Tax classification 3 for business partner
35	TAXK4	☐	JTACLGP4	JTACLGP	CHAR	1	0	IS-M: Tax classification 4 for business partner
36	TAXK5	☐	JTACLGP5	JTACLGP	CHAR	1	0	IS-M: Tax classification 5 for business partner
37	TAXK6	☐	JTACLGP6	JTACLGP	CHAR	1	0	IS-M: Tax classification 6 for business partner
38	TAXK7	☐	JTACLGP7	JTACLGP	CHAR	1	0	IS-M: Tax classification 7 for business partner
39	TAXK8	☐	JTACLGP8	JTACLGP	CHAR	1	0	IS-M: Tax classification 8 for business partner
40	TAXK9	☐	JTACLGP9	JTACLGP	CHAR	1	0	IS-M: Tax classification 9 for business partner
41	UEBAR	☐	JHUEBART	JHUEBART	CHAR	1	0	IS-M: Transfer type	TJH41
42	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
43	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
44	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
45	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
46	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
47	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
48	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
49	NATIO	☐	INTER	NATION	CHAR	1	0	International address version ID	TSAV
50	ADRNR	☐	ISM_CPDADDRNUM	AD_ADDRNUM	CHAR	10	0	IS-M: One-Time Customer Address	ADRC
51	.INCLUDE	☐				0	0	IS-M/AM: Payment cards: Data in Billing
52	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
53	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	VCNUM
54	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
55	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
56	CCAUA	☐	CCAUA	CCAUA	CHAR	1	0	Payment cards: Authorization type
57	CCACT	☐	CCACT	SAKNR	CHAR	10	0	G/L Account Number for Payment Card Receivables	SKA1
58	AUDAT_CC	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
59	AUTIM	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
60	CCALL	☐	CCALL	CCALL	CHAR	1	0	Payment cards: Status when external system is called?
61	REACT	☐	REACT_SD	REACT_SD	CHAR	1	0	Payment cards: Response to authorization checks
62	AUTWR	☐	AUTWR	WERTV8	CURR	15	2	Payment cards: Authorized amount
63	CCWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
64	AUNUM	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
65	AUTRA	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
66	SETTL	☐	SETTL	XFELD	CHAR	1	0	Payment cards: Settlement carried out
67	.INCLUDE	☐				0	0	Credit Card Encryption
68	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
69	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
70	.INCLUDE	☐				0	0	IS-M/AM: Include for IBAN
71	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
72	.INCLUDE	☐				0	0	IS-M/AM: Include for SEPA Mandates
73	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
74	STTYP	☐	STORNOTYP	STORNOTYP	CHAR	1	0	IS-M: Reversal Type
75	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
76	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
77	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
78	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
79	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
80	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
81	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
82	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
83	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
84	UNRFI	☐	JHUNRFI	CHAR10	CHAR	10	0	IS-M: Field is not used
85	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
86	CPKUR	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
87	BRTWK	☐	JHBRTWRK	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency (Header)
88	NETWK	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
89	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
90	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
91	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
92	RFBSK	☐	JHRFBSK	JHRFBSK	CHAR	1	0	IS-M/AM: Status for Transfer to Accounting / HR
93	STAFI	☐	ISMSTAFI	ISMSTAFI	CHAR	1	0	IS-M: Status of the Financial Accounting Document
94	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
95	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
96	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
97	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
98	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
99	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
100	KUNRG	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
101	KUNRE	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
102	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
103	STCEG_H	☐	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
104	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	T005
105	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	*
106	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
107	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
108	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
109	ZUKRI	☐	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
110	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
111	.INCLUDE	☐				0	0	IS-PAM: Settlement documents - gen.vendor header data
112	.INCLUDE	☐				0	0	IS-M: Settlement docs - gen. vendor header data - interface
113	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
114	KREZE	☐	JHKREZE	GPNR	CHAR	10	0	IS-M: Payee	JGTGPNR
115	KRERS	☐	JHKRERS	GPNR	CHAR	10	0	IS-M: Invoicing Party	JGTGPNR
116	.INCLUDE	☐				0	0	IS-PAM: Settlement documents - header - commission fields
117	.INCLUDE	☐				0	0	IS-PAM: Settlement Documents - Header Commission Data-Intrf.
118	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
119	VTYP	☐	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
120	KTGRV	☐	KTGRV	KTGRV	CHAR	2	0	IS-M: Account Assignment Group for Sales Agent Contract	TJJAF
121	UEBERLART	☐	UEBERLZIEL	UEBERLZIEL	CHAR	1	0	IS-M: Transfer Destination
122	PERNR	☐	JJPERNR	JPERNR	CHAR	20	0	IS-M: Personnel Number
123	.INCLUDE	☐				0	0	IS-M: Settlement document headers - COA data interface
124	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
125	ABRGNR	☐	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number	JHTVAABK
126	.INCLUDE	☐				0	0	IS-M/AM: Billing Documents - BD Header Data Via Interface
127	FAB_PROZNT	☐	FAB_PROZNT	DEC3_3	DEC	6	3	IS-M: Percentage Rate for Receivables Charge-Off
128	SD_VBELN_VF	☐	JHVBELN_VF	VBELN	CHAR	10	0	IS-M: SD Billing Number Referenced	*
129	.INCLUDE	☐				0	0	IS-M: Non database part of update structure for JHTFK
130	VBELN_DB	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	*
131	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
132	HIPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
133	INCPO	☐	INCPO	NUM6	NUMC	6	0	Increment of item number in the SD document
134	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
135	NAMRG	☐	NAME1	TEXT30	CHAR	30	0	Name
136	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
137	UVALS	☐	UVALL	XFELD	CHAR	1	0	Generally incomplete
138	UVPRS	☐	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
139	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
140	BOREL	☐	BOREL	XFELD	CHAR	1	0	Relevant for rebate
141	NUMKI	☐	NUMKI	NUMKR	CHAR	2	0	Number range in the case of internal number assignment
142	ANZOBK	☐	SYTFILL	SYST_LONG	INT4	10	0	Number of Rows in Internal Tables
143	VBPANZ	☐	VBPANZ	TABIX	INT4	10	0	Number of items in Sales and Distribution document
144	JZUOVBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
145	XKOMV_UPD	☐	JHKONDUPD	XFELD	CHAR	1	0	IS-M: Conditions were changed
146	XNAST	☐	XFELD	XFELD	CHAR	1	0	Checkbox
147	.INCLUDE	☐				0	0	IS-M: Dyn.part JHTFK, Billing interface for COA
148	ABS_INS	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
149	XORDENV	☐	XFELD	XFELD	CHAR	1	0	Checkbox
150	MIN_FKDAT	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
151	MAX_FKDAT	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
152	.INCLUDE	☐				0	0	IS-M/AM: Receivables Charge-Off
153	FAB_BETRAG	☐	FAB_BETRG1	WERTV8	CURR	15	2	IS-M: Charge-Off Amount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHFKVB	ABRGNR	JHTVAABK	ABRGNR	REF	1	CN
2	RJHFKVB	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	RJHFKVB	BANKS	T005	LAND1	REF	1	CN
4	RJHFKVB	BUKRS	T001	BUKRS	REF	1	CN
5	RJHFKVB	BUKRS	T001	MANDT	REF	1	CN
6	RJHFKVB	CCACT	SKA1	SAKNR	REF	1	CN
7	RJHFKVB	CCINS	TVCIN	CCINS	REF	1	CN
8	RJHFKVB	CCNUM	VCNUM	CCNUM	REF	1	CN
9	RJHFKVB	CCWAE	TCURC	WAERS	REF	1	CN
10	RJHFKVB	EKORG	T024E	EKORG	REF	1	CN
11	RJHFKVB	EXNUM	EIKP	EXNUM	REF	1	CN
12	RJHFKVB	FKART	TJH05	FKART	REF	1	CN
13	RJHFKVB	FKTYP	TJH19	FKTYP
14	RJHFKVB	INCO1	TINC	INCO1	REF	1	CN
15	RJHFKVB	KRERS	JGTGPNR	GPNR	REF	1	CN
16	RJHFKVB	KREZE	JGTGPNR	GPNR	REF	1	CN
17	RJHFKVB	KTGRD	TVKT	KTGRD	REF	1	CN
18	RJHFKVB	KTGRV	TJJAF	KTGRV	REF	C	CN
19	RJHFKVB	KUNRE	JGTGPNR	GPNR	REF	1	CN
20	RJHFKVB	KUNRG	JGTGPNR	GPNR	REF	1	CN
21	RJHFKVB	KURST	TCURV	KURST	REF	1	CN
22	RJHFKVB	LAND1	T005	LAND1	REF	1	CN
23	RJHFKVB	LOGSYS	TBDLS	LOGSYS
24	RJHFKVB	MABER	T047M	MABER	REF	1	CN
25	RJHFKVB	MANDT	T000	MANDT	KEY	1	CN
26	RJHFKVB	MANSP	T040S	MANSP	REF	1	CN
27	RJHFKVB	MSCHL	T040	MSCHL	REF	1	CN
28	RJHFKVB	NATIO	TSAV	NATIO	REF	1	CN
29	RJHFKVB	PERFK	TFACD	IDENT	REF	1	CN
30	RJHFKVB	PLTYP	T189	PLTYP	REF	1	CN
31	RJHFKVB	REGIO	T005S	BLAND	REF	1	CN
32	RJHFKVB	SFAKN	JHTFK	VBELN	REF	C	CN
33	RJHFKVB	STAFO	TMCB	STAFO	REF	1	CN
34	RJHFKVB	STCEG_L	T005	LAND1	REF
35	RJHFKVB	STWAE	TCURC	WAERS	REF	1	CN
36	RJHFKVB	UEBAR	TJH41	UEBAR	REF	1	CN
37	RJHFKVB	VKORG	TVKO	VKORG	REF	1	CN
38	RJHFKVB	VNR	JJTVV	VNR	REF	1	CN
39	RJHFKVB	VTNR	JHTVKO	VTNR	REF	1	CN
40	RJHFKVB	WAERK	TCURC	WAERS	REF	1	CN
41	RJHFKVB	ZLSCH	T042Z	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in