SAP Table CRMD_BILLING stores Business Transaction - Billing Setdata

  

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


SAP CRMD_BILLING dictionary attributes

Object Name: CRMD_BILLING
Dictionary Type: Transparent table
Description: Business Transaction - Billing Set


CRMD_BILLING 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
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
SETTL_FIMACRMT_SETTL_FIMADEC15(0) Internal Billing Date for Financial MathematicsBCOS_TSTMPCRM
FIMA_KONDINDCRMT_FIMA_KONDINDNUMC10(0) Reference FIMA Condition ItemCRM
FIMA_BEWEINDCRMT_FIMA_BEWEINDNUMC10(0) Reference FIMA Flow RecordCRM
BILLING_BLOCKCRMT_BUS_BILL_BLOCK_REASONCHAR2(0) *Business Partner (CRM): Billing Block ReasonCRM_BILLING_BLOCKCRM
BUAG_GUIDCRMT_BUAG_GUIDRAW16(0) GUID of the Business AgreementSYSUUIDCRM
BP_SUBTYPECRMT_BP_SUBTYPECHAR1(0) *Billing Plan SubtypeCRMT_BP_SUBTYPECRM
PERIOD_TYPECRMT_PERIOD_TYPECHAR2(0) *Period Type (First, Last, First and Last, etc.)CRM_PERIOD_TYPECRM
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


View list of all tables