P_UtilitiesSimulatorItemT

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 P_UtilitiesSimulatorItemT.
-- 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: PSIMUITEMTBR

CREATE VIEW P_UtilitiesSimulatorItemT AS
SELECT
  Item.scenario_id AS ISU_BR_SimulationScenario,
  Item.billing_document AS UtilitiesBillingDocument,
  Item.print_document AS ISU_BR_BillingOriglPrintDoc,
  Item.simulated_print_document AS ISU_BR_BillingSimulatedPrntDoc,
  Item.sequential_item AS ISU_BR_SequentialItemNumber,
  Item.posting_date AS PostingDate,
  Item.installation AS UtilitiesInstallation,
  Item.contract AS UtilitiesContract,
  Item.business_partner AS BusinessPartner,
  Item.begin_bill_period AS ISU_BR_BillgPeriodStartDate,
  Item.end_bill_period AS ISU_BR_BillingPeriodEndDate,
  Item.billing_line_item_from AS ISU_BR_BillingLineFrom,
  line_item_type_from AS ISU_BR_BillgDocLineItmTypeFrom,
  Item.transaction_key_from AS ISU_BR_TransactionKeyFrom,
  Item.original_net_amount AS ISU_BR_BillingOriglNetAmt,
  Item.billing_line_item_to AS ISU_BR_BillingLineTo,
  Item.line_item_type_to AS ISU_BR_BillgDocLineItmTypeTo,
  Item.transaction_key_to AS ISU_BR_TransactionKeyTo,
  Item.simulated_net_amount AS ISU_BR_BillingSimulatedNetAmt,
  Item.DiferenceNetAmount AS ISU_BR_BillingDiffNetAmount,
  Item.presort_billing_line_from AS ISU_BR_PreSortingItemFrom,
  Item.presort_billing_line_to AS ISU_BR_PreSortingItemTo,
  Item.main_transacion_from AS ISU_BR_MainTransactionFrom,
  Item.main_transacion_to AS ISU_BR_MainTransactionTo,
  Item.subtransaction_from AS ISU_BR_SubTransactionFrom,
  Item.subtransaction_to AS ISU_BR_SubTransactionTo,
  Item.fica_posting_document AS CAPostingDocument,
  fica_posting_status AS ISU_BR_ContractAcctPostgStatus,
  Text AS ISU_BR_PostStatusDescription,
  RejectionText AS ISU_BR_RejectStatusDescription,
  rejection_status AS ISU_BR_ContractRejectStatus,
  Item.currency AS ISU_BR_UtilitiesCurrencyAmount,
  Item.currency AS ISU_BR_UtilitiesCurrency,
  Item.document_type AS ISU_BR_UtilitiesDocumentType,
  CAAuthorizationGroup
FROM P_ISU_CSMLDOCIB_BR AS Item
INNER JOIN P_ISU_REJECT_DOMAIN_BR AS RejectDomain ON /* join condition not captured in parsed metadata */
INNER JOIN P_ISU_FICA_DOMAIN_BR AS FicaDomain ON /* join condition not captured in parsed metadata */
;