SAP ABAP Table JFDFS (IS-M/SD: Billing/Settlement Index)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JFDFS	Table Relationship Diagram
Short Description	IS-M/SD: Billing/Settlement Index

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	OBJART_V	☑	OBJART_V	JOBJART	CHAR	4	0	IS-M: Previous object type
3	OBJID_V	☑	OBJID_V	JOBJID	CHAR	50	0	IS-M: Previous object ID
4	OBJART_N	☑	OBJART_N	JOBJART	CHAR	4	0	IS-M: Subsequent Object Type
5	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
6	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
7	FKDAT	☑	JFKDAT	DATUM	DATS	8	0	IS-M: Billing/Settlement Date
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
9	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
10	FKART	☐	JFKART	JFKART	CHAR	4	0	IS-M: Billing/Settlement Type	TJFK
11	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
12	POSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
13	FAKVON	☐	FAKVON	DATUM	DATS	8	0	IS-M: Billing Period From
14	FAKBIS	☐	FAKBIS	DATUM	DATS	8	0	IS-M: Billing Period To
15	JPERIOD	☐	JPERIOD	XFELD	CHAR	1	0	IS-M: Periodic settlement
16	NAMEK	☐	NAMEK	CHAR10	CHAR	10	0	IS-M: Abbreviated form of name for selection
17	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
18	VERSERVGES	☐	VERSERVGES	GPNR	CHAR	10	0	IS-M: Service Company	JGTVSG
19	LLAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
20	JZAHLW	☐	JZAHLW	JZAHLW	CHAR	1	0	Billing method
21	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
22	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
23	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
24	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
25	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
26	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
27	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
28	JSNABR	☐	JSNABR	JVBELN	CHAR	10	0	IS-M: Number of Reversal in Subsequent Document	*
29	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
30	XEINMAL	☐	XEINMALPRV	XFELD	CHAR	1	0	Indicator: One-time commission
31	XRENDITE	☐	XRENDITE	XFELD	CHAR	1	0	Renewal commission
32	XFBLGABR	☐	XFBLGABR	XFELD	CHAR	1	0	IS-M: Follow-on settlement documents
33	GPNR_RG	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	JGTGPNR
34	GPNR_RE	☐	GPNR_RE	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
35	SHKZG	☐	SHKZG_ISP	XFELD	CHAR	1	0	IS-M: Debit indicator for schedule line
36	PRSANTZ	☐	PRSANTZ	ISPWERT8	DEC	8	0	IS-M: Numerator for proportional prices
37	PRSANTN	☐	PRSANTN	ISPWERT8	DEC	8	0	IS-M: Denominator for proportional prices
38	PRSANZP	☐	PRSANZP	ISPWERT8	DEC	8	0	IS-M: Number of periods in billing period
39	BDPER	☐	BDPER	DATUM	DATS	8	0	IS-M: Basic Date for Billing Frequency
40	ISPXKOMPP	☐	XKOMPP	XFELD	CHAR	1	0	IS-M: Full period (billing)
41	XFSPERR	☐	XFSPERR	XFELD	CHAR	1	0	IS-M: Billing block deactivated
42	BEZIRK	☐	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	JVTBEZIRK
43	BEZRUNDE	☐	BEZRUNDE	BEZRUNDE	CHAR	10	0	IS-M: Delivery Round	JVTBEZRND
44	XINDART	☐	XINDART	XFELD	CHAR	1	0	IS-M: Index type
45	XPROVRUECK	☐	XPROVRUECK	XFELD	CHAR	1	0	Indicator: Commission recalculation for order item
46	ANZMONABRE	☐	ANZMONABRE	ISPMNG2	QUAN	2	0	IS-M: No.Months for Sett./Retroactive Acctg - One-Time Comm.
47	MINDBEZEIN	☐	MINDBEZEIN	MEINS	UNIT	3	0	Time Unit for Minimum Length of Subscription	*
48	XFKRUECK	☐	XFKRUECK	XFELD	CHAR	1	0	IS-M: Retroactive Billing of Period Already Billed
49	JKPAVONREG	☐	JKPAVONREG	DATUM	DATS	8	0	Normal Start of Address Validity for Retro.Order Items
50	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
51	FKPER	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
52	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
53	FKPERVON	☐	FKPERVON	DATUM	DATS	8	0	IS-M: Initial Date of Full Billing Period
54	FKPERBIS	☐	FKPERBIS	DATUM	DATS	8	0	IS-M: Closing Date of Full Billing Period
55	CYCLENR	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
56	FAKNRRUECK	☐	ISPFAKNRRUECK	ISPVBELN	CHAR	10	0	IS-M: Recalculated Billing Document	*
57	XFIXED	☐	XINDEXFIXED	XFELD	CHAR	1	0	Indicator: Billing Index Fixed and Cannot be Deleted
58	JKPABISREG	☐	JKPABISREG	DATUM	DATS	8	0	End of Address Validity if End of Billing Delayed
59	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
60	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
61	POSPONE	☐	JINVOICE_POSPONE	JINVOICE_POSPONE	CHAR	1	0	IS-M/SD: Reason for moving billing
62	XTRANSFER	☐	XTRANSFER_INV	XFELD	CHAR	1	0	IS-M/SD: Transfer billing document
63	DELIVSPLIT	☐	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	*
64	VBELN_FROM	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
65	POSNR_UR_FROM	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
66	CYCLENR_FROM	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
67	XPRICEALTER	☐	XPRICEALTERNATION	XFELD	CHAR	1	0	Indicator: Generated Index for Price Change
68	REFUNDTYPE	☐	REFUNDTYPE	REFUNDTYPE	CHAR	2	0	IS-M/SD: Refund Type	TJK19
69	XAUTO_ACCEPT	☐	XAUTO_ACCEPT	XFELD	CHAR	1	0	IS-M/SD: Indicator - Accept Cycle Without Payment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JFDFS	BEZIRK	JVTBEZIRK	BEZIRK
2	JFDFS	BEZRUNDE	JVTBEZRND	BEZRUNDE
3	JFDFS	DRERZ	JDTDRER	DRERZ	REF	1	CN
4	JFDFS	EKORG	T024E	EKORG	KEY	1	CN
5	JFDFS	FKART	TJFK	FKART	REF	1	CN
6	JFDFS	FKPER	TJK01	FKPER	REF	1	CN
7	JFDFS	GPNR	JGTGPNR	GPNR	KEY	1	CN
8	JFDFS	GPNR_RE	JGTGPNR	GPNR	REF	C	CN
9	JFDFS	GPNR_RG	JGTGPNR	GPNR	REF	C	CN
10	JFDFS	LLAND	T005	LAND1	KEY	1	CN
11	JFDFS	MANDT	T000	MANDT	KEY	1	CN
12	JFDFS	PERFK	TFACD	IDENT	REF	1	CN
13	JFDFS	POSNR	JKAP	POSNR	KEY	1	CN
14	JFDFS	POSNR_UR	JKAP	POSNR	REF	C	CN
15	JFDFS	REFUNDTYPE	TJK19	REFUNDTYPE	REF
16	JFDFS	SPART	TSPA	SPART	REF	1	CN
17	JFDFS	VBELN	JKAK	VBELN	KEY	1	CN
18	JFDFS	VERSERVGES	JGTVSG	VERSERVGES	KEY	1	CN
19	JFDFS	VKORG	TVKO	VKORG	KEY	1	CN
20	JFDFS	VTWEG	TVTW	VTWEG	REF	1	CN
21	JFDFS	ZLSCH	T042Z	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in