SAP ABAP Table JHVFKFPALL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVFKFPALL	Table Relationship Diagram
Short Description	Generated Table for View

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	XEZER	☑	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
11	BANKS	☑	BANKS	LAND1	CHAR	3	0	Bank country key	T005
12	BANKN	☑	BANKN	BANKN	CHAR	18	0	Bank account number
13	BANKL	☑	BANKL	BANKL	CHAR	15	0	Bank number
14	BKONT	☑	BKONT	BKONT	CHAR	2	0	Bank Control Key
15	BVTYP	☑	BVTYP	BVTYP	CHAR	4	0	Partner bank type
16	FKART	☑	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
17	FKDAT	☑	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
18	FKTYP	☑	JHFKTYP	JHFKTYP	CHAR	1	0	IS-M/AM: Billing Category	TJH19
19	INCO1	☑	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
20	INCO2	☑	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
21	KNUMV	☑	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
22	KURST	☑	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
23	LAND1	☑	LLAND	LAND1	CHAR	3	0	Destination Country	T005
24	REGIO	☑	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
26	TAXK1	☑	JTACLGP1	JTACLGP	CHAR	1	0	IS-M: Tax classification for business partner
27	TAXK2	☑	JTACLGP2	JTACLGP	CHAR	1	0	IS-M: Tax classification 2 for business partner
28	TAXK3	☑	JTACLGP3	JTACLGP	CHAR	1	0	IS-M: Tax classification 3 for business partner
29	TAXK4	☑	JTACLGP4	JTACLGP	CHAR	1	0	IS-M: Tax classification 4 for business partner
30	TAXK5	☑	JTACLGP5	JTACLGP	CHAR	1	0	IS-M: Tax classification 5 for business partner
31	TAXK6	☑	JTACLGP6	JTACLGP	CHAR	1	0	IS-M: Tax classification 6 for business partner
32	TAXK7	☑	JTACLGP7	JTACLGP	CHAR	1	0	IS-M: Tax classification 7 for business partner
33	TAXK8	☑	JTACLGP8	JTACLGP	CHAR	1	0	IS-M: Tax classification 8 for business partner
34	TAXK9	☑	JTACLGP9	JTACLGP	CHAR	1	0	IS-M: Tax classification 9 for business partner
35	UEBAR	☑	JHUEBART	JHUEBART	CHAR	1	0	IS-M: Transfer type	TJH41
36	WAERK	☑	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
37	ZTERM	☑	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
38	VALTG	☑	VALTG	TAGE2	NUMC	2	0	Additional value days
39	VALDT	☑	VALDT	DATUM	DATS	8	0	Fixed value date
40	ZLSCH	☑	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
41	MSCHL	☑	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
42	MANSP	☑	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
43	NATIO	☑	INTER	NATION	CHAR	1	0	International address version ID	TSAV
44	ADRNR	☑	ISM_CPDADDRNUM	AD_ADDRNUM	CHAR	10	0	IS-M: One-Time Customer Address	ADRC
45	CCINS	☑	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
46	CCNUM	☑	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	VCNUM
47	DATBI	☑	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
48	CCNAME	☑	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
49	CCAUA	☑	CCAUA	CCAUA	CHAR	1	0	Payment cards: Authorization type
50	CCACT	☑	CCACT	SAKNR	CHAR	10	0	G/L Account Number for Payment Card Receivables	SKA1
51	AUDAT_CC	☑	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
52	AUTIM	☑	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
53	CCALL	☑	CCALL	CCALL	CHAR	1	0	Payment cards: Status when external system is called?
54	REACT	☑	REACT_SD	REACT_SD	CHAR	1	0	Payment cards: Response to authorization checks
55	AUTWR	☑	AUTWR	WERTV8	CURR	15	2	Payment cards: Authorized amount
56	CCWAE	☑	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
57	AUNUM	☑	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
58	AUTRA	☑	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
59	SETTL	☑	SETTL	XFELD	CHAR	1	0	Payment cards: Settlement carried out
60	CGUID	☑	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
61	ENCTP	☑	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
62	IBAN	☑	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
63	MNDID	☑	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
64	STTYP	☑	STORNOTYP	STORNOTYP	CHAR	1	0	IS-M: Reversal Type
65	MRNKZ	☑	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
66	EXPKZ	☑	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
67	EXNUM	☑	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
68	POPER	☑	POPER	POPER	NUMC	3	0	Posting period
69	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
70	MONAT	☑	MONAT	MONAT	NUMC	2	0	Fiscal period
71	XBLNR	☑	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
72	ZUONR	☑	DZUONR	ZUONR	CHAR	18	0	Assignment number
73	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
74	UNRFI	☑	JHUNRFI	CHAR10	CHAR	10	0	IS-M: Field is not used
75	KURRF	☑	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
76	CPKUR	☑	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
77	BRTWK	☑	JHBRTWRK	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency (Header)
78	NETWK	☑	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
79	MWSBK	☑	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
80	STWAE	☑	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
81	STAFO	☑	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
82	RFBSK	☑	JHRFBSK	JHRFBSK	CHAR	1	0	IS-M/AM: Status for Transfer to Accounting / HR
83	STAFI	☑	ISMSTAFI	ISMSTAFI	CHAR	1	0	IS-M: Status of the Financial Accounting Document
84	MABER	☑	MABER	MABER	CHAR	2	0	Dunning Area	T047M
85	VBTYP	☑	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
86	PERFK	☑	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
87	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
88	KTGRD	☑	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
89	PLTYP	☑	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
90	KUNRG	☑	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
91	KUNRE	☑	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
92	STCEG	☑	STCEG	STCEG	CHAR	20	0	VAT Registration Number
93	STCEG_H	☑	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
94	STCEG_L	☑	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	T005
95	LANDTX	☑	LANDTX	LAND1	CHAR	3	0	Tax Departure Country
96	COUNC	☑	COUNC	COUNC	CHAR	3	0	County Code
97	CITYC	☑	CITYC	CITYC	CHAR	4	0	City Code
98	TXJCD	☑	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
99	ZUKRI	☑	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
100	LOGSYS	☑	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
101	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
102	KREZE	☑	JHKREZE	GPNR	CHAR	10	0	IS-M: Payee	JGTGPNR
103	KRERS	☑	JHKRERS	GPNR	CHAR	10	0	IS-M: Invoicing Party	JGTGPNR
104	VNR	☑	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
105	VTYP	☑	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
106	KTGRV	☑	KTGRV	KTGRV	CHAR	2	0	IS-M: Account Assignment Group for Sales Agent Contract	TJJAF
107	UEBERLART	☑	UEBERLZIEL	UEBERLZIEL	CHAR	1	0	IS-M: Transfer Destination
108	PERNR	☑	JJPERNR	JPERNR	CHAR	20	0	IS-M: Personnel Number
109	VTNR	☑	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
110	ABRGNR	☑	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number	JHTVAABK
111	FAB_PROZNT	☑	FAB_PROZNT	DEC3_3	DEC	6	3	IS-M: Percentage Rate for Receivables Charge-Off
112	SD_VBELN_VF	☑	JHVBELN_VF	VBELN	CHAR	10	0	IS-M: SD Billing Number Referenced
113	POSNR	☑	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document
114	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
115	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
116	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
117	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
118	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
119	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
120	ARKTX	☐	ISM_ARKTX	TEXT40	CHAR	40	0	IS-M: Short Text for Document Item (Billing Doc.,Settlement)
121	AUBEL	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
122	AUPOS	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
123	AUGRP	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
124	AUETE	☐	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	JHAE
125	AVMAUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
126	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
127	BEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
128	BEINH_BAS	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
129	DRERZ	☐	JHDRERZ	DRERZ	CHAR	8	0	IS-M: Publication	JDTDRER
130	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
131	IHKOMP	☐	IKO_PREIS	INHALTSKOM	CHAR	8	0	IS-M: Content component for pricing call	JJTIKO
132	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
133	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
134	AZAFOV	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
135	AZAFO	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
136	AZAFA	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
137	AZAGST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
138	TERMINSPEZ	☐	TERMINSPEZ	TERMINSPEZ	CHAR	6	0	IS-M/AM: Specify Dates for Date Combinations
139	VAVTYP	☐	VAVARTYP	VAVARTYP	CHAR	2	0	Issue Variant Type	TJD05
140	CHIFFRE	☐	CHIFFRE_KZ	CHIFFRE_KZ	CHAR	1	0	IS-M: Box Number Indicator	TJH59
141	ABSRB	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
142	ABSBO	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
143	ABSFMPR	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
144	GO_PREIS	☐	GO_PREIS	GO_PREIS	CHAR	1	0	IS-M: Basic/Local Price
145	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
146	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
147	DIENSTL	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
148	DITYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
149	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
150	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
151	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
152	FSART	☐	ISP_FSART	ISP_FSART	CHAR	1	0	IS-M/AM: Billing Method
153	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
154	KTGRB	☐	KTGRB	KTGRB	CHAR	2	0	IS-M: Booking Unit Account Assignment Group	TJJ39
155	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
156	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
157	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
158	SHKZG	☐	JHSHKZG	JHSHKZG	CHAR	1	0	IS-M: Debit/Credit indicator
159	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
160	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
161	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
162	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
163	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
164	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
165	VGBEL	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
166	VGPOS	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
167	VGETE	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document
168	VGTYP	☐	ISPVBTYP_V	ISPVBTYP	CHAR	1	0	IS-M: Preceding Sales Document Category
169	VGOBJ	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
170	VGFKTYP	☐	JHVGFKTYP	JHFKTYP	CHAR	1	0	IS-M: Billing Category for Preceding Billing Document	TJH19
171	VBELV	☐	ISMVBELV	ISMVBELV	CHAR	10	0	IS-M: Originating sales document
172	POSNV	☐	ISMPOSNV	ISMPOSNR	NUMC	6	0	IS-M: Originating item
173	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
174	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
175	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
176	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
177	POSAR	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
178	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
179	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
180	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material
181	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material
182	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material
183	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material
184	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material
185	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material
186	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material
187	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material
188	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material
189	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
190	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
191	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
192	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
193	RK_AUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
194	RK_POSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
195	KOSTL_R2	☐	KOSTL_R2	KOSTL_R2	CHAR	8	0	Cost center in R/2
196	STGRB	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	TJJ67
197	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
198	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
199	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
200	KUNAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
201	ELAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
202	POSPA	☐	POSPA	POSNR	NUMC	6	0	Item number in the partner segment
203	PLTYP_AUFT	☐	PLTYP_AUFT	PLTYP	CHAR	2	0	Price list type of sales order
204	MPROK	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
205	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
206	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
207	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
208	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
209	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
210	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
211	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
212	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
213	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
214	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
215	BRTWP	☐	JHBRTWRP	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency (Item)
216	NETWP	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
217	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
218	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
219	UVPRS	☐	ISM_UVPRS	XFELD	CHAR	1	0	Incomplete with Regard to Pricing
220	UVALL	☐	JHUVALL	XFELD	CHAR	1	0	IS-M: Generally incomplete
221	XERLV	☐	JHXERLV	JHXERLV	CHAR	1	0	IS-M: Revenue Distribution Status
222	XPEAB	☐	JHXPEAB	XFELD	CHAR	1	0	IS-M: Period end accrual performed indicator
223	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
224	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
225	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
226	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
227	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
228	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
229	XCNCL	☐	JH_XCNCL	XFELD	CHAR	1	0	IS-M/AM: Reversal Indicator for Billing Item
230	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
231	PROVTYP	☐	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category
232	VZUONR	☐	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)
233	BERART	☐	JBERART	BERART	CHAR	1	0	IS-M/AM: Calculation Type for Media Sales Agent Commission
234	PBSCHL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
235	SCBAS	☐	JHSCBAS	JHSCBAS	CHAR	1	0	IS-M/AM: Scale Base Value for Commission Key
236	VERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
237	PR_BETRAG	☐	VPROZP	DEC4_3	DEC	7	3	IS-M: Sales Agent Share of Commission (in %)
238	PBBASIS	☐	JPBBASIS	WERTV7	CURR	13	2	IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.)
239	ISPBEDART	☐	VMBEDART	JVMBEDART	CHAR	2	0	IS-M/AM: Requirement Type in Media Sales Agent Contract
240	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
241	XSTEIG	☐	XJSTEIG	XFELD	CHAR	1	0	IS-M: Can be Incremented Indicator
242	VKORG_AUFT	☐	JHVKORGAUF	VKORG	CHAR	4	0	IS-M: Sales Organization for Customer Order	TVKO
243	EPROZ	☐	ISPPROZERL	ISPPROZERL	DEC	8	5	IS-M: Percentage rate from rev.distributed billing item
244	NETWPV	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
245	KTGRP	☐	JPVAKNTGRP	KTGRM	CHAR	2	0	Account assignment grouping for edition	TVKM
246	FP_STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
247	FP_ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
248	FP_ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
249	FP_ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
250	FP_AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
251	FP_AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
252	FP_AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
253	FP_TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
254	FP_ZUONR	☐	JHZUONR	ZUONR	CHAR	18	0	IS-M: Assignment number in FI document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVFKFPALL	ABRGNR	JHTVAABK	ABRGNR	REF	1	CN
2	JHVFKFPALL	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	JHVFKFPALL	ALAND	T005	LAND1
4	JHVFKFPALL	AUBEL	JHAK	AVM_NR	REF	1	CN
5	JHVFKFPALL	AUETE	JHAE	EIN_NR		1	CN
6	JHVFKFPALL	AUFNR	AUFK	AUFNR	KEY	1	CN
7	JHVFKFPALL	AUGRP	JHAGA	GRUPPABRNR	REF	1	CN
8	JHVFKFPALL	AUPOS	JHAP	POS_NR	REF	1	CN
9	JHVFKFPALL	AVMAUART	TJHAK	AUART	REF	1	CN
10	JHVFKFPALL	AZAFA	TJJ11	AZART_FARB	REF	1	CN
11	JHVFKFPALL	AZAFO	TJJ17	AZART_FORM	REF	1	CN
12	JHVFKFPALL	AZAFOV	TJJ13	AZART_AREA	REF	1	CN
13	JHVFKFPALL	AZAGST	TJJ19	AZART_GEST	REF	1	CN
14	JHVFKFPALL	BANKS	T005	LAND1	REF	1	CN
15	JHVFKFPALL	BEDNR	JJTVB	BEDNR	REF	1	CN
16	JHVFKFPALL	BEINH	JJTBE	BELEINH	REF	1	CN
17	JHVFKFPALL	BEINH_BAS	JJTBE	BELEINH	REF	1	CN
18	JHVFKFPALL	BUKRS	T001	BUKRS	REF	1	CN
19	JHVFKFPALL	BUKRS	T001	MANDT	REF	1	CN
20	JHVFKFPALL	CCACT	SKA1	SAKNR	REF	1	CN
21	JHVFKFPALL	CCINS	TVCIN	CCINS	REF	1	CN
22	JHVFKFPALL	CCNUM	VCNUM	CCNUM	REF	1	CN
23	JHVFKFPALL	CCWAE	TCURC	WAERS	REF	1	CN
24	JHVFKFPALL	CHIFFRE	TJH59	CHIFFRE_KZ	REF	1	CN
25	JHVFKFPALL	DIENSTL	JJTDIEN	MATNR	REF	1	CN
26	JHVFKFPALL	DITYP	TJH71	DIENTYP	REF	1	CN
27	JHVFKFPALL	DRERZ	JDTDRER	DRERZ	REF	1	CN
28	JHVFKFPALL	EKORG	T024E	EKORG	REF	1	CN
29	JHVFKFPALL	ELAND	T005	LAND1
30	JHVFKFPALL	EXNUM	EIKP	EXNUM	REF	1	CN
31	JHVFKFPALL	FKART	TJH05	FKART	REF	1	CN
32	JHVFKFPALL	FKTYP	TJH19	FKTYP
33	JHVFKFPALL	FP_STAFO	TMCB	STAFO	REF	1	CN
34	JHVFKFPALL	GEWEI	T006	MSEHI	REF	1	CN
35	JHVFKFPALL	GSBER	TGSB	GSBER	REF	1	CN
36	JHVFKFPALL	IHKOMP	JJTIKO	INHALTSKOM	REF	1	CN
37	JHVFKFPALL	INCO1	TINC	INCO1	REF	1	CN
38	JHVFKFPALL	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
39	JHVFKFPALL	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
40	JHVFKFPALL	INSERENT	JJVDB_MK_FK	GPNR	REF	1	CN
41	JHVFKFPALL	KALSM	T683	KALSM	REF	1	CN
42	JHVFKFPALL	KAPPL	T681A	KAPPL	REF	1	CN
43	JHVFKFPALL	KDGRP	T151	KDGRP	REF	1	CN
44	JHVFKFPALL	KOKRS	TKA01	KOKRS	REF	1	CN
45	JHVFKFPALL	KONDA	T188	KONDA	REF	1	CN
46	JHVFKFPALL	KOSTL	CSKS	KOSTL	REF	1	CN
47	JHVFKFPALL	KRERS	JGTGPNR	GPNR	REF	1	CN
48	JHVFKFPALL	KREZE	JGTGPNR	GPNR	REF	1	CN
49	JHVFKFPALL	KTGRB	TJJ39	KTGRB	REF	1	CN
50	JHVFKFPALL	KTGRD	TVKT	KTGRD	REF	1	CN
51	JHVFKFPALL	KTGRM	TVKM	KTGRM	REF	1	CN
52	JHVFKFPALL	KTGRP	TVKM	KTGRM	REF	1	CN
53	JHVFKFPALL	KTGRV	TJJAF	KTGRV	REF	C	CN
54	JHVFKFPALL	KUNAG	JGTGPNR	GPNR
55	JHVFKFPALL	KUNRE	JGTGPNR	GPNR	REF	1	CN
56	JHVFKFPALL	KUNRG	JGTGPNR	GPNR	REF	1	CN
57	JHVFKFPALL	KURST	TCURV	KURST	REF	1	CN
58	JHVFKFPALL	LAND1	T005	LAND1	REF	1	CN
59	JHVFKFPALL	LOGSYS	TBDLS	LOGSYS
60	JHVFKFPALL	MABER	T047M	MABER	REF	1	CN
61	JHVFKFPALL	MANDT	T000	MANDT	KEY	1	CN
62	JHVFKFPALL	MANSP	T040S	MANSP	REF	1	CN
63	JHVFKFPALL	MATNR	MARA	MATNR	REF	1	CN
64	JHVFKFPALL	MEINS	T006	MSEHI	REF	1	CN
65	JHVFKFPALL	MSCHL	T040	MSCHL	REF	1	CN
66	JHVFKFPALL	NATIO	TSAV	NATIO	REF	1	CN
67	JHVFKFPALL	PBSCHL	TJH23	PRSCHL	REF	C	CN
68	JHVFKFPALL	PERFK	TFACD	IDENT	REF	1	CN
69	JHVFKFPALL	PLTYP	T189	PLTYP	REF	1	CN
70	JHVFKFPALL	POSAR	TJH17	AVMPOS_ART	REF	1	CN
71	JHVFKFPALL	PRCTR	CEPC	PRCTR	REF	1	CN
72	JHVFKFPALL	PRODH	JJT179	PRODH	REF	1	CN
73	JHVFKFPALL	PSTYV	TJHAP	PSTYV	REF	1	CN
74	JHVFKFPALL	PVA	JDTPVA	PVA	REF	1	CN
75	JHVFKFPALL	REGIO	T005S	BLAND	REF	1	CN
76	JHVFKFPALL	SFAKN	JHTFK	VBELN	REF	C	CN
77	JHVFKFPALL	SPART	TSPA	SPART	REF	1	CN
78	JHVFKFPALL	STAFO	TMCB	STAFO	REF	1	CN
79	JHVFKFPALL	STCEG_L	T005	LAND1	REF
80	JHVFKFPALL	STGRB	TJJ67	BEGRP_STAT	REF	1	CN
81	JHVFKFPALL	STWAE	TCURC	WAERS	REF	1	CN
82	JHVFKFPALL	UEBAR	TJH41	UEBAR	REF	1	CN
83	JHVFKFPALL	VAVTYP	TJD05	VAVARTYP	REF	1	CN
84	JHVFKFPALL	VERMART	TJJ09	JVERMART	REF	C	CN
85	JHVFKFPALL	VGFKTYP	TJH19	FKTYP
86	JHVFKFPALL	VGOBJ	TJH97	OBJKT	REF
87	JHVFKFPALL	VKBUR	TVBUR	VKBUR	REF	1	CN
88	JHVFKFPALL	VKGRP	TVKGR	VKGRP	REF	1	CN
89	JHVFKFPALL	VKORG	TVKO	VKORG	REF	1	CN
90	JHVFKFPALL	VKORG_AUFT	TVKO	VKORG	REF	1	CN
91	JHVFKFPALL	VNR	JJTVV	VNR	REF	1	CN
92	JHVFKFPALL	VRKME	T006	MSEHI	REF	1	CN
93	JHVFKFPALL	VTNR	JHTVKO	VTNR	REF	1	CN
94	JHVFKFPALL	VTWEG	TVTW	VTWEG	REF	1	CN
95	JHVFKFPALL	WAERK	TCURC	WAERS	REF	1	CN
96	JHVFKFPALL	WERKS	T001W	WERKS	REF	1	CN
97	JHVFKFPALL	ZLSCH	T042Z	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in