SAP Table CRMD_BILLPLAN stores Billing Plandata

  

In this post, I will try and describe everything you need to know about the SAP crmd_billplan 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 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....Right lets get started!


SAP CRMD_BILLPLAN dictionary attributes

Object Name: CRMD_BILLPLAN
Dictionary Type: Transparent table
Description: Billing Plan


CRMD_BILLPLAN 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_TYPECRMT_BILLPLAN_TYPECHAR2(0) CRMC_BILP_TYPEBilling Plan TypeCRM_BILLPLAN_TYPECRM
REFERENCE_NOCRMT_REFERENCE_NOCHAR10(0) Reference Billing Plan NumberCRM_REFERENCE_BILLPLANCRM
RULE_HORIZONCRMT_RULE_HORIZONRAW16(0) *Rule for Determining Horizon in Billing PlanTIMERULEIDCRM
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
BILLING_TIMEZONECRMT_BILLING_TIMEZONECHAR6(0) *Time Zone of Billing Plan SetTZNZONECRM
SET_GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
KIND_HORIZONTIMENAEVENCHAR12(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


View list of all tables