SAP S/4Hana table CRMD_BILLPLAN_DF stores Date in Billing Plan for Financingdata

  

So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like CRMD_BILLPLAN_DF look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.

Infact even for tables that have been replaced in hana, SAP have purposfully created versions of the old/original tables for backward compatability. This means your existing ABAP code will still work while you implement changes that take advantage of the new functionality and Hana in-memory tables.


S4 Hana CRMD_BILLPLAN_DF dictionary attributes

Object Name: CRMD_BILLPLAN_DF
Dictionary Type: Transparent table
Description: Date in Billing Plan for Financing


Field list for CRMD_BILLPLAN_DF table on an S/4 SAP system

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTEST
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUID
FIN_VIEWCRMT_FINANCING_VIEWNUMC2(0) *Financing ViewCRMT_FINANCING_VIEW
SCHED_INDCRMT_SCHED_INDICATORCHAR1(0) Schedule Line Indicator for Billing PlanCRM_SCHED_INDICATOR
PER_PAYMENTFORMCRMT_PER_PAYMENTFORMNUMC1(0) *When Due in PeriodCRMT_PAYMENTFORM
UNIT_PERIODSCRMT_UNIT_PERIODSNUMC2(0) Time Unit for PeriodsTFMSINSTALLMENT
MAN_FIRSTDUEDATECRMT_MAN_FIRSTDUEDATEDEC15(0) Individual Due DateBCOS_TSTMP
NOMINAL_INT_RATECRMT_NOMINAL_INT_RATEDEC10(7) Nominal Interest RateDECV3_7
NOMINAL_IRAT_INTCRMT_NOMINAL_INT_RATE_INTDEC10(7) Nominal Interest Rate (Internal Plan)DECV3_7
DEFAULT_AMOUNTCRMT_DEFAULT_AMOUNTCURR19(2) Default AmountCRMT_COND_VALUE
DEFAULT_PERCENTCRMT_DEFAULT_PERCENTAGEDEC10(7) Default PercentageDECV3_7
DEF_RATEPERXCRMT_DEFAULT_RATEPERKDEC17(10) Default Rate per xCRMT_DECV7_10
FREQ_CONVERSIONCRMT_FREQ_CONVERSIONDEC6(0) Payment Frequency FactorTFM_PPAYMENT_INTERN
CALCULATION_DATECRMT_CALCULATION_DATEDEC15(0) Calculation dateBCOS_TSTMP
FLAG_ULTIMOCRMT_FLAG_ULTIMOCHAR1(0) Do Not Draw Standard Values from ConditionsXFELD
FLAG_BLOCKEDCRMT_FLAG_BLOCKEDCHAR1(0) Calculation LockedXFELD
STEP_KINDCRMT_STEP_KINDNUMC2(0) Payment Structure/Change to Principal IndicatorCRMT_STEP_KIND
FIXINGCRMT_STEP_FIXINGNUMC2(0) Field Control Billplan_d Rows (Fixed/Changeable)CRMT_FINPROD_FIX01
SETTL_FROM_VIRTUCRMT_SETTL_FROM_FIMADEC15(0) Virtual Start of Settlement of PeriodBCOS_TSTMP
DATEUPD_SUPPRESSCRMT_DATEUPD_SUPPRESSCHAR1(0) No Date Update (FIMA)CRMT_DATEUPD_SUPPRESS
OFFSET_VALCRMT_FINPROD_OFFS01DEC5(0) OffsetDEC5
OFFSET_UNITCRMT_FINPROD_OFFSU01CHAR12(0) *Offset UnitTIMEUNITNA
SETTLEDCRMT_FIMAN_SETTLEDCHAR1(0) Settled Payment StepCRMT_FIMAN_SETTLED
FACTOR1CRMT_FIMAN_FACTORDEC15(10) FactorDECV5_10FVV
FACTOR2CRMT_FIMAN_FACTORDEC15(10) FactorDECV5_10FVV
FACTOR3CRMT_FIMAN_FACTORDEC15(10) FactorDECV5_10FVV
RESULT_AMOUNTCRMT_RESULT_AMOUNTCURR19(2) Resulting AmountCRMT_COND_VALUE
RESULT_AMOUNT_PRCRMT_AMOUNT_PRECISECURR19(2) Unrounded Result AmountCRMT_COND_VALUE
RPX_DIVISORCRMT_RPXDIVCURR19(2) Divisor for Rate per x DeterminationCRMT_COND_VALUE
RESULT_RATEPERKCRMT_RESULT_RATEPERKDEC17(10) Rate per xCRMT_DECV7_10
RESULT_RATE_K_GCRMT_RESULT_RATEPERK_GDEC17(10) Gross Rate per XCRMT_DECV7_10


View list of all S4 Hana tables