VDBEPP
Flow Data - Planned Item
VDBEPP is an SAP database table in S/4HANA. Flow Data - Planned Item. It contains 209 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_LoanContrPlndItm | view | from | BASIC | Planned Items for Loan Contract |
| I_LoanContrPlndItmData | view | from | BASIC | Planned Items for Loan Contract |
Fields (209)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | ranl | RANL | Contract Number | |||
| KEY | dtrans | VVDTRANS | Flow date | |||
| KEY | ttrans | VVTTRANS | Time trans. | |||
| KEY | ntrans | VVNTRANS | Consec.tr. | |||
| rerf | RERF | Entered By | ||||
| derf | DERF | First Enterd On | ||||
| terf | TERF | Time | ||||
| reher | REHER | Source.In.Entry | ||||
| rbear | RBEAR | Last Changed By | ||||
| dbear | DBEAR | Last Edited On | ||||
| tbear | TBEAR | Last Edited At | ||||
| rbher | RBHER | Editing Source | ||||
| dvorgang | DVORGANG | Activity date | ||||
| svorgang | SVORFALL | Activity | ||||
| nvorgang | NVORGANG | Activity no. | ||||
| sbewart | SBEWART | Flow Type | ||||
| srefbew | SREFBEW | Refer.flow | ||||
| sbewziti | SBEWZITI | Flow Category | ||||
| splanist | SPLANIST | Plan/Actual | ||||
| ssolhab | VVSSOLHAB | Debit/Credit | ||||
| sstorno | SSTORNO | Reverse indic. | ||||
| sstogrd | SSTOGRD | Reversal Reason | ||||
| zuonr | DZUONR | Assignment | ||||
| rstblg | STBLG | Reversed With | ||||
| sgtxt | SGTXT | Text | ||||
| sanlf | SANLF | Prod. Category | ||||
| dguel_kk | DGUEL | Cond. Eff. from | ||||
| nlfd_ang | NLFD_ANG | Off.consec.no. | ||||
| sstati | SSTATI | Status | ||||
| gsart | VVSART | Product Type | ||||
| rrefkont | RREFKONT | Acct Assign.Ref | ||||
| gsber | GSBER | Business Area | ||||
| dorder | DORDER | Order date | ||||
| norder | NORDER | Order Number | ||||
| bnwhr | BNWHR | Nominal amnt | ||||
| snwhr | SNWHR | Nominal currency | ||||
| bbwhr | BBWHR | Amount in PC | ||||
| sbwhr | SBWHR | Position Currency | ||||
| bcwhr | BCWHR | Settlement Amount | ||||
| scwhr | SCWHR | Settlement Currency | ||||
| bhwhr | BHWHR | Amount in LC | ||||
| kurs1 | VVKURSF | Exchange rate | ||||
| kurs2 | VVKURSF | Exchange rate | ||||
| dvalut | DVALUT | Calculat. date | ||||
| dfaell | DFAELLIG | Due on | ||||
| ddispo | DDISPO | Payment date | ||||
| dbestand | DBESTAND | Position Value Date | ||||
| dbervon | DBERVON | CalculationFrom | ||||
| dberbis | DBERBIS | Calculation To | ||||
| atage | VVATAGE | Number of Days | ||||
| abastage | ABASTAGE | No. base days | ||||
| szbmeth | SZBMETH | Int.calc.method | ||||
| umskz | UMSKZ | Special G/L Ind | ||||
| kostl | KOSTL | Cost Center | ||||
| sspesen | SSPESEN | Expen.key | ||||
| rsoll | RSOLL | Debit account | ||||
| rhaben | RHABEN | Credit a/c | ||||
| rzksoll | RZKSOLL | Debit.inter.act | ||||
| rzkhabe | RZKHABE | Cred.inter.acct | ||||
| sbslsoll | BSCHL | Posting Key | ||||
| sbslzkso | BSCHL | Posting Key | ||||
| sbslzkha | BSCHL | Posting Key | ||||
| shslhaben | BSCHL | Posting Key | ||||
| rbankk | RBANKK | Int. bank acct | ||||
| sfdlev | FDLEV | Planning Level | ||||
| jfdupd | JFDUPD | CMF flag | ||||
| jonlaen | JONLAEN | Flow fixing | ||||
| jzinsbas | JZINSBAS | Interest base | ||||
| jzinszpt | JZINSZPT | Interest date | ||||
| pkond | PKOND | Percentage Rate | ||||
| bbasis | BBASIS | Base Amount | ||||
| ssortzit | SSORTZIT | Sort indicator | ||||
| swoher | SWOHER | Source of flow | ||||
| sstckkz | SSTCKKZ | Acc.int.meth. | ||||
| sstcktg | SSTCKTG | Daily Method | ||||
| peffzins | PEFFZINS | Effect.int.rate | ||||
| seffmeth | SEFFMETH | Eff.Int. Method | ||||
| jverf | JVERF | Drawings | ||||
| kunnr | KUNNR | Customer | ||||
| bvtyp | BVTYP | Part.bank type | ||||
| zlsch | DZLSCH | Pymt Meth. | ||||
| maber | MABER | Dunning Area | ||||
| zahls | DZAHLS | Payment Block | ||||
| rpartnr | BP_PARTNR_NEW | BusPartner | ||||
| srolext | DUMMY_3 | Dummy | ||||
| rklammer | RKLAMMER | Finance Project | ||||
| jeinbehalt | VVJEINBE | Withhold. disb. | ||||
| szegen | SZEGEN | Incoming Payt | ||||
| mwskz | MWSKZ | Tax Code | ||||
| dtransref | VVDTRANS | Flow date | ||||
| ttransref | VVTTRANS | Time trans. | ||||
| ntransref | VVNTRANS | Consec.tr. | ||||
| rpnnr | VVRPNNR | Daybook no. | ||||
| hbkid | HBKID | House Bank | ||||
| sbust | VVSBUST | Posting Control | ||||
| pwkurs | PWKURS | Security price | ||||
| dstock | VVDSTOCK | PRF entry date | ||||
| jvoraus | VVJVORAUS | Adv.pmnt ID | ||||
| ammrhy | AMMRHY | Freq. in months | ||||
| skoart | SKOART | Condition Type | ||||
| sexclvon | VVSEXCLVON | Exclusive Start | ||||
| sultvon | VVSULTVON | Mth-End StartDt | ||||
| sinclbis | VVSINCLBIS | Incl. End Date | ||||
| sultbis | VVSULTBIS | Month-End EndDt | ||||
| sincl | VVSINCL | Inclusive Ind. | ||||
| dverrech | VVDVERRECH | Settlem. date | ||||
| dpkond | VVDPKOND | Perc Fixing Dte | ||||
| rumblg | UMBLG | RefTrnDoc. | ||||
| zinkz | DZINKZ | Interest Block | ||||
| svult | VVSVULT | Mon-End Val.Dte | ||||
| jsofverr | JSOFVERR | Immed.settlemnt | ||||
| sinclverr | VVSINCLVER | Incl. Clrg Date | ||||
| sultverr | VVSULTVERR | MnthEndClearing | ||||
| srefziti | VVSREFZITI | RefFlwCat-A/D | ||||
| stgbasis | VVSTGBASIS | Base Days Meth. | ||||
| stgmeth | VVSTGMETH | Daily Method | ||||
| sbasis | VVSBASIS | Base reference | ||||
| sberfima | SBEWFIMA | Calc. Category | ||||
| svorgkz | VVSVORGKZ | Activity ID | ||||
| mansp | MANSP | Dunn. Block | ||||
| dguel_kp | DGUEL_KP | Item Eff. From | ||||
| nstufe | NSTUFE | Level Number | ||||
| dbperiod | VVDBPERIOD | Period start | ||||
| spaexcl | TFMSPAEXCL | Exclusive Start | ||||
| spault | TFMSPAULT | MonEndIndStPer | ||||
| deperiod | VVDEPERIOD | Period end | ||||
| speincl | TFMSPEINCL | InclusiveEndPer | ||||
| speult | TFMSPEULT | MthEndPerEnd | ||||
| rkont | RKONT | Quota | ||||
| dausz | VVDAUSZ | Lead withh.amts | ||||
| ssolist | SSOLIST | Act.princip. | ||||
| rdarnehm | RDARNEHM_NEW | Borrower | ||||
| bkond | BKOND | Condition Amnt | ||||
| rzebel | VEBLGNR | Waivered with | ||||
| zfbdt | DDISPO | Payment date | ||||
| dzfest | TB_DZFEST | Int.Fixing Date | ||||
| sberech | SBERECH | Grace int.meth | ||||
| bkarzins | TFMBKAZINS | Interest | ||||
| btitalk | TFMBTIKALK | Imp_Ann_Rep_Amount | ||||
| hdn_kunnr | HDN_KUNNR | MainBorrCust. | ||||
| szart | TB_SZART | Pmnt Transact. | ||||
| ruzbel | BELNR_D | Document Number | ||||
| rebzj | REBZJ | Fiscal Year | ||||
| rebzg | REBZG | Invoice Ref. | ||||
| rebzz | REBZZ | Item | ||||
| s_ssdref | VVS_SSDREF | RefFlwCat_BNL | ||||
| saend | TFM_SAEND | Change ID | ||||
| xpore | PRQ_XPORE | Individual Payt | ||||
| spayrq | TB_SPAYRQK | Payment Request | ||||
| prkey | PRQ_KEYNO | Key Number | ||||
| hktid | HKTID | Account ID | ||||
| vorgtyp | VORGTYP_LO | Activity Cat. | ||||
| acenv | ACENV_LO | Source in post.area | ||||
| ssign | TB_SSIGN | Direction | ||||
| sprsng | TB_SPRSNGK | Individual Pmnt | ||||
| uzawe | UZAWE | Pmnt Meth. Sup. | ||||
| sprgrd | TB_SPRGRD | Group Determ. | ||||
| scspay | TB_SCSPAY | Same Direction | ||||
| zwels | DZWELS | Payment Methods | ||||
| paygr | PAYGR | Grouping | ||||
| jexpozins | TFM_SINTCOMP | Exponential | ||||
| srevalexcl | VVSREVALEXCL | Price gains w/o def. | ||||
| rbo | RBO | Bus.operat. no. | ||||
| sround | TFM_SROUND | Rounding Cat. | ||||
| skalidwt | TFMSKALIDWT | Int. Calendar | ||||
| ppayment | TFM_PPAYMENT | Payment Rate | ||||
| ammrhyzv | TFM_AMMRHYZV | Int.Sttlm.Freq | ||||
| lc_capitals | TB_LC_CAPITALS | Eff.CapAmntStat | ||||
| lc_disburse | TB_LC_DISBURSE | Eff.Disb.Status | ||||
| op_application | TB_OPAPPL | Application | ||||
| op_rbo | TB_OP_RBO | OI Tool: BO | ||||
| dfaell_old_ext | TB_EXTENS_DFAELL_OLD | Old Due Date | ||||
| ddispo_old_ext | TB_EXTENS_DDISPO_OLD | Old Payt Dt | ||||
| rbo_ext | RBO | Bus.operat. no. | ||||
| sbewegrp2 | TB_FLOW_REC_GRP | Flow Rec.Grp IP | ||||
| susp_reason_type | TB_SUSPREASON | Overpayment Reason | ||||
| mndid | SEPA_MNDID | Mandate Ref. | ||||
| sbewegrp | SBEWEGRP | Flow Group | ||||
| remit_info | TB_REMIT_INFO | Pay. Notes Info | ||||
| dip_kukey | FVD_DIP_KUKEY | Short Key (DIP) | ||||
| dip_esnum | FVD_DIP_ESNUM | Line Item Number | ||||
| dip_id | TB_DIP_ID | ID (Diff. IP) | ||||
| dip_date | TB_DIP_DATE | Date (Diff. IP) | ||||
| flg_ip_cli_notice | TB_FLG_IP_CLI_NOTICE | Payment created by CLI notice | ||||
| aavgdays | TFM_AAVGDAYS | Days AIR | ||||
| pavginterest | TFM_PAVGINTEREST | Aver. Int. Rate | ||||
| javgcap | TFM_JAVGCAP | Upper Limit | ||||
| pavgcap | TFM_PAVGCAP | Upper Limit | ||||
| javgfloor | TFM_JAVGFLOOR | Lower Limit | ||||
| pavgfloor | TFM_PAVGFLOOR | Lower Limit | ||||
| pavgspread | TFM_PAVGSPREAD | Spread | ||||
| sroundavginterest | TFM_SROUNDAVGINTEREST | RC of AIR | ||||
| rounddecavginterest | TFM_ROUNDDECAVGINTEREST | AIR Round. Dec. | ||||
| aavgweight | TFM_AWEIGHT | Weighting of IR | ||||
| aavgweightsum | TFM_AWEIGHTSUM | Cumul. Weight | ||||
| jexpointfactor | TFM_JEXPOINTFACTOR | Expo Int Factor | ||||
| flowfactor | TFM_FLOWFACTOR | Flow Factor | ||||
| basefactor | TFM_BASEFACTOR | Base Factor | ||||
| sfactorreset | TFM_SFACTORRESET | Reset | ||||
| pnon_cumulative_rate | TFM_NON_CUMULATIVE_RATE | Non Cum. Rate | ||||
| ca_dtrans | VVDTRANS | Flow date | ||||
| ca_ttrans | VVTTRANS | Time trans. | ||||
| ca_ntrans | VVNTRANS | Consec.tr. | ||||
| ca_flg_org | TB_FLG_CUST_ORG | Original Flow | ||||
| ca_reference | abap.int4 | |||||
| broundunit | TB_BROUNDUNIT_A | Rounding Unit | ||||
| sepa_pd | BUDAT | Posting Date |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Flow Data - Planned Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VDBEPP (
MANDT, -- Client [MANDT]
BUKRS, -- Company Code [BUKRS]
RANL, -- Contract Number [RANL]
DTRANS, -- Flow date [VVDTRANS]
TTRANS, -- Time trans. [VVTTRANS]
NTRANS, -- Consec.tr. [VVNTRANS]
RERF, -- Entered By [RERF]
DERF, -- First Enterd On [DERF]
TERF, -- Time [TERF]
REHER, -- Source.In.Entry [REHER]
RBEAR, -- Last Changed By [RBEAR]
DBEAR, -- Last Edited On [DBEAR]
TBEAR, -- Last Edited At [TBEAR]
RBHER, -- Editing Source [RBHER]
DVORGANG, -- Activity date [DVORGANG]
SVORGANG, -- Activity [SVORFALL]
NVORGANG, -- Activity no. [NVORGANG]
SBEWART, -- Flow Type [SBEWART]
SREFBEW, -- Refer.flow [SREFBEW]
SBEWZITI, -- Flow Category [SBEWZITI]
SPLANIST, -- Plan/Actual [SPLANIST]
SSOLHAB, -- Debit/Credit [VVSSOLHAB]
SSTORNO, -- Reverse indic. [SSTORNO]
SSTOGRD, -- Reversal Reason [SSTOGRD]
ZUONR, -- Assignment [DZUONR]
RSTBLG, -- Reversed With [STBLG]
SGTXT, -- Text [SGTXT]
SANLF, -- Prod. Category [SANLF]
DGUEL_KK, -- Cond. Eff. from [DGUEL]
NLFD_ANG, -- Off.consec.no. [NLFD_ANG]
SSTATI, -- Status [SSTATI]
GSART, -- Product Type [VVSART]
RREFKONT, -- Acct Assign.Ref [RREFKONT]
GSBER, -- Business Area [GSBER]
DORDER, -- Order date [DORDER]
NORDER, -- Order Number [NORDER]
BNWHR, -- Nominal amnt [BNWHR]
SNWHR, -- Nominal currency [SNWHR]
BBWHR, -- Amount in PC [BBWHR]
SBWHR, -- Position Currency [SBWHR]
BCWHR, -- Settlement Amount [BCWHR]
SCWHR, -- Settlement Currency [SCWHR]
BHWHR, -- Amount in LC [BHWHR]
KURS1, -- Exchange rate [VVKURSF]
KURS2, -- Exchange rate [VVKURSF]
DVALUT, -- Calculat. date [DVALUT]
DFAELL, -- Due on [DFAELLIG]
DDISPO, -- Payment date [DDISPO]
DBESTAND, -- Position Value Date [DBESTAND]
DBERVON, -- CalculationFrom [DBERVON]
DBERBIS, -- Calculation To [DBERBIS]
ATAGE, -- Number of Days [VVATAGE]
ABASTAGE, -- No. base days [ABASTAGE]
SZBMETH, -- Int.calc.method [SZBMETH]
UMSKZ, -- Special G/L Ind [UMSKZ]
KOSTL, -- Cost Center [KOSTL]
SSPESEN, -- Expen.key [SSPESEN]
RSOLL, -- Debit account [RSOLL]
RHABEN, -- Credit a/c [RHABEN]
RZKSOLL, -- Debit.inter.act [RZKSOLL]
RZKHABE, -- Cred.inter.acct [RZKHABE]
SBSLSOLL, -- Posting Key [BSCHL]
SBSLZKSO, -- Posting Key [BSCHL]
SBSLZKHA, -- Posting Key [BSCHL]
SHSLHABEN, -- Posting Key [BSCHL]
RBANKK, -- Int. bank acct [RBANKK]
SFDLEV, -- Planning Level [FDLEV]
JFDUPD, -- CMF flag [JFDUPD]
JONLAEN, -- Flow fixing [JONLAEN]
JZINSBAS, -- Interest base [JZINSBAS]
JZINSZPT, -- Interest date [JZINSZPT]
PKOND, -- Percentage Rate [PKOND]
BBASIS, -- Base Amount [BBASIS]
SSORTZIT, -- Sort indicator [SSORTZIT]
SWOHER, -- Source of flow [SWOHER]
SSTCKKZ, -- Acc.int.meth. [SSTCKKZ]
SSTCKTG, -- Daily Method [SSTCKTG]
PEFFZINS, -- Effect.int.rate [PEFFZINS]
SEFFMETH, -- Eff.Int. Method [SEFFMETH]
JVERF, -- Drawings [JVERF]
KUNNR, -- Customer [KUNNR]
BVTYP, -- Part.bank type [BVTYP]
ZLSCH, -- Pymt Meth. [DZLSCH]
MABER, -- Dunning Area [MABER]
ZAHLS, -- Payment Block [DZAHLS]
RPARTNR, -- BusPartner [BP_PARTNR_NEW]
SROLEXT, -- Dummy [DUMMY_3]
RKLAMMER, -- Finance Project [RKLAMMER]
JEINBEHALT, -- Withhold. disb. [VVJEINBE]
SZEGEN, -- Incoming Payt [SZEGEN]
MWSKZ, -- Tax Code [MWSKZ]
DTRANSREF, -- Flow date [VVDTRANS]
TTRANSREF, -- Time trans. [VVTTRANS]
NTRANSREF, -- Consec.tr. [VVNTRANS]
RPNNR, -- Daybook no. [VVRPNNR]
HBKID, -- House Bank [HBKID]
SBUST, -- Posting Control [VVSBUST]
PWKURS, -- Security price [PWKURS]
DSTOCK, -- PRF entry date [VVDSTOCK]
JVORAUS, -- Adv.pmnt ID [VVJVORAUS]
AMMRHY, -- Freq. in months [AMMRHY]
SKOART, -- Condition Type [SKOART]
SEXCLVON, -- Exclusive Start [VVSEXCLVON]
SULTVON, -- Mth-End StartDt [VVSULTVON]
SINCLBIS, -- Incl. End Date [VVSINCLBIS]
SULTBIS, -- Month-End EndDt [VVSULTBIS]
SINCL, -- Inclusive Ind. [VVSINCL]
DVERRECH, -- Settlem. date [VVDVERRECH]
DPKOND, -- Perc Fixing Dte [VVDPKOND]
RUMBLG, -- RefTrnDoc. [UMBLG]
ZINKZ, -- Interest Block [DZINKZ]
SVULT, -- Mon-End Val.Dte [VVSVULT]
JSOFVERR, -- Immed.settlemnt [JSOFVERR]
SINCLVERR, -- Incl. Clrg Date [VVSINCLVER]
SULTVERR, -- MnthEndClearing [VVSULTVERR]
SREFZITI, -- RefFlwCat-A/D [VVSREFZITI]
STGBASIS, -- Base Days Meth. [VVSTGBASIS]
STGMETH, -- Daily Method [VVSTGMETH]
SBASIS, -- Base reference [VVSBASIS]
SBERFIMA, -- Calc. Category [SBEWFIMA]
SVORGKZ, -- Activity ID [VVSVORGKZ]
MANSP, -- Dunn. Block [MANSP]
DGUEL_KP, -- Item Eff. From [DGUEL_KP]
NSTUFE, -- Level Number [NSTUFE]
DBPERIOD, -- Period start [VVDBPERIOD]
SPAEXCL, -- Exclusive Start [TFMSPAEXCL]
SPAULT, -- MonEndIndStPer [TFMSPAULT]
DEPERIOD, -- Period end [VVDEPERIOD]
SPEINCL, -- InclusiveEndPer [TFMSPEINCL]
SPEULT, -- MthEndPerEnd [TFMSPEULT]
RKONT, -- Quota [RKONT]
DAUSZ, -- Lead withh.amts [VVDAUSZ]
SSOLIST, -- Act.princip. [SSOLIST]
RDARNEHM, -- Borrower [RDARNEHM_NEW]
BKOND, -- Condition Amnt [BKOND]
RZEBEL, -- Waivered with [VEBLGNR]
ZFBDT, -- Payment date [DDISPO]
DZFEST, -- Int.Fixing Date [TB_DZFEST]
SBERECH, -- Grace int.meth [SBERECH]
BKARZINS, -- Interest [TFMBKAZINS]
BTITALK, -- Imp_Ann_Rep_Amount [TFMBTIKALK]
HDN_KUNNR, -- MainBorrCust. [HDN_KUNNR]
SZART, -- Pmnt Transact. [TB_SZART]
RUZBEL, -- Document Number [BELNR_D]
REBZJ, -- Fiscal Year [REBZJ]
REBZG, -- Invoice Ref. [REBZG]
REBZZ, -- Item [REBZZ]
S_SSDREF, -- RefFlwCat_BNL [VVS_SSDREF]
SAEND, -- Change ID [TFM_SAEND]
XPORE, -- Individual Payt [PRQ_XPORE]
SPAYRQ, -- Payment Request [TB_SPAYRQK]
PRKEY, -- Key Number [PRQ_KEYNO]
HKTID, -- Account ID [HKTID]
VORGTYP, -- Activity Cat. [VORGTYP_LO]
ACENV, -- Source in post.area [ACENV_LO]
SSIGN, -- Direction [TB_SSIGN]
SPRSNG, -- Individual Pmnt [TB_SPRSNGK]
UZAWE, -- Pmnt Meth. Sup. [UZAWE]
SPRGRD, -- Group Determ. [TB_SPRGRD]
SCSPAY, -- Same Direction [TB_SCSPAY]
ZWELS, -- Payment Methods [DZWELS]
PAYGR, -- Grouping [PAYGR]
JEXPOZINS, -- Exponential [TFM_SINTCOMP]
SREVALEXCL, -- Price gains w/o def. [VVSREVALEXCL]
RBO, -- Bus.operat. no. [RBO]
SROUND, -- Rounding Cat. [TFM_SROUND]
SKALIDWT, -- Int. Calendar [TFMSKALIDWT]
PPAYMENT, -- Payment Rate [TFM_PPAYMENT]
AMMRHYZV, -- Int.Sttlm.Freq [TFM_AMMRHYZV]
LC_CAPITALS, -- Eff.CapAmntStat [TB_LC_CAPITALS]
LC_DISBURSE, -- Eff.Disb.Status [TB_LC_DISBURSE]
OP_APPLICATION, -- Application [TB_OPAPPL]
OP_RBO, -- OI Tool: BO [TB_OP_RBO]
DFAELL_OLD_EXT, -- Old Due Date [TB_EXTENS_DFAELL_OLD]
DDISPO_OLD_EXT, -- Old Payt Dt [TB_EXTENS_DDISPO_OLD]
RBO_EXT, -- Bus.operat. no. [RBO]
SBEWEGRP2, -- Flow Rec.Grp IP [TB_FLOW_REC_GRP]
SUSP_REASON_TYPE, -- Overpayment Reason [TB_SUSPREASON]
MNDID, -- Mandate Ref. [SEPA_MNDID]
SBEWEGRP, -- Flow Group [SBEWEGRP]
REMIT_INFO, -- Pay. Notes Info [TB_REMIT_INFO]
DIP_KUKEY, -- Short Key (DIP) [FVD_DIP_KUKEY]
DIP_ESNUM, -- Line Item Number [FVD_DIP_ESNUM]
DIP_ID, -- ID (Diff. IP) [TB_DIP_ID]
DIP_DATE, -- Date (Diff. IP) [TB_DIP_DATE]
FLG_IP_CLI_NOTICE, -- Payment created by CLI notice [TB_FLG_IP_CLI_NOTICE]
AAVGDAYS, -- Days AIR [TFM_AAVGDAYS]
PAVGINTEREST, -- Aver. Int. Rate [TFM_PAVGINTEREST]
JAVGCAP, -- Upper Limit [TFM_JAVGCAP]
PAVGCAP, -- Upper Limit [TFM_PAVGCAP]
JAVGFLOOR, -- Lower Limit [TFM_JAVGFLOOR]
PAVGFLOOR, -- Lower Limit [TFM_PAVGFLOOR]
PAVGSPREAD, -- Spread [TFM_PAVGSPREAD]
SROUNDAVGINTEREST, -- RC of AIR [TFM_SROUNDAVGINTEREST]
ROUNDDECAVGINTEREST, -- AIR Round. Dec. [TFM_ROUNDDECAVGINTEREST]
AAVGWEIGHT, -- Weighting of IR [TFM_AWEIGHT]
AAVGWEIGHTSUM, -- Cumul. Weight [TFM_AWEIGHTSUM]
JEXPOINTFACTOR, -- Expo Int Factor [TFM_JEXPOINTFACTOR]
FLOWFACTOR, -- Flow Factor [TFM_FLOWFACTOR]
BASEFACTOR, -- Base Factor [TFM_BASEFACTOR]
SFACTORRESET, -- Reset [TFM_SFACTORRESET]
PNON_CUMULATIVE_RATE, -- Non Cum. Rate [TFM_NON_CUMULATIVE_RATE]
CA_DTRANS, -- Flow date [VVDTRANS]
CA_TTRANS, -- Time trans. [VVTTRANS]
CA_NTRANS, -- Consec.tr. [VVNTRANS]
CA_FLG_ORG, -- Original Flow [TB_FLG_CUST_ORG]
CA_REFERENCE, -- abap.int4
BROUNDUNIT, -- Rounding Unit [TB_BROUNDUNIT_A]
SEPA_PD, -- Posting Date [BUDAT]
PRIMARY KEY (MANDT, BUKRS, RANL, DTRANS, TTRANS, NTRANS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA