I_UtilitiesSimulatorItem

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 I_UtilitiesSimulatorItem.
-- 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: IITEMTBR

CREATE VIEW I_UtilitiesSimulatorItem AS
SELECT
  ISU_BR_SimulationScenario,
  lpad( UtilitiesBillingDocument, 12, '0' ) AS UtilitiesBillingDocument,
  ISU_BR_BillingOriglPrintDoc,
  ISU_BR_BillingSimulatedPrntDoc,
  ISU_BR_SequentialItemNumber,
  PostingDate,
  UtilitiesInstallation,
  UtilitiesContract,
  BusinessPartner,
  ISU_BR_BillgPeriodStartDate,
  ISU_BR_BillingPeriodEndDate,
  ISU_BR_BillingLineFrom,
  ISU_BR_BillgDocLineItmTypeFrom,
  ISU_BR_TransactionKeyFrom,
  ISU_BR_BillingOriglNetAmt,
  OriginalCostCriticality,
  ISU_BR_BillingLineTo,
  ISU_BR_BillgDocLineItmTypeTo,
  ISU_BR_TransactionKeyTo,
  ISU_BR_BillingSimulatedNetAmt,
  ActualCostCriticality,
  ISU_BR_BillingDiffNetAmount,
  TotalCostCriticality,
  ISU_BR_PreSortingItemFrom,
  ISU_BR_PreSortingItemTo,
  ISU_BR_MainTransactionTo,
  ISU_BR_MainTransactionFrom,
  ISU_BR_SubTransactionFrom,
  ISU_BR_SubTransactionTo,
  CAPostingDocument,
  ISU_BR_ContractAcctPostgStatus,
  ISU_BR_PostStatusDescription,
  ISU_BR_RejectStatusDescription,
  PostingStatusCriticality,
  ISU_BR_ContractRejectStatus,
  ISU_BR_UtilitiesCurrency,
  ISU_BR_UtilitiesDocumentType,
  CAAuthorizationGroup
FROM P_UtilitiesSimulatorItemT
;