C_OutsrtdUtilsBillgDocBscDataQ

Outsorted Billing Document Basic Data Query | view: CEOUTSRTDBDBSCDQ | 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
UtilsBillgPeriodStartDate Billing Period Start
UtilsBillgPeriodEndDate Billing Period End
ScheduledMeterReadingDate Scheduled Meter Reading Date
Column Name Description
UtilitiesBillingReason Billing Reason Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
ContractAccount Contract Account Number VKONT_KK
UtilitiesContract Contract VERTRAG
UtilitiesPortionName Portion Name BEZEICHNG
UtilitiesBillingReasonName Billing Reason Name DDTEXT
CompanyCodeName Name of Company Code or Company TEXT25
DivisionName Division Description TEXT20
MeterReadingUnit Meter Reading Unit ABLEINHEIT
NmbrOfOutsortedUtilsBillgDocs Number of Outsorted Billing Documents
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.COMPANYCODE == T001.BUKRS
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.MANDT == T001.MANDT
Division
  • Client
  • Division
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.MANDT == TSPA.MANDT
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.DIVISION == TSPA.SPART
Portion
  • Portion
  • Client
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.UTILITIESPORTION == TE420.TERMSCHL
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.MANDT == TE420.MANDT
Main Transaction for Line Item
  • ?
  • Main Transaction for Line Item
  • Client
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.[column in domain "APPLK_KK"] == TFKHVO.APPLK
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.UTILSBUSTRANSACTIONTYPE == TFKHVO.HVORG
  • C_OUTSRTDUTILSBILLGDOCBSCDATAQ.MANDT == TFKHVO.MANDT