CRMD_BILLPLAN_D

Billing Plan Date | #transactional | Component: Billing Plan
Column Name Description
CLIENT Client
GUID GUID of a CRM Order Object
Column Name Description
💲 Currency (CURRENCY):
BILL_VALUE Value to be Billed on Date Specified in Billing Plan
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (QTY_UNIT):
QUANTITY CRM Schedule Line Quantity
Column Name Description
PRICE_DATE Pricing Date
Column Name Description
RULE_PRICE_DATE Rule for Determining the Pricing Date Show values
NO_BILLITEMS Generate Flag for No Billing Request Items Show values
BP_USAGE Billing Plan Usage Show values
BPLAN_DATE_TYPE UBB Billing Plan Date Type Show values
BILL_SETTL_STAT Settlement Status of Billing Request Line Show values
Column Name Description Domain name
BILLPLAN_GUID GUID of a CRM Order Object SYSUUID
PERIOD_DATE Period Date BCOS_TSTMP
RULE_PERIOD_DATE Rule for Determining the Period Date TIMERULEID
SETTL_FROM Start of Settlement for Period BCOS_TSTMP
RULE_SETTL_FROM Rule for Determining Start of Settlement Period TIMERULEID
SETTL_TO End of Settlement for Period BCOS_TSTMP
RULE_SETTL_TO Rule for Determining End of Settlement Period TIMERULEID
BILL_DATE Billing Date for Billing Index and Printout BCOS_TSTMP
RULE_BILL_DATE Rule for Determining the Next Billing Date TIMERULEID
INVCR_DATE Billing Document Creation Date BCOS_TSTMP
RULE_INVCR_DATE Rule for Determining Next Billing Document Creation Date TIMERULEID
VALUE_DATE Fixed Value Date BCOS_TSTMP
RULE_VALUE_DATE Rule for Origin of Next Fixed Value Date TIMERULEID
PERCENTAGE Percentage of Value to be Billed DEC3_2
NO_OF_PERIODS Number of Periods in Billing Plan
NUMBER_INT Billing Plan: Internal Sort Order
CASHFLOW_TYPE Flow Category CRMT_CASHFLOW_TYPE
BILLPLAN_LINE_ID ID of Billing Plan Line CRMT_BILLPLAN_LINE_ID
START_DATE Start Date of Billing Plan BCOS_TSTMP
RULE_START_DATE Rule for Determining Billing Plan Start Date TIMERULEID
END_DATE End Date of Billing Plan BCOS_TSTMP
RULE_END_DATE Rule for Determining Billing Plan End Date TIMERULEID
DATE_FROM Dates From BCOS_TSTMP
RULE_DATE_FROM Rule for Determining Dates from TIMERULEID
DATE_TO Dates To BCOS_TSTMP
RULE_DATE_TO Rule for Determining Dates To TIMERULEID
RULE_STA_DATE_T Rule for Determining Billing Plan Start Date TIMENAME
RULE_END_DATE_T Rule for Determining Billing Plan End Date TIMENAME
RULE_DATE_FROM_T Rule for determining dates from TIMENAME
RULE_DATE_TO_T Rule for Determining Dates to TIMENAME
BP_SUBTYPE Billing Plan Subtype CRMT_BP_SUBTYPE
NO_OF_BLOCK UBB Pool Assignment
RULE_PER_ORIG_T Rule for Determining the Period Date TIMENAME
PERIOD_DURA Numerical Value of Duration TIMEDURA
PERIOD_UNIT Default Value for Time Unit TIMEUNITNA
DESCRIPTION Description TEXT40
BILLING_BLOCK Business Partner: Billing Block Reason FAKSP
SERVICESRENDEREDDATETIME Services Rendered Date as Timestamp TZNTSTMPS
KIND_PERIOD_DATE Date type SC_APPTTYP
KIND_SETTL_FROM Date type SC_APPTTYP
KIND_SETTL_TO Date type SC_APPTTYP
KIND_BILL_DATE Date type SC_APPTTYP
KIND_INVCR_DATE Date type SC_APPTTYP
KIND_VALUE_DATE Date type SC_APPTTYP
KIND_START_DATE Date type SC_APPTTYP
KIND_END_DATE Date type SC_APPTTYP
KIND_DATE_FROM Date type SC_APPTTYP
KIND_DATE_TO Date type SC_APPTTYP
NUMBER_EXT External Item Number
Master Data Relations Join Conditions
Time Zone of Billing Plan Set
  • CRMD_BILLPLAN_D.CLIENT == TTZZ.CLIENT
  • CRMD_BILLPLAN_D.BILLING_TIMEZONE == TTZZ.TZONE
Currency
  • CRMD_BILLPLAN_D.CLIENT == TCURC.MANDT
  • CRMD_BILLPLAN_D.CURRENCY == TCURC.WAERS
UBB Process Event Type CRMD_BILLPLAN_D.PROC_EVENT_TYPE == CRMC_PE_TYPE.PROC_EVENT_TYPE
UBB Process Event Type CRMD_BILLPLAN_D.PROC_EVENT_TYPE2 == CRMC_PE_TYPE.PROC_EVENT_TYPE