C_ReversedUtilsBillingDocQuery

Reversed Billing Document Query | view: CERVSDBILLGDOCQ | Extraction: Not supported | Component: Contract Billing
Tables used: ERCHT001TKA02TSPATSPATTE422TE420TE272TE272T
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
UtilsBillgDocReversalDate Reversal date
Column Name Description
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
ContractAccount Contract Account Number VKONT_KK
UtilitiesContract Contract VERTRAG
DivisionName Division Description TEXT20
UtilitiesPortionName Portion Name BEZEICHNG
UtilsBillgDocReversalRsnName Text, Length 40 TEXT40
MeterReadingUnit Meter Reading Unit ABLEINHEIT
MeterReadingUnitName Meter Reading Unit Name BEZEICHNG
CompanyCodeName Name of Company Code or Company TEXT25
NmbrOfReversedUtilsBillgDocs Number of Reversed Billing Documents
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_REVERSEDUTILSBILLINGDOCQUERY.MANDT == T001.MANDT
  • C_REVERSEDUTILSBILLINGDOCQUERY.COMPANYCODE == T001.BUKRS
Division
  • Client
  • Division
  • C_REVERSEDUTILSBILLINGDOCQUERY.MANDT == TSPA.MANDT
  • C_REVERSEDUTILSBILLINGDOCQUERY.DIVISION == TSPA.SPART
Portion
  • Client
  • Portion
  • C_REVERSEDUTILSBILLINGDOCQUERY.MANDT == TE420.MANDT
  • C_REVERSEDUTILSBILLINGDOCQUERY.UTILITIESPORTION == TE420.TERMSCHL
Reason for Reversal
  • Reason for Reversal
  • Client
  • C_REVERSEDUTILSBILLINGDOCQUERY.UTILSBILLGDOCREVERSALRSN == TE272.BCREASON
  • C_REVERSEDUTILSBILLINGDOCQUERY.MANDT == TE272.MANDT