C_ActualUtilsBillingDocumentQ

Actual Billing Document Query | view: CEACTLBILLGDOCQ | Extraction: Not supported | Component: Contract Billing
Tables used: ERCHT001TKA02TSPATSPATTE420
Column Name Description
UtilitiesBillingDocument Number of Billing Document
Column Name Description
Column Name Description
Column Name Description
ScheduledUtilitiesBillingDate Scheduled Billing Date
ScheduledMeterReadingDate Scheduled Meter Reading Date
Column Name Description
UtilitiesBillingReason Billing Reason Show values
Column Name Description Domain name
ContractAccount Contract Account Number VKONT_KK
BusinessPartner Business Partner Number BU_PARTNER
UtilitiesContract Contract VERTRAG
UtilitiesPortionName Portion Name BEZEICHNG
MeterReadingUnit Meter Reading Unit ABLEINHEIT
UtilitiesBillingReasonName Billing Reason Name DDTEXT
CompanyCodeName Name of Company Code or Company TEXT25
DivisionName Division Description TEXT20
NmbrOfUtilsBillgDocRdyForInvcg Number of Actual Billing Documents
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_ACTUALUTILSBILLINGDOCUMENTQ.COMPANYCODE == T001.BUKRS
  • C_ACTUALUTILSBILLINGDOCUMENTQ.MANDT == T001.MANDT
Division
  • Division
  • Client
  • C_ACTUALUTILSBILLINGDOCUMENTQ.DIVISION == TSPA.SPART
  • C_ACTUALUTILSBILLINGDOCUMENTQ.MANDT == TSPA.MANDT
Portion
  • Portion
  • Client
  • C_ACTUALUTILSBILLINGDOCUMENTQ.UTILITIESPORTION == TE420.TERMSCHL
  • C_ACTUALUTILSBILLINGDOCUMENTQ.MANDT == TE420.MANDT