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

Dictionary Type: Table
Description: IS-M/SD: Billing/Settlement Index




ABAP Code to SELECT data from JFDFS
Related tables to JFDFS
Access table JFDFS




Table field list including key, data, relationships and ABAP select examples

JFDFS is a standard SAP Table which is used to store IS-M/SD: Billing/Settlement Index data and is available within R/3 SAP systems depending on the version and release level.

The JFDFS table consists of various fields, each holding specific information or linking keys about IS-M/SD: Billing/Settlement Index data available in SAP. These include OBJART_V (IS-M: Previous object type), OBJID_V (IS-M: Previous object ID), OBJART_N (IS-M: Subsequent Object Type), VKORG (Sales Organization).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP JFDFS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
OBJART_VIS-M: Previous object type OBJART_VCHAR4JOBJART
OBJID_VIS-M: Previous object ID OBJID_VCHAR50JOBJID
OBJART_NIS-M: Subsequent Object Type OBJART_NCHAR4JOBJART
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
FKDATIS-M: Billing/Settlement Date JFKDATDATS8DATUM
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
FKARTIS-M: Billing/Settlement Type JFKARTCHAR4TJFKJFKART
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10JKAKALPHAAVNRJK1MJK1
POSNRSales Order Item APNRNUMC6JKAPAPNR
FAKVONIS-M: Billing Period From FAKVONDATS8DATUM
FAKBISIS-M: Billing Period To FAKBISDATS8DATUM
JPERIODIS-M: Periodic settlement JPERIODCHAR1XFELD
NAMEKIS-M: Abbreviated form of name for selection NAMEKCHAR10CHAR10
GPNRIS-M: Business Partner Key GPNRCHAR10JGTGPNRALPHAGPNRJGPMJG0
VERSERVGESIS-M: Service Company VERSERVGESCHAR10JGTVSGALPHAGPNRJGFMJG0G
LLANDCountry of Destination LLANDCHAR3T005LAND1VLL
JZAHLWBilling method JZAHLWCHAR1JZAHLWJKZAHLW
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
BANKSBank country key BANKSCHAR3Assigned to domainLAND1BKL
BANKLBank Keys BANKKCHAR15BANKKBNK
BANKNBank account number BANKNCHAR18BANKN
BKONTBank Control Key BKONTCHAR2BKONT
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
XEZERIndicator: Is there collection authorization ? XEZERCHAR1XFELD
JSNABRIS-M: Number of Reversal in Subsequent Document JSNABRCHAR10Assigned to domainALPHAJVBELN
POSEXExternal Item Number (Purchase Order Item) POSEX_ISPNUMC6POSEX_ISPJK2
XEINMALIndicator: One-time commission XEINMALPRVCHAR1XFELD
XRENDITERenewal commission XRENDITECHAR1XFELD
XFBLGABRIS-M: Follow-on settlement documents XFBLGABRCHAR1XFELD
GPNR_RGIS-M: Payer Business Partner GPNR_RGCHAR10JGTGPNRALPHAGPNR
GPNR_REIS-M: Business Partner - Bill-To Party GPNR_RECHAR10JGTGPNRALPHAGPNR
SHKZGIS-M: Debit indicator for schedule line SHKZG_ISPCHAR1XFELD
PRSANTZIS-M: Numerator for proportional prices PRSANTZDEC8ISPWERT8
PRSANTNIS-M: Denominator for proportional prices PRSANTNDEC8ISPWERT8
PRSANZPIS-M: Number of periods in billing period PRSANZPDEC8ISPWERT8
BDPERIS-M: Basic Date for Billing Frequency BDPERDATS8DATUM
ISPXKOMPPIS-M: Full period (billing) XKOMPPCHAR1XFELD
XFSPERRIS-M: Billing block deactivated XFSPERRCHAR1XFELD
BEZIRKCarrier Route BEZIRKCHAR10JVTBEZIRKALPHABEZIRKBEZMJVC
BEZRUNDEIS-M: Delivery Round BEZRUNDECHAR10JVTBEZRNDALPHABEZRUNDEJBR
XINDARTIS-M: Index type XINDARTCHAR1XFELD
XPROVRUECKIndicator: Commission recalculation for order item XPROVRUECKCHAR1XFELD
ANZMONABREIS-M: No.Months for Sett./Retroactive Acctg - One-Time Comm. ANZMONABREQUAN2ISPMNG2
MINDBEZEINTime Unit for Minimum Length of Subscription MINDBEZEINUNIT3Assigned to domainCUNITMEINS
XFKRUECKIS-M: Retroactive Billing of Period Already Billed XFKRUECKCHAR1XFELD
JKPAVONREGNormal Start of Address Validity for Retro.Order Items JKPAVONREGDATS8DATUM
DRERZPublication DRERZCHAR8JDTDRERALPHADRERZJD1MJD1
FKPERBilling Frequency FKPERCHAR2TJK01FKPERJFKPER
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
FKPERVONIS-M: Initial Date of Full Billing Period FKPERVONDATS8DATUM
FKPERBISIS-M: Closing Date of Full Billing Period FKPERBISDATS8DATUM
CYCLENRIS-M/SD: Billing Cycle Number CYCLENRNUMC3Assigned to domainCYCLENR
FAKNRRUECKIS-M: Recalculated Billing Document ISPFAKNRRUECKCHAR10Assigned to domainALPHAISPVBELNVF
XFIXEDIndicator: Billing Index Fixed and Cannot be Deleted XINDEXFIXEDCHAR1XFELD
JKPABISREGEnd of Address Validity if End of Billing Delayed JKPABISREGDATS8DATUM
POSNR_UROriginal Item in Publishing Sales Order APNR_URNUMC6JKAPAPNR
PERFKInvoice dates (calendar identification) PERFKCHAR2TFACDWFCID
POSPONEIS-M/SD: Reason for moving billing JINVOICE_POSPONECHAR1JINVOICE_POSPONE
XTRANSFERIS-M/SD: Transfer billing document XTRANSFER_INVCHAR1XFELD
DELIVSPLITIS-M/SD: Alternating Address Element DELIVSPLITCHAR8Assigned to domainALPHADELIVSPLIT
VBELN_FROMIS-M/SD: Publishing Sales Order AVNRCHAR10Assigned to domainALPHAAVNRJK1MJK1
POSNR_UR_FROMSales Order Item APNRNUMC6Assigned to domainAPNR
CYCLENR_FROMIS-M/SD: Billing Cycle Number CYCLENRNUMC3Assigned to domainCYCLENR
XPRICEALTERIndicator: Generated Index for Price Change XPRICEALTERNATIONCHAR1XFELD
REFUNDTYPEIS-M/SD: Refund Type REFUNDTYPECHAR2TJK19REFUNDTYPE
XAUTO_ACCEPTIS-M/SD: Indicator - Accept Cycle Without Payment XAUTO_ACCEPTCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table JFDFS using ABAP code

The following ABAP code Example will allow you to do a basic selection on JFDFS to SELECT all data from the table
DATA: WA_JFDFS TYPE JFDFS.

SELECT SINGLE *
FROM JFDFS
INTO CORRESPONDING FIELDS OF WA_JFDFS
WHERE...

How to access SAP table JFDFS

Within an ECC or HANA version of SAP you can also view further information about JFDFS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!