C_UtilsContrToBeBlldInvcdAnlys

DDL: C_UTILSCONTRTOBEBLLDINVCDANLYS SQL: CECONTRTBBILINV Type: view CONSUMPTION
63 Fields 1 Data Sources 1 Associations

Analysis of Contract to Be Billed and Invoiced

C_UtilsContrToBeBlldInvcdAnlys is a Consumption CDS View that provides data about "Analysis of Contract to Be Billed and Invoiced" in SAP S/4HANA. It reads from 1 data source (I_UtilsContrToBeBlldInvcdAnlys) and exposes 63 fields with key fields UtilitiesContract, ScheduledUtilitiesBillingDate, UtilitiesPortion, ScheduledMeterReadingDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_UtilsContrToBeBlldInvcdAnlys UtilsContrToBeBlldInvcdAnlys from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ContractAccountPartner _ContractAccountPartner $projection.ContractAccount = _ContractAccountPartner.ContractAccount and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner

Annotations (10)

NameValueLevelField
EndUserText.label Analysis of Contract to Be Billed and Invoiced view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CECONTRTBBILINV view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.headerInfo.typeName {@i18n>@CONTR_TOBE_BLLD_INVCD} view
UI.headerInfo.typeNamePlural {@i18n>@CONTRS_TOBE_BLLD_INVCD} view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_UtilsContrToBeBlldInvcdAnlys UtilitiesContract
KEY ScheduledUtilitiesBillingDate I_UtilsContrToBeBlldInvcdAnlys ScheduledUtilitiesBillingDate
KEY UtilitiesPortion I_UtilsContrToBeBlldInvcdAnlys UtilitiesPortion
KEY ScheduledMeterReadingDate I_UtilsContrToBeBlldInvcdAnlys ScheduledMeterReadingDate
UtilitiesPortionName
BusinessPartner I_UtilsContrToBeBlldInvcdAnlys BusinessPartner Issuing Authority
BusinessPartnerName
ContractAccount I_UtilsContrToBeBlldInvcdAnlys ContractAccount Contract Acct
ContractAccountName
UtilsBillgBlockReason I_UtilsContrToBeBlldInvcdAnlys UtilsBillgBlockReason
UtilsBillgBlockReasonName
UtilsBillgUnblockReason I_UtilsContrToBeBlldInvcdAnlys UtilsBillgUnblockReason
UtilsBillgUnblockReasonName
CompanyCode I_UtilsContrToBeBlldInvcdAnlys CompanyCode Receiver Company Code
CompanyCodeName
Division I_UtilsContrToBeBlldInvcdAnlys Division Internal Division ID
DivisionName
UtilitiesInstallation I_UtilsContrToBeBlldInvcdAnlys UtilitiesInstallation
UtilitiesAccountDetnCode I_UtilsContrToBeBlldInvcdAnlys UtilitiesAccountDetnCode
UtilitiesAccountDetnCodeName
MeterReadingUnit I_UtilsContrToBeBlldInvcdAnlys MeterReadingUnit
MeterReadingUnitName
UtilitiesMoveInDate I_UtilsContrToBeBlldInvcdAnlys UtilitiesMoveInDate
UtilitiesMoveOutDate I_UtilsContrToBeBlldInvcdAnlys UtilitiesMoveOutDate
UtilitiesRateCategory I_UtilsContrToBeBlldInvcdAnlys UtilitiesRateCategory
UtilitiesRateCategoryName
UtilitiesBillingClass I_UtilsContrToBeBlldInvcdAnlys UtilitiesBillingClass
UtilitiesBillingClassName
AltvContractAcctForCollvBills I_UtilsContrToBeBlldInvcdAnlys AltvContractAcctForCollvBills Coll. Bill Acct
AltvContrAcctForCollvBillsName
CABusinessLockReason I_UtilsContrToBeBlldInvcdAnlys CABusinessLockReason Lock Reason
CAInvcgLockReasonName
UtilsContrToBeBlldType I_UtilsContrToBeBlldInvcdAnlys UtilsContrToBeBlldType
UtilsContrToBeBlldTypeName
UtilsContrToBeBlldDetsType I_UtilsContrToBeBlldInvcdAnlys UtilsContrToBeBlldDetsType
UtilsContrToBeBlldDetsTypeName
UtilsContrToBeInvcdPrgrs I_UtilsContrToBeBlldInvcdAnlys UtilsContrToBeInvcdPrgrs
UtilsContrToBeInvcdPrgrsTxt
UtilsContrToBeInvcdPrgrsSts I_UtilsContrToBeBlldInvcdAnlys UtilsContrToBeInvcdPrgrsSts
UtilsContrToBeInvcdPrgrsStsTxt
UtilsExternalPointOfDelivery
AuthorizationGroup I_UtilsContrToBeBlldInvcdAnlys AuthorizationGroup AuthorizGroup
NmbrOfUtilsContrToBeInvoiced I_UtilsContrToBeBlldInvcdAnlys NmbrOfUtilsContrToBeInvoiced
_UtilitiesPortion I_UtilsContrToBeBlldInvcdAnlys _UtilitiesPortion
_BusinessPartner I_UtilsContrToBeBlldInvcdAnlys _BusinessPartner
_UtilsBillgBlockReason I_UtilsContrToBeBlldInvcdAnlys _UtilsBillgBlockReason
_UtilsBillgUnblockReason I_UtilsContrToBeBlldInvcdAnlys _UtilsBillgUnblockReason
_CompanyCode I_UtilsContrToBeBlldInvcdAnlys _CompanyCode
_Division I_UtilsContrToBeBlldInvcdAnlys _Division
_UtilitiesInstallation I_UtilsContrToBeBlldInvcdAnlys _UtilitiesInstallation
_UtilsAccountDetnCode I_UtilsContrToBeBlldInvcdAnlys _UtilsAccountDetnCode
_MeterReadingUnit I_UtilsContrToBeBlldInvcdAnlys _MeterReadingUnit
_UtilitiesRateCategory I_UtilsContrToBeBlldInvcdAnlys _UtilitiesRateCategory
_UtilsBillingClass I_UtilsContrToBeBlldInvcdAnlys _UtilsBillingClass
_AltvContrAcc I_UtilsContrToBeBlldInvcdAnlys _AltvContrAcc
_CAInvcgLockReason I_UtilsContrToBeBlldInvcdAnlys _CAInvcgLockReason
_ContractAccountHeader I_UtilsContrToBeBlldInvcdAnlys _ContractAccountHeader
_UtilsContrToBeBlldType I_UtilsContrToBeBlldInvcdAnlys _UtilsContrToBeBlldType
_UtilsContrToBeBlldDetsType I_UtilsContrToBeBlldInvcdAnlys _UtilsContrToBeBlldDetsType
_UtilsContrToBeInvcdPrgrs I_UtilsContrToBeBlldInvcdAnlys _UtilsContrToBeInvcdPrgrs
_UtilsContrToBeInvcdPrgrsSts I_UtilsContrToBeBlldInvcdAnlys _UtilsContrToBeInvcdPrgrsSts
_UtilsInstIntAndExtPtOfDeliv I_UtilsContrToBeBlldInvcdAnlys _UtilsInstIntAndExtPtOfDeliv
_ContractAccountPartner _ContractAccountPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_UtilsContrToBeBlldInvcdAnlys.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CECONTRTBBILINV

CREATE VIEW C_UtilsContrToBeBlldInvcdAnlys AS
SELECT
  UtilsContrToBeBlldInvcdAnlys.UtilitiesContract AS UtilitiesContract,
  UtilsContrToBeBlldInvcdAnlys.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsContrToBeBlldInvcdAnlys.UtilitiesPortion AS UtilitiesPortion,
  UtilsContrToBeBlldInvcdAnlys.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilsContrToBeBlldInvcdAnlys._UtilitiesPortion.UtilitiesPortionName AS UtilitiesPortionName,
  UtilsContrToBeBlldInvcdAnlys.BusinessPartner AS BusinessPartner,
  UtilsContrToBeBlldInvcdAnlys._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  UtilsContrToBeBlldInvcdAnlys.ContractAccount AS ContractAccount,
  UtilsContrToBeBlldInvcdAnlys._ContractAccountHeader.ContractAccountName AS ContractAccountName,
  UtilsContrToBeBlldInvcdAnlys.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilsContrToBeBlldInvcdAnlys._UtilsBillgBlockReason._Text[1: Language = $session.system_language].UtilsBillgBlockReasonName AS UtilsBillgBlockReasonName,
  UtilsContrToBeBlldInvcdAnlys.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilsContrToBeBlldInvcdAnlys._UtilsBillgUnblockReason._Text[1: Language = $session.system_language].UtilsBillgUnblockReasonName AS UtilsBillgUnblockReasonName,
  UtilsContrToBeBlldInvcdAnlys.CompanyCode AS CompanyCode,
  UtilsContrToBeBlldInvcdAnlys._CompanyCode.CompanyCodeName AS CompanyCodeName,
  UtilsContrToBeBlldInvcdAnlys.Division AS Division,
  UtilsContrToBeBlldInvcdAnlys._Division._Text[1: Language = $session.system_language].DivisionName AS DivisionName,
  UtilsContrToBeBlldInvcdAnlys.UtilitiesInstallation AS UtilitiesInstallation,
  UtilsContrToBeBlldInvcdAnlys.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilsContrToBeBlldInvcdAnlys._UtilsAccountDetnCode._Text[1: Language = $session.system_language].UtilitiesAccountDetnCodeName AS UtilitiesAccountDetnCodeName,
  UtilsContrToBeBlldInvcdAnlys.MeterReadingUnit AS MeterReadingUnit,
  UtilsContrToBeBlldInvcdAnlys._MeterReadingUnit.MeterReadingUnitName AS MeterReadingUnitName,
  UtilsContrToBeBlldInvcdAnlys.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilsContrToBeBlldInvcdAnlys.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilsContrToBeBlldInvcdAnlys.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilsContrToBeBlldInvcdAnlys._UtilitiesRateCategory._UtilitiesRateCategoryText[1: Language = $session.system_language].UtilitiesRateCategoryName AS UtilitiesRateCategoryName,
  UtilsContrToBeBlldInvcdAnlys.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilsContrToBeBlldInvcdAnlys._UtilsBillingClass._UtilsBillingClassText[1: Language = $session.system_language].UtilitiesBillingClassName AS UtilitiesBillingClassName,
  UtilsContrToBeBlldInvcdAnlys.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
  UtilsContrToBeBlldInvcdAnlys._AltvContrAcc.ContractAccountName AS AltvContrAcctForCollvBillsName,
  UtilsContrToBeBlldInvcdAnlys.CABusinessLockReason AS CABusinessLockReason,
  UtilsContrToBeBlldInvcdAnlys._CAInvcgLockReason._CAInvcgLockReasonText[1: Language = $session.system_language].CAInvcgLockReasonName AS CAInvcgLockReasonName,
  UtilsContrToBeBlldInvcdAnlys.UtilsContrToBeBlldType AS UtilsContrToBeBlldType,
  UtilsContrToBeBlldInvcdAnlys._UtilsContrToBeBlldType._Text[1: Language = $session.system_language].UtilsContrToBeBlldTypeName AS UtilsContrToBeBlldTypeName,
  UtilsContrToBeBlldInvcdAnlys.UtilsContrToBeBlldDetsType AS UtilsContrToBeBlldDetsType,
  UtilsContrToBeBlldInvcdAnlys._UtilsContrToBeBlldDetsType._Text[1: Language = $session.system_language].UtilsContrToBeBlldDetsTypeName AS UtilsContrToBeBlldDetsTypeName,
  UtilsContrToBeBlldInvcdAnlys.UtilsContrToBeInvcdPrgrs AS UtilsContrToBeInvcdPrgrs,
  UtilsContrToBeBlldInvcdAnlys._UtilsContrToBeInvcdPrgrs._Text[1: Language = $session.system_language].UtilsContrToBeInvcdPrgrsTxt AS UtilsContrToBeInvcdPrgrsTxt,
  UtilsContrToBeBlldInvcdAnlys.UtilsContrToBeInvcdPrgrsSts AS UtilsContrToBeInvcdPrgrsSts,
  UtilsContrToBeBlldInvcdAnlys._UtilsContrToBeInvcdPrgrsSts._Text[1: Language = $session.system_language].UtilsContrToBeInvcdPrgrsStsTxt AS UtilsContrToBeInvcdPrgrsStsTxt,
  UtilsContrToBeBlldInvcdAnlys._UtilsInstIntAndExtPtOfDeliv.UtilsExternalPointOfDelivery AS UtilsExternalPointOfDelivery,
  UtilsContrToBeBlldInvcdAnlys.AuthorizationGroup AS AuthorizationGroup,
  UtilsContrToBeBlldInvcdAnlys.NmbrOfUtilsContrToBeInvoiced AS NmbrOfUtilsContrToBeInvoiced,
  UtilsContrToBeBlldInvcdAnlys._UtilitiesPortion AS _UtilitiesPortion,
  UtilsContrToBeBlldInvcdAnlys._BusinessPartner AS _BusinessPartner,
  UtilsContrToBeBlldInvcdAnlys._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilsContrToBeBlldInvcdAnlys._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilsContrToBeBlldInvcdAnlys._CompanyCode AS _CompanyCode,
  UtilsContrToBeBlldInvcdAnlys._Division AS _Division,
  UtilsContrToBeBlldInvcdAnlys._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsContrToBeBlldInvcdAnlys._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  UtilsContrToBeBlldInvcdAnlys._MeterReadingUnit AS _MeterReadingUnit,
  UtilsContrToBeBlldInvcdAnlys._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsContrToBeBlldInvcdAnlys._UtilsBillingClass AS _UtilsBillingClass,
  UtilsContrToBeBlldInvcdAnlys._AltvContrAcc AS _AltvContrAcc,
  UtilsContrToBeBlldInvcdAnlys._CAInvcgLockReason AS _CAInvcgLockReason,
  UtilsContrToBeBlldInvcdAnlys._ContractAccountHeader AS _ContractAccountHeader,
  UtilsContrToBeBlldInvcdAnlys._UtilsContrToBeBlldType AS _UtilsContrToBeBlldType,
  UtilsContrToBeBlldInvcdAnlys._UtilsContrToBeBlldDetsType AS _UtilsContrToBeBlldDetsType,
  UtilsContrToBeBlldInvcdAnlys._UtilsContrToBeInvcdPrgrs AS _UtilsContrToBeInvcdPrgrs,
  UtilsContrToBeBlldInvcdAnlys._UtilsContrToBeInvcdPrgrsSts AS _UtilsContrToBeInvcdPrgrsSts,
  UtilsContrToBeBlldInvcdAnlys._UtilsInstIntAndExtPtOfDeliv AS _UtilsInstIntAndExtPtOfDeliv
FROM I_UtilsContrToBeBlldInvcdAnlys AS UtilsContrToBeBlldInvcdAnlys
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [1..1]
;

Learn More