CRMS4_IU_C_UBD

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 CRMS4_IU_C_UBD.
-- 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.

CREATE VIEW CRMS4_IU_C_UBD AS
SELECT
  UtilitiesBillingDocument AS belnr,
  CompanyCode AS bukrs,
  BusinessPartner AS gpartner,
  ContractAccount AS vkont,
  UtilitiesContract AS vertrag,
  UtilsBusTransactionType AS hvorg,
  UtilitiesBillingReason AS abrvorg,
  UtilsBillgPeriodStartDate AS begabrpe,
  UtilsBillgPeriodEndDate AS endabrpe,
  Division AS sparte,
  UtilsBillgSimulationReason AS simulation,
  UtilsBillgDocIsNotReleased AS tobreleasd,
  UtilsBillgDocReversalDate AS stornodat,
  UtilsBillgDocReversalRsn AS bcreason,
  UtilsBillgPeriodAllocationDate AS zuorddaa,
  UtilitiesPortion AS portion,
  ScheduledUtilitiesBillingDate AS abrdats,
  MeterReadingUnit AS ableinh,
  ScheduledMeterReadingDate AS adatsoll,
  ManualUtilsBillgDocCrtnRsn AS bergrund,
  MnlUtilsBillgDocIsReldForInvcg AS manbillrel,
  UtilitiesBillingRun AS billingrunno,
  UtilsBillgDocCreationDate AS erdat,
  UtilsBillgDocCreatedByUser AS ernam,
  UtilsBillgDocLastChangeDate AS aedat,
  UtilsBillgDocLastChangedByUser AS aenam,
  AuthorizationGroup AS begru,
  UtilitiesAccountClass AS ktoklasse,
  UtilsPreviousBillingDocument AS belnralt,
  AltvContractAcctForCollvBills AS abwvk,
  UtilitiesAccountDetnCode AS kofiz,
  UtilsPortionScheduleRecordDate AS ptermtdat,
  UtilsBillgDocHasOutsrtgData AS ercho_v
FROM CRMS4_IU_I_UBD
;