JFDFS SAP (IS-M/SD: Billing/Settlement Index) Table details
Dictionary Type: Table
Description: IS-M/SD: Billing/Settlement Index
Description: IS-M/SD: Billing/Settlement Index
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
OBJART_V | IS-M: Previous object type | OBJART_V | CHAR | 4 | JOBJART | ||||
OBJID_V | IS-M: Previous object ID | OBJID_V | CHAR | 50 | JOBJID | ||||
OBJART_N | IS-M: Subsequent Object Type | OBJART_N | CHAR | 4 | JOBJART | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
FKDAT | IS-M: Billing/Settlement Date | JFKDAT | DATS | 8 | DATUM | ||||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
FKART | IS-M: Billing/Settlement Type | JFKART | CHAR | 4 | TJFK | JFKART | |||
VBELN | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | JKAK | ALPHA | AVNR | JK1 | MJK1 |
POSNR | Sales Order Item | APNR | NUMC | 6 | JKAP | APNR | |||
FAKVON | IS-M: Billing Period From | FAKVON | DATS | 8 | DATUM | ||||
FAKBIS | IS-M: Billing Period To | FAKBIS | DATS | 8 | DATUM | ||||
JPERIOD | IS-M: Periodic settlement | JPERIOD | CHAR | 1 | XFELD | ||||
NAMEK | IS-M: Abbreviated form of name for selection | NAMEK | CHAR | 10 | CHAR10 | ||||
GPNR | IS-M: Business Partner Key | GPNR | CHAR | 10 | JGTGPNR | ALPHA | GPNR | JGP | MJG0 |
VERSERVGES | IS-M: Service Company | VERSERVGES | CHAR | 10 | JGTVSG | ALPHA | GPNR | JGF | MJG0G |
LLAND | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
JZAHLW | Billing method | JZAHLW | CHAR | 1 | JZAHLW | JKZAHLW | |||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
BANKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
XEZER | Indicator: Is there collection authorization ? | XEZER | CHAR | 1 | XFELD | ||||
JSNABR | IS-M: Number of Reversal in Subsequent Document | JSNABR | CHAR | 10 | Assigned to domain | ALPHA | JVBELN | ||
POSEX | External Item Number (Purchase Order Item) | POSEX_ISP | NUMC | 6 | POSEX_ISP | JK2 | |||
XEINMAL | Indicator: One-time commission | XEINMALPRV | CHAR | 1 | XFELD | ||||
XRENDITE | Renewal commission | XRENDITE | CHAR | 1 | XFELD | ||||
XFBLGABR | IS-M: Follow-on settlement documents | XFBLGABR | CHAR | 1 | XFELD | ||||
GPNR_RG | IS-M: Payer Business Partner | GPNR_RG | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
GPNR_RE | IS-M: Business Partner - Bill-To Party | GPNR_RE | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
SHKZG | IS-M: Debit indicator for schedule line | SHKZG_ISP | CHAR | 1 | XFELD | ||||
PRSANTZ | IS-M: Numerator for proportional prices | PRSANTZ | DEC | 8 | ISPWERT8 | ||||
PRSANTN | IS-M: Denominator for proportional prices | PRSANTN | DEC | 8 | ISPWERT8 | ||||
PRSANZP | IS-M: Number of periods in billing period | PRSANZP | DEC | 8 | ISPWERT8 | ||||
BDPER | IS-M: Basic Date for Billing Frequency | BDPER | DATS | 8 | DATUM | ||||
ISPXKOMPP | IS-M: Full period (billing) | XKOMPP | CHAR | 1 | XFELD | ||||
XFSPERR | IS-M: Billing block deactivated | XFSPERR | CHAR | 1 | XFELD | ||||
BEZIRK | Carrier Route | BEZIRK | CHAR | 10 | JVTBEZIRK | ALPHA | BEZIRK | BEZ | MJVC |
BEZRUNDE | IS-M: Delivery Round | BEZRUNDE | CHAR | 10 | JVTBEZRND | ALPHA | BEZRUNDE | JBR | |
XINDART | IS-M: Index type | XINDART | CHAR | 1 | XFELD | ||||
XPROVRUECK | Indicator: Commission recalculation for order item | XPROVRUECK | CHAR | 1 | XFELD | ||||
ANZMONABRE | IS-M: No.Months for Sett./Retroactive Acctg - One-Time Comm. | ANZMONABRE | QUAN | 2 | ISPMNG2 | ||||
MINDBEZEIN | Time Unit for Minimum Length of Subscription | MINDBEZEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
XFKRUECK | IS-M: Retroactive Billing of Period Already Billed | XFKRUECK | CHAR | 1 | XFELD | ||||
JKPAVONREG | Normal Start of Address Validity for Retro.Order Items | JKPAVONREG | DATS | 8 | DATUM | ||||
DRERZ | Publication | DRERZ | CHAR | 8 | JDTDRER | ALPHA | DRERZ | JD1 | MJD1 |
FKPER | Billing Frequency | FKPER | CHAR | 2 | TJK01 | FKPER | JFKPER | ||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
FKPERVON | IS-M: Initial Date of Full Billing Period | FKPERVON | DATS | 8 | DATUM | ||||
FKPERBIS | IS-M: Closing Date of Full Billing Period | FKPERBIS | DATS | 8 | DATUM | ||||
CYCLENR | IS-M/SD: Billing Cycle Number | CYCLENR | NUMC | 3 | Assigned to domain | CYCLENR | |||
FAKNRRUECK | IS-M: Recalculated Billing Document | ISPFAKNRRUECK | CHAR | 10 | Assigned to domain | ALPHA | ISPVBELN | VF | |
XFIXED | Indicator: Billing Index Fixed and Cannot be Deleted | XINDEXFIXED | CHAR | 1 | XFELD | ||||
JKPABISREG | End of Address Validity if End of Billing Delayed | JKPABISREG | DATS | 8 | DATUM | ||||
POSNR_UR | Original Item in Publishing Sales Order | APNR_UR | NUMC | 6 | JKAP | APNR | |||
PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | TFACD | WFCID | |||
POSPONE | IS-M/SD: Reason for moving billing | JINVOICE_POSPONE | CHAR | 1 | JINVOICE_POSPONE | ||||
XTRANSFER | IS-M/SD: Transfer billing document | XTRANSFER_INV | CHAR | 1 | XFELD | ||||
DELIVSPLIT | IS-M/SD: Alternating Address Element | DELIVSPLIT | CHAR | 8 | Assigned to domain | ALPHA | DELIVSPLIT | ||
VBELN_FROM | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | Assigned to domain | ALPHA | AVNR | JK1 | MJK1 |
POSNR_UR_FROM | Sales Order Item | APNR | NUMC | 6 | Assigned to domain | APNR | |||
CYCLENR_FROM | IS-M/SD: Billing Cycle Number | CYCLENR | NUMC | 3 | Assigned to domain | CYCLENR | |||
XPRICEALTER | Indicator: Generated Index for Price Change | XPRICEALTERNATION | CHAR | 1 | XFELD | ||||
REFUNDTYPE | IS-M/SD: Refund Type | REFUNDTYPE | CHAR | 2 | TJK19 | REFUNDTYPE | |||
XAUTO_ACCEPT | IS-M/SD: Indicator - Accept Cycle Without Payment | XAUTO_ACCEPT | CHAR | 1 | XFELD |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects