RFVDZNB1_PLANNED_ITEMS SAP (Structure for List of Planned Records in RFVDZNB1) Structure details
Description: Structure for List of Planned Records in RFVDZNB1
Related tables to RFVDZNB1_PLANNED_ITEMS
Access table RFVDZNB1_PLANNED_ITEMS
Structure field list including key, data, relationships and ABAP select examples
RFVDZNB1_PLANNED_ITEMS 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 List of Planned Records in RFVDZNB1" 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_RFVDZNB1_PLANNED_ITEMS TYPE RFVDZNB1_PLANNED_ITEMS.
The RFVDZNB1_PLANNED_ITEMS table consists of various fields, each holding specific information or linking keys about Structure for List of Planned Records in RFVDZNB1 data available in SAP. These include MANDT (Client), BUKRS (Company Code), RANL (Contract Number), DTRANS (Flow data key: System date).. 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: Not classified
SAP RFVDZNB1_PLANNED_ITEMS 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | DATUM | ||||
TTRANS | Transaction data key: system time | VVTTRANS | TIMS | 6 | UZEIT | ||||
NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | NUMC4 | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
DVORGANG | Activity date | DVORGANG | DATS | 8 | DATUM | ||||
SVORGANG | Business Operation (Activity) | SVORFALL | CHAR | 4 | SVORFALL | ||||
NVORGANG | Activity number | NVORGANG | CHAR | 3 | CHAR3 | ||||
SBEWART | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
SREFBEW | Reference flow type | SREFBEW | CHAR | 4 | Assigned to domain | SBEWART | |||
SBEWZITI | Flow category | SBEWZITI | CHAR | 4 | Assigned to domain | SBEWZITI | |||
SPLANIST | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 1 | SPLANIST | ||||
SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | VVSSOLHAB | ||||
SSTORNO | Reversal indicator | SSTORNO | CHAR | 1 | SSTORNO | ||||
SSTOGRD | Reason for Reversal | SSTOGRD | CHAR | 2 | TZST | SSTOGRD | |||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
RSTBLG | Reverse Document Number | STBLG | CHAR | 10 | ALPHA | BELNR | |||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | Assigned to domain | STATI | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPAB | VVSART | SAN | VVSART_APPL_BAS | |
RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | T037S | USTRU | KRE | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
DORDER | Order day | DORDER | DATS | 8 | DATUM | ||||
NORDER | Order Number | NORDER | NUMC | 8 | NUM8 | ORD | |||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | TCURC | WAERS | |||
BBWHR | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | TCURC | WAERS | |||
BCWHR | Settlement Amount | BCWHR | CURR | 13(2) | WERTV7 | ||||
SCWHR | Settlement Currency | SCWHR | CUKY | 5 | TCURC | WAERS | |||
BHWHR | Amount in local currency | BHWHR | CURR | 13(2) | WERTV7 | ||||
KURS1 | Exchange rate | VVKURSF | DEC | 9(5) | EXCRT | KURSF | |||
KURS2 | Exchange rate | VVKURSF | DEC | 9(5) | EXCRT | KURSF | |||
DVALUT | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
DFAELL | Due date/calculation date | DFAELLIG | DATS | 8 | DATUM | ||||
DDISPO | Payment Date | DDISPO | DATS | 8 | DATUM | ||||
DBESTAND | Position value date | DBESTAND | DATS | 8 | DATUM | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
ATAGE | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | INT6 | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
SSPESEN | Expenses key | SSPESEN | CHAR | 1 | SSPESEN | ||||
RSOLL | Account for debit posting | RSOLL | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
RHABEN | Account for credit posting | RHABEN | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
RZKSOLL | Debit interim account | RZKSOLL | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
RZKHABE | Credit interim account | RZKHABE | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
SBSLSOLL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
SBSLZKSO | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
SBSLZKHA | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
SHSLHABEN | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
RBANKK | Bank account | RBANKK | CHAR | 10 | SKB1 | ALPHA | SAKNR | BKT | |
SFDLEV | Planning level | FDLEV | CHAR | 2 | T036 | FDLEV | FFE | ||
JFDUPD | Record transferred to cash management and forecast | JFDUPD | CHAR | 1 | JANEI | ||||
JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | VVSONLAEN | ||||
JZINSBAS | Flow in interest base | JZINSBAS | CHAR | 1 | JANEI | ||||
JZINSZPT | Interest date | JZINSZPT | CHAR | 1 | JANEI | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
BBASIS | Calculation base amount | BBASIS | CURR | 13(2) | WERTV7 | ||||
SSORTZIT | Sort indicator for interest/repayment schedule calculations | SSORTZIT | CHAR | 1 | CHAR1 | ||||
SWOHER | Source of flow record | SWOHER | CHAR | 1 | CHAR1 | ||||
SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 1 | SSTCKKZ | ||||
SSTCKTG | Accrued interest: Daily method | SSTCKTG | CHAR | 1 | SZBMETH | ||||
PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10(7) | DEC3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
JVERF | Indicator whether drawings exist for the disbursement | JVERF | CHAR | 1 | JVERF | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | T008 | ZAHLS | |||
RPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
SROLEXT | Dummy function | DUMMY_3 | CHAR | 3 | CHAR3 | ||||
RKLAMMER | Classification Number for Finance Projects | RKLAMMER | CHAR | 13 | ALPHA | RANL | |||
JEINBEHALT | Indicator for withholding of amount during disbursement | VVJEINBE | CHAR | 1 | KENZX | ||||
SZEGEN | Generate incoming payment immediately | SZEGEN | NUMC | 2 | Assigned to domain | SZEGEN | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
DTRANSREF | Flow data key: System date | VVDTRANS | DATS | 8 | DATUM | ||||
TTRANSREF | Transaction data key: system time | VVTTRANS | TIMS | 6 | UZEIT | ||||
NTRANSREF | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | NUMC4 | ||||
RPNNR | Daybook no. | VVRPNNR | CHAR | 10 | VVRPNNR | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
SBUST | Posting control key | VVSBUST | NUMC | 2 | TZB09 | VVSBUST | |||
PWKURS | Security price for percentage quotation | PWKURS | DEC | 10(7) | PWKURS | ||||
DSTOCK | Premium reserve fund date | VVDSTOCK | DATS | 8 | DATUM | ||||
JVORAUS | ID for planned record reference to an advance payment | VVJVORAUS | CHAR | 1 | KENZX | ||||
AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | NUMC03 | ||||
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | TZK01 | SKOART | |||
SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | VVSEXCLVON | ||||
SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | VVSULT | ||||
SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | VVSINCLBIS | ||||
SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | VVSULT | ||||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | DATUM | ||||
DPKOND | Determination date for percentage rate of condition items | VVDPKOND | DATS | 8 | DATUM | ||||
RUMBLG | Reference transfer document number | UMBLG | CHAR | 10 | ALPHA | BELNR | |||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | VVSULT | ||||
JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | VVSINCLVER | ||||
SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | VVSULT | ||||
SREFZITI | Refer.flow category in accrual/deferral flow records | VVSREFZITI | CHAR | 4 | Assigned to domain | SBEWZITI | |||
STGBASIS | Base Days Method | VVSTGBASIS | NUMC | 1 | VVSTGBASIS | ||||
STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | VVSTGMETH | ||||
SBASIS | Calculation base reference | VVSBASIS | CHAR | 4 | TZFB | VVSBASIS | |||
SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | CHAR | 4 | AT40 | SBEWFIMA | |||
SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 2 | VVSVORGKZ | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM | ||||
NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | NUMC2 | ||||
DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | DATUM | ||||
SPAEXCL | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | NUMC | 1 | TFMSPAEXCL | ||||
SPAULT | Month-End Indicator for Start Date of a Period | TFMSPAULT | CHAR | 1 | VVSULT | ||||
DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | DATUM | ||||
SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | TFMSPEINCL | ||||
SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | VVSULT | ||||
RKONT | Quota number | RKONT | NUMC | 6 | RKONT | RKT | |||
DAUSZ | Lead date for withholding amounts for disbursement | VVDAUSZ | DATS | 8 | DATUM | ||||
SSOLIST | Calculation using actual principle (or debit) | SSOLIST | CHAR | 1 | CHAR1 | ||||
RDARNEHM | Borrower/Applicant Number | RDARNEHM_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BKOND | Condition item currency amount | BKOND | CURR | 13(2) | WERTV7 | ||||
RZEBEL | Document number of waiver/write-off document | VEBLGNR | CHAR | 10 | ALPHA | BELNR | |||
ZFBDT | Payment Date | DDISPO | DATS | 8 | DATUM | ||||
DZFEST | Interest rate fixing date | TB_DZFEST | DATS | 8 | DATUM | ||||
SBERECH | Grace Period Interest Method | SBERECH | CHAR | 1 | XFELD | ||||
BKARZINS | Int.for days betw. redemption clear.and pmnt (FiMa-internal) | TFMBKAZINS | CURR | 13(2) | TFM_WRTV7 | ||||
BTITALK | Imputed annuity repayment amount (FiMa internal) | TFMBTIKALK | CURR | 13(2) | TFM_WRTV7 | ||||
HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
RUZBEL | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
S_SSDREF | Reference flow category in borrower's note loan flow records | VVS_SSDREF | CHAR | 4 | Assigned to domain | SBEWZITI | |||
SAEND | Change Indicator for FiMa Flow Records | TFM_SAEND | NUMC | 1 | TFM_SAEND | ||||
XPORE | Indicator: Individual Payment? | PRQ_XPORE | CHAR | 1 | XFELD | ||||
SPAYRQ | Generate payment request | TB_SPAYRQK | CHAR | 1 | XFELD | ||||
PRKEY | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | Assigned to domain | ALPHA | PRQ_KEYNO | ||
HKTID | ID for account details | HKTID | CHAR | 5 | T012K | HKTID | |||
VORGTYP | Activity Category (Posting Area) | VORGTYP_LO | CHAR | 4 | VORGTYP_LO | ||||
ACENV | Source in TR-LO posting area | ACENV_LO | NUMC | 4 | ACENV_LO | ||||
SSIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
SPRSNG | Individual payment | TB_SPRSNGK | CHAR | 1 | XFELD | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
SPRGRD | Determine grouping definition | TB_SPRGRD | CHAR | 1 | T_SPRGRD | ||||
SCSPAY | Same direction necessary for joint payment? | TB_SCSPAY | CHAR | 1 | XFELD | ||||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
PAYGR | Grouping Field for Automatic Payments | PAYGR | CHAR | 20 | CHAR20 | ||||
JEXPOZINS | Exponential Interest Calculation | TB_JZINSRE | CHAR | 1 | XFELD | ||||
SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | VVSREVALEXCL | CHAR | 1 | XFELD | ||||
RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SROUND | Rounding Category | TFM_SROUND | CHAR | 1 | TFM_SROUND | ||||
SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11(7) | TFM_PPAYMENT | ||||
AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | TFM_AMMRHYZV | ||||
LC_CAPITALS | Effect of the Flow on Capital Amounts Status | TB_LC_CAPITALS | CHAR | 2 | T_LC_CASH_FLOW | ||||
LC_DISBURSE | Effect of the Flow on the Disbursement Status | TB_LC_DISBURSE | CHAR | 2 | T_LC_CASH_FLOW | ||||
OP_APPLICATION | Open Item Tool: Application Key | TB_OPAPPL | NUMC | 2 | Assigned to domain | T_OPAPPL | FVD_H_TDOPAPPL | ||
OP_RBO | OI Tool: Locking Business Operation | TB_OP_RBO | CHAR | 15 | RBO | ||||
DFAELL_OLD_EXT | Old Due Date | TB_EXTENS_DFAELL_OLD | DATS | 8 | DATUM | ||||
DDISPO_OLD_EXT | Old Payment Date | TB_EXTENS_DDISPO_OLD | DATS | 8 | DATUM | ||||
RBO_EXT | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SBEWEGRP2 | Flow Record Group in Cash Flow Calculator (Incoming Payment) | TB_FLOW_REC_GRP | NUMC | 6 | SBEWEGRP2 | ||||
SUSP_REASON_TYPE | Key for Overpayment Reason | TB_SUSPREASON | NUMC | 3 | TDSUSPREASON | T_SUSPREASON | |||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
REMIT_INFO | Payment Notes Info | TB_REMIT_INFO | CHAR | 140 | T_REMIT_INFO | ||||
.INCLU--AP | 0 | ||||||||
BROUNDUNIT | Rounding Unit for Amounts | TB_BROUNDUNIT_A | DEC | 13(7) | TFMSRUNIT | ||||
.INCLU--AP | 0 | ||||||||
SEPA_PD | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
XBEWART | Name of flow type | XBEWART | CHAR | 30 | TEXT30 |
Key field | Non-key field |
How do I retrieve data from SAP structure RFVDZNB1_PLANNED_ITEMS using ABAP code?
As RFVDZNB1_PLANNED_ITEMS 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 RFVDZNB1_PLANNED_ITEMS as there is no data to select.How to access SAP table RFVDZNB1_PLANNED_ITEMS
Within an ECC or HANA version of SAP you can also view further information about RFVDZNB1_PLANNED_ITEMS 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