C_UtilsInvcgDocBillingData

Billing Data for Invoicing Document | view: CEOUTINVDOCBLLGD | Extraction: Not supported | Component: Invoicing
Tables used: ERCH, ERDK, TE417, EUITRANS, EUIINSTLN, DBERCHZ4, ERCHC, DBERCHZ3, DBERCHZ1, ERDO, ADCP, ADRC, DFKKLOCKS, TFK001G, T001, TKA02, FKKVK, FKKVKP, IFLOT, ILOA, EVER, EANL, EANLH, TE420, EVBS
Column Name Description
UtilitiesInvoicingDocument Invoicing Document
UtilitiesBillingDocument Number of Billing Document
Column Name Description
💲 Transaction Currency (UtilsBillgDocTransactionCrcy):
UtilsBillgDocTotalNetAmt Total Net Amount for Billing Document
Column Name Description
Column Name Description
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
UtilsBillgPeriodStartDate Billing Period Start
UtilsBillgPeriodEndDate Billing Period End
ScheduledUtilitiesBillingDate Scheduled Billing Date
SchedldUtilsInvcgPrintoutDate Scheduled Invoice Print Date
ScheduledMeterReadingDate Scheduled Meter Reading Date
UtilsBillgDocCreationDate Document Date
Column Name Description
UtilitiesBillingReason Billing Reason Show values
UtilsContrSpcfcBdgtBillgCycle Overriding Budget Billing Cycle Show values
UtilsDefaultBdgtBillgCycle Budget Billing Cycle Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
ContractAccount Contract Account Number VKONT_KK
ContractAccountName Description of Contract Account TEXT35
UtilitiesContract Contract VERTRAG
MeterReadingUnit Meter Reading Unit ABLEINHEIT
UtilitiesAccountClass Account Class KTOKLASSE
UtilsExternalPointOfDelivery Point of Delivery ID EXT_UI
UtilsPostalAddressFormatted null
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Address Number
  • ?
  • ?
  • Address Number
  • Client
  • C_UTILSINVCGDOCBILLINGDATA.[column in domain "AD_NATION"] == ADRC.NATION
  • C_UTILSINVCGDOCBILLINGDATA.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_UTILSINVCGDOCBILLINGDATA.ADDRESSID == ADRC.ADDRNUMBER
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == ADRC.CLIENT
Company Code
  • Company Code
  • Client
  • C_UTILSINVCGDOCBILLINGDATA.COMPANYCODE == T001.BUKRS
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == T001.MANDT
Account Determination Code
  • Company Code
  • Account Determination Code
  • Client
  • Division
  • C_UTILSINVCGDOCBILLINGDATA.COMPANYCODE == TE097.BUKRS
  • C_UTILSINVCGDOCBILLINGDATA.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == TE097.MANDT
  • C_UTILSINVCGDOCBILLINGDATA.DIVISION == TE097.SPARTE
Billing Class
  • Billing Class
  • Client
  • C_UTILSINVCGDOCBILLINGDATA.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == EAKLASSE.MANDT
Portion
  • Portion
  • Client
  • C_UTILSINVCGDOCBILLINGDATA.UTILITIESPORTION == TE420.TERMSCHL
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == TE420.MANDT
Rate Category
  • Rate Category
  • Client
  • C_UTILSINVCGDOCBILLINGDATA.UTILITIESRATECATEGORY == ETTA.TARIFTYP
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == ETTA.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_UTILSINVCGDOCBILLINGDATA.UTILSBILLGDOCTRANSACTIONCRCY == TCURC.WAERS
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == TCURC.MANDT
Outsorting Reason
  • Outsorting Reason
  • Client
  • C_UTILSINVCGDOCBILLINGDATA.UTILSBILLGOUTSORTINGREASON == TE127.MANOUTSORT
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == TE127.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_UTILSINVCGDOCBILLINGDATA.MANDT == TESPT.MANDT
  • C_UTILSINVCGDOCBILLINGDATA.DIVISION == TESPT.SPARTE