FVD_CHK_SEPA_DD_RECORDS SAP (Structure for analysis of planned records (SEPA DD)) Structure details

Dictionary Type: Structure
Description: Structure for analysis of planned records (SEPA DD)




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




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

FVD_CHK_SEPA_DD_RECORDS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for analysis of planned records (SEPA DD)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FVD_CHK_SEPA_DD_RECORDS TYPE FVD_CHK_SEPA_DD_RECORDS.

The FVD_CHK_SEPA_DD_RECORDS table consists of various fields, each holding specific information or linking keys about Structure for analysis of planned records (SEPA DD) data available in SAP. These include BUKRS (Company Code), RANL (Contract Number), DTRANS (Flow data key: System date), TTRANS (Transaction data key: system time).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP FVD_CHK_SEPA_DD_RECORDS structure 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 MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RANLContract Number RANLCHAR13ALPHARANLRAN
DTRANSFlow data key: System date VVDTRANSDATS8DATUM
TTRANSTransaction data key: system time VVTTRANSTIMS6UZEIT
NTRANSTransaction data key: Consecutive number VVNTRANSNUMC4NUMC4
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
DVORGANGActivity date DVORGANGDATS8DATUM
SVORGANGBusiness Operation (Activity) SVORFALLCHAR4SVORFALL
NVORGANGActivity number NVORGANGCHAR3CHAR3
SBEWARTFlow Type SBEWARTCHAR4Assigned to domainSBEWART
SREFBEWReference flow type SREFBEWCHAR4Assigned to domainSBEWART
SBEWZITIFlow category SBEWZITICHAR4Assigned to domainSBEWZITI
SPLANISTPlan/actual record/record to be released indicator SPLANISTCHAR1SPLANIST
SSOLHABDebit/credit indicator VVSSOLHABCHAR1VVSSOLHAB
SSTORNOReversal indicator SSTORNOCHAR1SSTORNO
SSTOGRDReason for Reversal SSTOGRDCHAR2Assigned to domainSSTOGRD
ZUONRAssignment Number DZUONRCHAR18ZUONR
RSTBLGReverse Document Number STBLGCHAR10ALPHABELNR
SGTXTItem Text SGTXTCHAR50TEXT50
SANLFProduct Category SANLFNUMC3Assigned to domainVVSANLF
DGUEL_KKDate Condition Effective from DGUELDATS8DATUM
NLFD_ANGOffer consecutive number NLFD_ANGNUMC3LFNR3
SSTATIStatus of data record SSTATINUMC2Assigned to domainSTATI
GSARTProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
RREFKONTAccount Assignment Reference in Financial Assets Management RREFKONTCHAR8Assigned to domainUSTRUKRE
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
DORDEROrder day DORDERDATS8DATUM
NORDEROrder Number NORDERNUMC8NUM8ORD
BNWHRNominal amount BNWHRCURR13(2) WERTV7
SNWHRCurrency of nominal amount SNWHRCUKY5Assigned to domainWAERS
BBWHRAmount in position currency BBWHRCURR13(2) WERTV7
SBWHRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
BCWHRSettlement Amount BCWHRCURR13(2) WERTV7
SCWHRSettlement Currency SCWHRCUKY5Assigned to domainWAERS
BHWHRAmount in local currency BHWHRCURR13(2) WERTV7
KURS1Exchange rate VVKURSFDEC9(5) EXCRTKURSF
KURS2Exchange rate VVKURSFDEC9(5) EXCRTKURSF
DVALUTCalculation Date DVALUTDATS8DATUM
DFAELLDue date/calculation date DFAELLIGDATS8DATUM
DDISPOPayment Date DDISPODATS8DATUM
DBESTANDPosition value date DBESTANDDATS8DATUM
DBERVONStart of Calculation Period DBERVONDATS8DATUM
DBERBISEnd of Calculation Period DBERBISDATS8DATUM
ATAGENumber of days VVATAGENUMC6INT6
ABASTAGENumber of base days in a calculation period ABASTAGENUMC6INT6
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
SSPESENExpenses key SSPESENCHAR1SSPESEN
RSOLLAccount for debit posting RSOLLCHAR10Assigned to domainALPHASAKNR
RHABENAccount for credit posting RHABENCHAR10Assigned to domainALPHASAKNR
RZKSOLLDebit interim account RZKSOLLCHAR10Assigned to domainALPHASAKNR
RZKHABECredit interim account RZKHABECHAR10Assigned to domainALPHASAKNR
SBSLSOLLPosting Key BSCHLCHAR2Assigned to domainBSCHL
SBSLZKSOPosting Key BSCHLCHAR2Assigned to domainBSCHL
SBSLZKHAPosting Key BSCHLCHAR2Assigned to domainBSCHL
SHSLHABENPosting Key BSCHLCHAR2Assigned to domainBSCHL
RBANKKBank account RBANKKCHAR10Assigned to domainALPHASAKNRBKT
SFDLEVPlanning level FDLEVCHAR2Assigned to domainFDLEVFFE
JFDUPDRecord transferred to cash management and forecast JFDUPDCHAR1JANEI
JONLAENIndicator for fixing a flow record JONLAENCHAR1VVSONLAEN
JZINSBASFlow in interest base JZINSBASCHAR1JANEI
JZINSZPTInterest date JZINSZPTCHAR1JANEI
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
BBASISCalculation base amount BBASISCURR13(2) WERTV7
SSORTZITSort indicator for interest/repayment schedule calculations SSORTZITCHAR1CHAR1
SWOHERSource of flow record SWOHERCHAR1CHAR1
SSTCKKZAccrued interest method SSTCKKZCHAR1SSTCKKZ
SSTCKTGAccrued interest: Daily method SSTCKTGCHAR1SZBMETH
PEFFZINSEffective Interest Rate PEFFZINSDEC10(7) DEC3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
JVERFIndicator whether drawings exist for the disbursement JVERFCHAR1JVERF
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
MABERDunning Area MABERCHAR2Assigned to domainMABER
ZAHLSBlock Key for Payment DZAHLSCHAR1Assigned to domainZAHLS
RPARTNRBusiness Partner Number BP_PARTNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SROLEXTDummy function DUMMY_3CHAR3CHAR3
RKLAMMERClassification Number for Finance Projects RKLAMMERCHAR13ALPHARANL
JEINBEHALTIndicator for withholding of amount during disbursement VVJEINBECHAR1KENZX
SZEGENGenerate incoming payment immediately SZEGENNUMC2Assigned to domainSZEGEN
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
DTRANSREFFlow data key: System date VVDTRANSDATS8DATUM
TTRANSREFTransaction data key: system time VVTTRANSTIMS6UZEIT
NTRANSREFTransaction data key: Consecutive number VVNTRANSNUMC4NUMC4
RPNNRDaybook no. VVRPNNRCHAR10VVRPNNR
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
SBUSTPosting control key VVSBUSTNUMC2VVSBUST
PWKURSSecurity price for percentage quotation PWKURSDEC10(7) PWKURS
DSTOCKPremium reserve fund date VVDSTOCKDATS8DATUM
JVORAUSID for planned record reference to an advance payment VVJVORAUSCHAR1KENZX
AMMRHYFrequency in months AMMRHYNUMC3NUMC03
SKOARTCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4Assigned to domainSKOART
SEXCLVONExclusive Indicator for the Start of a Calculation Period VVSEXCLVONNUMC1VVSEXCLVON
SULTVONMonth-End Indicator for Start of a Calculation Period VVSULTVONCHAR1VVSULT
SINCLBISInclusive Indicator for the End of a Calculation Period VVSINCLBISNUMC1VVSINCLBIS
SULTBISMonth-End Indicator for the End of a Calculation Period VVSULTBISCHAR1VVSULT
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
DVERRECHSettlement date VVDVERRECHDATS8DATUM
DPKONDDetermination date for percentage rate of condition items VVDPKONDDATS8DATUM
RUMBLGReference transfer document number UMBLGCHAR10ALPHABELNR
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ
SVULTMonth-End Indicator for Value Date VVSVULTCHAR1VVSULT
JSOFVERRImmediate settlement JSOFVERRCHAR1TFMSOFVERR
SINCLVERRInclusive Indicator for Clearing Date VVSINCLVERNUMC1VVSINCLVER
SULTVERRMonth-End Indicator for Clearing Date VVSULTVERRCHAR1VVSULT
SREFZITIRefer.flow category in accrual/deferral flow records VVSREFZITICHAR4Assigned to domainSBEWZITI
STGBASISBase Days Method VVSTGBASISNUMC1VVSTGBASIS
STGMETHDaily Method VVSTGMETHNUMC1VVSTGMETH
SBASISCalculation base reference VVSBASISCHAR4Assigned to domainVVSBASIS
SBERFIMACalculation category for cash flow calculator SBEWFIMACHAR4Assigned to domainSBEWFIMA
SVORGKZActivity indicator for debit/credit control VVSVORGKZNUMC2VVSVORGKZ
MANSPDunning block MANSPCHAR1Assigned to domainMANSP
DGUEL_KPCondition Item Valid From DGUEL_KPDATS8DATUM
NSTUFELevel number of condition item for recurring payments NSTUFENUMC2NUMC2
DBPERIODPeriod start VVDBPERIODDATS8DATUM
SPAEXCLExclusive Indicator for Start Date of a Period TFMSPAEXCLNUMC1TFMSPAEXCL
SPAULTMonth-End Indicator for Start Date of a Period TFMSPAULTCHAR1VVSULT
DEPERIODPeriod End VVDEPERIODDATS8DATUM
SPEINCLInclusive Indicator for End Date of a Period TFMSPEINCLNUMC1TFMSPEINCL
SPEULTMonth-End Indicator for End of a Period TFMSPEULTCHAR1VVSULT
RKONTQuota number RKONTNUMC6RKONTRKT
DAUSZLead date for withholding amounts for disbursement VVDAUSZDATS8DATUM
SSOLISTCalculation using actual principle (or debit) SSOLISTCHAR1CHAR1
RDARNEHMBorrower/Applicant Number RDARNEHM_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
BKONDCondition item currency amount BKONDCURR13(2) WERTV7
RZEBELDocument number of waiver/write-off document VEBLGNRCHAR10ALPHABELNR
ZFBDTPayment Date DDISPODATS8DATUM
DZFESTInterest rate fixing date TB_DZFESTDATS8DATUM
SBERECHGrace Period Interest Method SBERECHCHAR1XFELD
BKARZINSInt.for days betw. redemption clear.and pmnt (FiMa-internal) TFMBKAZINSCURR13(2) TFM_WRTV7
BTITALKImputed annuity repayment amount (FiMa internal) TFMBTIKALKCURR13(2) TFM_WRTV7
HDN_KUNNRMain Borrower Customer Number HDN_KUNNRCHAR10Assigned to domainALPHAKUNNR
SZARTPayment transaction TB_SZARTCHAR1XFELD
RUZBELAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
S_SSDREFReference flow category in borrower's note loan flow records VVS_SSDREFCHAR4Assigned to domainSBEWZITI
SAENDChange Indicator for FiMa Flow Records TFM_SAENDNUMC1TFM_SAEND
XPOREIndicator: Individual Payment? PRQ_XPORECHAR1XFELD
SPAYRQGenerate payment request TB_SPAYRQKCHAR1XFELD
PRKEYKey Number for Payment Request PRQ_KEYNOCHAR10Assigned to domainALPHAPRQ_KEYNO
HKTIDID for account details HKTIDCHAR5Assigned to domainHKTID
VORGTYPActivity Category (Posting Area) VORGTYP_LOCHAR4VORGTYP_LO
ACENVSource in TR-LO posting area ACENV_LONUMC4ACENV_LO
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
SPRSNGIndividual payment TB_SPRSNGKCHAR1XFELD
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
SPRGRDDetermine grouping definition TB_SPRGRDCHAR1T_SPRGRD
SCSPAYSame direction necessary for joint payment? TB_SCSPAYCHAR1XFELD
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
PAYGRGrouping Field for Automatic Payments PAYGRCHAR20CHAR20
JEXPOZINSExponential Interest Calculation TB_JZINSRECHAR1XFELD
SREVALEXCLPrice gains w/o proportionate gains from deferral write-back VVSREVALEXCLCHAR1XFELD
RBOBusiness Operation Number (Loans) RBOCHAR15RBO
SROUNDRounding Category TFM_SROUNDCHAR1TFM_SROUND
SKALIDWTInterest Calendar TFMSKALIDWTCHAR2Assigned to domainWFCIDH_TFACD
PPAYMENTPayment Rate TFM_PPAYMENTDEC11(7) TFM_PPAYMENT
AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc. TFM_AMMRHYZVNUMC2TFM_AMMRHYZV
LC_CAPITALSEffect of the Flow on Capital Amounts Status TB_LC_CAPITALSCHAR2T_LC_CASH_FLOW
LC_DISBURSEEffect of the Flow on the Disbursement Status TB_LC_DISBURSECHAR2T_LC_CASH_FLOW
OP_APPLICATIONOpen Item Tool: Application Key TB_OPAPPLNUMC2Assigned to domainT_OPAPPLFVD_H_TDOPAPPL
OP_RBOOI Tool: Locking Business Operation TB_OP_RBOCHAR15RBO
DFAELL_OLD_EXTOld Due Date TB_EXTENS_DFAELL_OLDDATS8DATUM
DDISPO_OLD_EXTOld Payment Date TB_EXTENS_DDISPO_OLDDATS8DATUM
RBO_EXTBusiness Operation Number (Loans) RBOCHAR15RBO
SBEWEGRP2Flow Record Group in Cash Flow Calculator (Incoming Payment) TB_FLOW_REC_GRPNUMC6SBEWEGRP2
SUSP_REASON_TYPEKey for Overpayment Reason TB_SUSPREASONNUMC3TDSUSPREASONT_SUSPREASON
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
REMIT_INFOPayment Notes Info TB_REMIT_INFOCHAR140T_REMIT_INFO
.INCLU--AP 0
BROUNDUNITRounding Unit for Amounts TB_BROUNDUNIT_ADEC13(7) TFMSRUNIT
.INCLU--AP 0
SEPA_PDPosting Date in the Document BUDATDATS8DATUM
B2BSEPA-Mandate: B2B Mandate SEPA_B2BCHAR1XFELD
MND_USAGEMandate Usage TB_SEPA_MND_USAGEINT13TB_SEPA_DOM_MND_USAGE
FLG_FULDISBIndicator: Contract Fully Disbursed? TB_SEPA_FLG_DISBCHAR1BOOLEAN
SND_COUNTRYSEPA DD: Sender Country TB_SEPA_SND_COUNTRYCHAR2INTCA
SND_BICSEPA DD: Sender BIC Code TB_SEPA_SND_BICCHAR11SWIFT
REC_COUNTRYSEPA DD: Recipient Country TB_SEPA_REC_COUNTRYCHAR2INTCA
REC_BICSEPA DD: Receiver BIC Code TB_SEPA_REC_BICCHAR11SWIFT
LEADTIMESEPA DD Lead time TB_SEPA_DD_LEADTIMENUMC2
CALENDARFactory calendar SKALIDCHAR2Assigned to domainWFCIDH_TFACD
SEPA_LEAD_DATELead Date (Payment Date minus Lead Time) TB_SEPA_LEAD_DATEDATS8DATUM
SEPA_ERROR_CODESEPA DD Error Code (Loans Management) TB_SEPA_ERROR_CODEINT410
SEPA_ERROR_MESSAGESEPA (Error-)Message (Text) TB_SEPA_MESSAGESTRG0
SEPA_BADI_CHANGELeadtime changed with BADi TB_SEPA_BADI_CHANGECHAR1FLAG
SEPA_INDEXLoop Index SYINDEXINT410SYST_LONG
SIGNPlus/Minus Sign TB_SIGNCHAR1TB_SIGN_DOM
I_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
I_B2BSEPA-Mandate: B2B Mandate SEPA_B2BCHAR1XFELD
I_SEQ_TYPESEPA: Sequence Type SEPA_SEQ_TYPECHAR4SEPA_SEQ_TYPE
I_UBNKSBank country key BANKSCHAR3Assigned to domainLAND1BKL
I_UBNKYBank key of our bank UBNKYCHAR15BANKK
I_ZBNKSCountry Key of Bank of Payer FSEPA_ZBNKSCHAR3Assigned to domainLAND1
I_ZBNKYBank Key of Bank of Payer FSEPA_ZBNKYCHAR15BANKK
I_ZIBANIBAN (International Bank Account Number) IBANCHAR34IBAN
DEFAULTData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE

Key field Non-key field



How do I retrieve data from SAP structure FVD_CHK_SEPA_DD_RECORDS using ABAP code?

As FVD_CHK_SEPA_DD_RECORDS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FVD_CHK_SEPA_DD_RECORDS as there is no data to select.

How to access SAP table FVD_CHK_SEPA_DD_RECORDS

Within an ECC or HANA version of SAP you can also view further information about FVD_CHK_SEPA_DD_RECORDS 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!