CRMT_BILLPLAN_D_DB_WRK SAP (Date in Reference: Structure of the Database Buffer) Structure details

Dictionary Type: Structure
Description: Date in Reference: Structure of the Database Buffer




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




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

CRMT_BILLPLAN_D_DB_WRK 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 "Date in Reference: Structure of the Database Buffer" 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_CRMT_BILLPLAN_D_DB_WRK TYPE CRMT_BILLPLAN_D_DB_WRK.

The CRMT_BILLPLAN_D_DB_WRK table consists of various fields, each holding specific information or linking keys about Date in Reference: Structure of the Database Buffer data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), BILLPLAN_GUID (GUID of a CRM Order Object), PERIOD_DATE (Period 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 CRMT_BILLPLAN_D_DB_WRK 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
BILLPLAN_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
PERIOD_DATEPeriod Date CRMT_PERIOD_DATEDEC15TSTPSBCOS_TSTMP
RULE_PERIOD_DATERule for Determining the Period Date CRMT_RULE_PERIOD_DATERAW16Assigned to domainTIMERULEID
SETTL_FROMStart of Settlement for Period CRMT_SETTL_FROMDEC15TSTPSBCOS_TSTMP
RULE_SETTL_FROMRule for Determining Start of Settlement Period CRMT_RULE_SETTL_FROMRAW16Assigned to domainTIMERULEID
SETTL_TOEnd of Settlement for Period CRMT_SETTL_TODEC15TSTPSBCOS_TSTMP
RULE_SETTL_TORule for Determining End of Settlement Period CRMT_RULE_SETTL_TORAW16Assigned to domainTIMERULEID
BILL_DATEBilling Date for Billing Index and Printout CRMT_BILL_DATEDEC15TSTPSBCOS_TSTMP
RULE_BILL_DATERule for Determining the Next Billing Date CRMT_RULE_BILL_DATERAW16Assigned to domainTIMERULEID
INVCR_DATEBilling Document Creation Date CRMT_INVCR_DATEDEC15TSTPSBCOS_TSTMP
RULE_INVCR_DATERule for Determining Next Billing Document Creation Date CRMT_RULE_INVCR_DATERAW16Assigned to domainTIMERULEID
VALUE_DATEFixed Value Date CRMT_VALUE_DATEDEC15TSTPSBCOS_TSTMP
RULE_VALUE_DATERule for Origin of Next Fixed Value Date CRMT_RULE_VALUE_DATERAW16Assigned to domainTIMERULEID
BILLING_TIMEZONETime Zone of Billing Plan Set CRMT_BILLING_TIMEZONECHAR6TTZZTZNZONE
PERCENTAGEPercentage of Value to be Billed CRMT_BILL_PERCENTAGEDEC5(2) DEC3_2
BILL_VALUEValue to be Billed on Date Specified in Billing Plan CRMT_BILL_VALUECURR19(2) PRC_COND_VALUE
CURRENCYCurrency CRMT_CURRENCYCUKY5Assigned to domainWAERSFWS
NO_OF_PERIODSNumber of Periods in Billing Plan CRMT_NO_OF_PERIODSNUMC5
NUMBER_INTBilling Plan: Internal Sort Order CRMT_BILL_NUMBER_INTNUMC10
CASHFLOW_TYPEFlow Category CRMT_CASHFLOW_TYPECHAR4CRMT_CASHFLOW_TYPE
QUANTITYCRM Schedule Line Quantity CRMT_SCHEDLIN_QUANQUAN13(3) MENG13
QTY_UNITUnit of Measure in Which the Product Is Sold CRMT_PROCESS_QTY_UNITUNIT3Assigned to domainCUNITMEINS
NO_BILLITEMSGenerate Flag for No Billing Request Items CRMT_NO_BILLITEMSCHAR1XFELD
BP_USAGEBilling Plan Usage CRMT_BP_USAGECHAR1CRMT_BP_USAGE
BILLPLAN_LINE_IDID of Billing Plan Line CRMT_BILLPLAN_LINE_IDCHAR2CRMT_BILLPLAN_LINE_ID
START_DATEStart Date of Billing Plan CRMT_START_DATEDEC15TSTPSBCOS_TSTMP
RULE_START_DATERule for Determining Billing Plan Start Date CRMT_RULE_START_DATERAW16Assigned to domainTIMERULEID
END_DATEEnd Date of Billing Plan CRMT_END_DATEDEC15TSTPSBCOS_TSTMP
RULE_END_DATERule for Determining Billing Plan End Date CRMT_RULE_END_DATERAW16Assigned to domainTIMERULEID
DATE_FROMDates From CRMT_DATE_FROMDEC15TSTPSBCOS_TSTMP
RULE_DATE_FROMRule for Determining Dates from CRMT_RULE_DATE_FROMRAW16Assigned to domainTIMERULEID
DATE_TODates To CRMT_DATE_TODEC15TSTPSBCOS_TSTMP
RULE_DATE_TORule for Determining Dates To CRMT_RULE_DATE_TORAW16Assigned to domainTIMERULEID
RULE_STA_DATE_TRule for Determining Billing Plan Start Date CRMT_RULE_START_DATE_TCHAR12TIMENAME
RULE_END_DATE_TRule for Determining Billing Plan End Date CRMT_RULE_END_DATE_TCHAR12TIMENAME
RULE_DATE_FROM_TRule for determining dates from CRMT_RULE_DATE_FROM_TCHAR12TIMENAME
RULE_DATE_TO_TRule for Determining Dates to CRMT_RULE_DATE_TO_TCHAR12TIMENAME
BP_SUBTYPEBilling Plan Subtype CRMT_BP_SUBTYPECHAR1Assigned to domainCRMT_BP_SUBTYPE
BPLAN_DATE_TYPEUBB Billing Plan Date Type CRMT_BILLPLAN_DATE_TYPENUMC2CRM_BILLPLAN_DATE_TYPE
NO_OF_BLOCKUBB Pool Assignment CRMT_NO_OF_BLOCKNUMC3
PROC_EVENT_TYPEUBB Process Event Type CRMT_PROCESS_EVENT_TYPECHAR4CRMC_PE_TYPECRM_PROCESS_EVENT_TYPE
PROC_EVENT_TYPE2UBB Process Event Type CRMT_PROCESS_EVENT_TYPECHAR4CRMC_PE_TYPECRM_PROCESS_EVENT_TYPE
RULE_PER_ORIG_TRule for Determining the Period Date CRMT_RULE_PERIOD_DATE_TCHAR12TIMENAME
PERIOD_DURANumerical Value of Duration TIMEDURADEC13TIMEDURA
PERIOD_UNITDefault Value for Time Unit TIMEUNITDUCHAR12Assigned to domainTIMEUNITNA
KIND_PERIOD_DATEDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_SETTL_FROMDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_SETTL_TODate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_BILL_DATEDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_INVCR_DATEDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_VALUE_DATEDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_START_DATEDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_END_DATEDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_DATE_FROMDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_DATE_TODate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
NUMBER_EXTExternal Item Number CRMT_ITEM_NO_EXTNUMC10
FIN_VIEWFinancing View CRMT_FINANCING_VIEWNUMC2Assigned to domainCRMT_FINANCING_VIEW
SCHED_INDSchedule Line Indicator for Billing Plan CRMT_SCHED_INDICATORCHAR1CRM_SCHED_INDICATOR
PER_PAYMENTFORMWhen Due in Period CRMT_PER_PAYMENTFORMNUMC1Assigned to domainCRMT_PAYMENTFORM
UNIT_PERIODSTime Unit for Periods CRMT_UNIT_PERIODSNUMC2TFMSINSTALLMENT
MAN_FIRSTDUEDATEIndividual Due Date CRMT_MAN_FIRSTDUEDATEDEC15TSTPSBCOS_TSTMP
NOMINAL_INT_RATENominal Interest Rate CRMT_NOMINAL_INT_RATEDEC10(7) DECV3_7
NOMINAL_IRAT_INTNominal Interest Rate (Internal Plan) CRMT_NOMINAL_INT_RATE_INTDEC10(7) DECV3_7
DEFAULT_AMOUNTDefault Amount CRMT_DEFAULT_AMOUNTCURR19(2) CRMT_COND_VALUE
DEFAULT_PERCENTDefault Percentage CRMT_DEFAULT_PERCENTAGEDEC10(7) DECV3_7
DEF_RATEPERXDefault Rate per x CRMT_DEFAULT_RATEPERKDEC17(10) CRMT_DECV7_10
FREQ_CONVERSIONPayment Frequency Factor CRMT_FREQ_CONVERSIONDEC6TFM_PPAYMENT_INTERN
CALCULATION_DATECalculation date CRMT_CALCULATION_DATEDEC15TSTPSBCOS_TSTMP
FLAG_ULTIMODo Not Draw Standard Values from Conditions CRMT_FLAG_ULTIMOCHAR1XFELD
FLAG_BLOCKEDCalculation Locked CRMT_FLAG_BLOCKEDCHAR1XFELD
STEP_KINDPayment Structure/Change to Principal Indicator CRMT_STEP_KINDNUMC2CRMT_STEP_KIND
FIXINGField Control Billplan_d Rows (Fixed/Changeable) CRMT_STEP_FIXINGNUMC2CRMT_FINPROD_FIX01
SETTL_FROM_VIRTUVirtual Start of Settlement of Period CRMT_SETTL_FROM_FIMADEC15TSTPSBCOS_TSTMP
DATEUPD_SUPPRESSNo Date Update (FIMA) CRMT_DATEUPD_SUPPRESSCHAR1CRMT_DATEUPD_SUPPRESS
OFFSET_VALOffset CRMT_FINPROD_OFFS01DEC5DEC5
OFFSET_UNITOffset Unit CRMT_FINPROD_OFFSU01CHAR12Assigned to domainTIMEUNITNA
SETTLEDSettled Payment Step CRMT_FIMAN_SETTLEDCHAR1CRMT_FIMAN_SETTLED
FACTOR1Factor CRMT_FIMAN_FACTORDEC15(10) DECV5_10
FACTOR2Factor CRMT_FIMAN_FACTORDEC15(10) DECV5_10
FACTOR3Factor CRMT_FIMAN_FACTORDEC15(10) DECV5_10
RESULT_AMOUNTResulting Amount CRMT_RESULT_AMOUNTCURR19(2) CRMT_COND_VALUE
RESULT_AMOUNT_PRUnrounded Result Amount CRMT_AMOUNT_PRECISECURR19(2) CRMT_COND_VALUE
RPX_DIVISORDivisor for Rate per x Determination CRMT_RPXDIVCURR19(2) CRMT_COND_VALUE
RESULT_RATEPERKRate per x CRMT_RESULT_RATEPERKDEC17(10) CRMT_DECV7_10
RESULT_RATE_K_GGross Rate per X CRMT_RESULT_RATEPERK_GDEC17(10) CRMT_DECV7_10
PARTNER1Partner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
PARTNER1_FCTPartner func. CRMT_PARTNER_FCTCHAR8COM_PARTNER_FCT
PARTNER2Partner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
PARTNER2_FCTPartner func. CRMT_PARTNER_FCTCHAR8COM_PARTNER_FCT
AC_INDICATORAccounting Indicator CRMT_AC_INDICATORCHAR2Assigned to domainCRMT_AC_INDICATOR
AC_OBJECT_TYPEObject Type for Settlement Account Assignment CRMT_AC_OBJECT_TYPECHAR2Assigned to domainACTYPCRMT_OBJECT_TYPE
AC_ASSIGNMENTSettlement Account Assignment CRMT_AC_ASSIGNCHAR50CRMT_AC_ASSIGN
AC_PERCENTAGEPercentage of Costs to Be Distributed CRMT_AC_COST_PERCENTAGEDEC5(2) DEC3_2
SPLIT_ORIGINOrigin Split CRMT_SPLIT_ORIGINCHAR2CRMT_SPLIT_ORIGIN
KSCHLPricing - Condition Type PRCT_COND_TYPECHAR4Assigned to domain/SAPCND/COND_TYPEVKS
GROUP1Group 1 CRMT_GROUP1CHAR32CRMT_GROUP
GROUP2Group 2 CRMT_GROUP2CHAR32CRMT_GROUP
GROUP3Group 3 CRMT_GROUP3CHAR32CRMT_GROUP
GROUP4Group 4 CRMT_GROUP4CHAR32CRMT_GROUP
GROUP5Group 5 CRMT_GROUP5CHAR32CRMT_GROUP
GROUP6Group 6 CRMT_GROUP6CHAR32CRMT_GROUP
GROUP7Group 7 CRMT_GROUP7CHAR32CRMT_GROUP
NOREC_FLAGEntry does not Exist in Database CRMT_NORECCHAR1CRM_BOOLEAN

Key field Non-key field



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

As CRMT_BILLPLAN_D_DB_WRK 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 CRMT_BILLPLAN_D_DB_WRK as there is no data to select.

How to access SAP table CRMT_BILLPLAN_D_DB_WRK

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