SAP Table CRMD_BILLPLAN_D stores Billing Plan Datedata

  

In this post, I will try and describe everything you need to know about the SAP crmd_billplan_d table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for CRMD_BILLPLAN_D what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from CRMD_BILLPLAN_D....Right lets get started!


SAP CRMD_BILLPLAN_D dictionary attributes

Object Name: CRMD_BILLPLAN_D
Dictionary Type: Transparent table
Description: Billing Plan Date


CRMD_BILLPLAN_D field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
BILLPLAN_GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
PERIOD_DATECRMT_PERIOD_DATEDEC15(0) Period DateBCOS_TSTMPCRM
RULE_PERIOD_DATECRMT_RULE_PERIOD_DATERAW16(0) *Rule for Determining the Period DateTIMERULEIDCRM
SETTL_FROMCRMT_SETTL_FROMDEC15(0) Start of Settlement for PeriodBCOS_TSTMPCRM
RULE_SETTL_FROMCRMT_RULE_SETTL_FROMRAW16(0) *Rule for Determining Start of Settlement PeriodTIMERULEIDCRM
SETTL_TOCRMT_SETTL_TODEC15(0) End of Settlement for PeriodBCOS_TSTMPCRM
RULE_SETTL_TOCRMT_RULE_SETTL_TORAW16(0) *Rule for Determining End of Settlement PeriodTIMERULEIDCRM
BILL_DATECRMT_BILL_DATEDEC15(0) Billing Date for Billing Index and PrintoutBCOS_TSTMPCRM
RULE_BILL_DATECRMT_RULE_BILL_DATERAW16(0) *Rule for Determining the Next Billing DateTIMERULEIDCRM
INVCR_DATECRMT_INVCR_DATEDEC15(0) Billing Document Creation DateBCOS_TSTMPCRM
RULE_INVCR_DATECRMT_RULE_INVCR_DATERAW16(0) *Rule for Determining Next Billing Document Creation DateTIMERULEIDCRM
VALUE_DATECRMT_VALUE_DATEDEC15(0) Fixed Value DateBCOS_TSTMPCRM
RULE_VALUE_DATECRMT_RULE_VALUE_DATERAW16(0) *Rule for Origin of Next Fixed Value DateTIMERULEIDCRM
BILLING_TIMEZONECRMT_BILLING_TIMEZONECHAR6(0) TTZZTime Zone of Billing Plan SetTZNZONECRM
PERCENTAGECRMT_BILL_PERCENTAGEDEC5(2) Percentage of Value to be BilledDEC3_2CRM
BILL_VALUECRMT_BILL_VALUECURR19(2) Value to be Billed on Date Specified in Billing PlanPRC_COND_VALUECRM
CURRENCYCRMT_CURRENCYCUKY5(0) *CurrencyWAERSFWSCRM
NO_OF_PERIODSCRMT_NO_OF_PERIODSNUMC5(0) Number of Periods in Billing PlanCRM
NUMBER_INTCRMT_BILL_NUMBER_INTNUMC10(0) Billing Plan: Internal Sort OrderCRM
CASHFLOW_TYPECRMT_CASHFLOW_TYPECHAR4(0) Flow CategoryCRMT_CASHFLOW_TYPECRM
QUANTITYCRMT_SCHEDLIN_QUANQUAN13(3) CRM Schedule Line QuantityMENG13CRM
QTY_UNITCRMT_PROCESS_QTY_UNITUNIT3(0) *Unit of Measure in Which the Product Is SoldMEINSCRM
NO_BILLITEMSCRMT_NO_BILLITEMSCHAR1(0) Generate Flag for No Billing Request ItemsXFELDCRM
BP_USAGECRMT_BP_USAGECHAR1(0) Billing Plan UsageCRMT_BP_USAGECRM
BILLPLAN_LINE_IDCRMT_BILLPLAN_LINE_IDCHAR2(0) ID of Billing Plan LineCRMT_BILLPLAN_LINE_IDCRM
START_DATECRMT_START_DATEDEC15(0) Start Date of Billing PlanBCOS_TSTMPCRM
RULE_START_DATECRMT_RULE_START_DATERAW16(0) *Rule for Determining Billing Plan Start DateTIMERULEIDCRM
END_DATECRMT_END_DATEDEC15(0) End Date of Billing PlanBCOS_TSTMPCRM
RULE_END_DATECRMT_RULE_END_DATERAW16(0) *Rule for Determining Billing Plan End DateTIMERULEIDCRM
DATE_FROMCRMT_DATE_FROMDEC15(0) Dates FromBCOS_TSTMPCRM
RULE_DATE_FROMCRMT_RULE_DATE_FROMRAW16(0) *Rule for Determining Dates fromTIMERULEIDCRM
DATE_TOCRMT_DATE_TODEC15(0) Dates ToBCOS_TSTMPCRM
RULE_DATE_TOCRMT_RULE_DATE_TORAW16(0) *Rule for Determining Dates ToTIMERULEIDCRM
RULE_STA_DATE_TCRMT_RULE_START_DATE_TCHAR12(0) Rule for Determining Billing Plan Start DateTIMENAMECRM
RULE_END_DATE_TCRMT_RULE_END_DATE_TCHAR12(0) Rule for Determining Billing Plan End DateTIMENAMECRM
RULE_DATE_FROM_TCRMT_RULE_DATE_FROM_TCHAR12(0) Rule for determining dates fromTIMENAMECRM
RULE_DATE_TO_TCRMT_RULE_DATE_TO_TCHAR12(0) Rule for Determining Dates toTIMENAMECRM
BP_SUBTYPECRMT_BP_SUBTYPECHAR1(0) *Billing Plan SubtypeCRMT_BP_SUBTYPECRM
BPLAN_DATE_TYPECRMT_BILLPLAN_DATE_TYPENUMC2(0) UBB Billing Plan Date TypeCRM_BILLPLAN_DATE_TYPECRM
NO_OF_BLOCKCRMT_NO_OF_BLOCKNUMC3(0) UBB Pool AssignmentCRM
PROC_EVENT_TYPECRMT_PROCESS_EVENT_TYPECHAR4(0) CRMC_PE_TYPEUBB Process Event TypeCRM_PROCESS_EVENT_TYPECRM
PROC_EVENT_TYPE2CRMT_PROCESS_EVENT_TYPECHAR4(0) CRMC_PE_TYPEUBB Process Event TypeCRM_PROCESS_EVENT_TYPECRM
RULE_PER_ORIG_TCRMT_RULE_PERIOD_DATE_TCHAR12(0) Rule for Determining the Period DateTIMENAMECRM
PERIOD_DURATIMEDURADEC13(0) Numerical Value of DurationTIMEDURACRM
PERIOD_UNITTIMEUNITDUCHAR12(0) *Default Value for Time UnitTIMEUNITNACRM
KIND_PERIOD_DATETIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_SETTL_FROMTIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_SETTL_TOTIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_BILL_DATETIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_INVCR_DATETIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_VALUE_DATETIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_START_DATETIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_END_DATETIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_DATE_FROMTIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
KIND_DATE_TOTIMENAEVENCHAR12(0) *Date typeSC_APPTTYPTIMENAEVNAME_EVENTCRM
NUMBER_EXTCRMT_ITEM_NO_EXTNUMC10(0) External Item NumberCRM


View list of all tables