C_OutsrtdUtilsInvcgDocument

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_OutsrtdUtilsInvcgDocument.
-- 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 C_OutsrtdUtilsInvcgDocument AS
SELECT
  UtilsInvoicingDocumentTP.UtilitiesInvoicingDocument AS UtilitiesInvoicingDocument,
  UtilsInvoicingDocumentTP.NetDueDate AS NetDueDate,
  UtilsInvoicingDocumentTP.PostingDate AS PostingDate,
  UtilsInvoicingDocumentTP.DocumentDate AS DocumentDate,
  cast(UtilsInvoicingDocumentTP.TotalAmountInTransactionCrcy as e_outsrtgamtinvcg_vdm preserving type) AS TotalAmountInTransactionCrcy,
  UtilsInvoicingDocumentTP.TransactionCurrency AS TransactionCurrency,
  UtilsInvoicingDocumentTP.BusinessPartner AS BusinessPartner,
  UtilsInvoicingDocumentTP._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  UtilsInvoicingDocumentTP.CAReconciliationKey AS CAReconciliationKey,
  UtilsInvoicingDocumentTP.UtilitiesPortion AS UtilitiesPortion,
  UtilsInvoicingDocumentTP.ContractAccount AS ContractAccount,
  cast(_ContractAccountHeader.ContractAccountCategory as e_contracctcategory_vdm preserving type) AS ContractAccountCategory,
  _ContractAccountHeader.CAApplicationArea AS CAApplicationArea,
  cast(ContractAccountPartner.CAAlternativeInvoiceRecipient as e_altinvrecipient_vdm preserving type) AS CAAlternativeInvoiceRecipient,
  cast(ContractAccountPartner.AltvContractAcctForCollvBills as e_collvbillacct_vdm preserving type) AS AltvContractAcctForCollvBills,
  cast(ContractAccountPartner.CAAccountDeterminationCode as e_kofiz_ca_vdm preserving type) AS CAAccountDeterminationCode,
  _UtilsInvcgDocOutsrtgDataCntr._UtilsInvcgDocOutsrtgData.UtilsOutsrtdInvcgDocDvtgValue AS UtilsOutsrtdInvcgDocDvtgValue,
  _UtilsInvcgDocOutsrtgDataCntr._UtilsInvcgDocOutsrtgData.UtilitiesInvoicingCheck AS UtilitiesInvoicingCheck,
  _UtilsInvcgDocOutsrtgDataRsn._UtilsInvcgDocOutsrtgData.UtilsInvcgOutsortingReason AS UtilsInvcgOutsortingReason,
  UtilsInvoicingDocumentTP.AuthorizationGroup AS AuthorizationGroup,
  cast(I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCase as e_clarificationcase_vdm) AS BPEMCase,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCaseCurrentProcessor AS BPEMCaseCurrentProcessor,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase._User.UserDescription AS UserDescription,
  cast(I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCaseCategory as e_clarcasecategory_vdm preserving type) AS BPEMCaseCategory,
  cast(I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCasePreviousProcessor as e_clarcaseprevproc_vdm preserving type) AS BPEMCasePreviousProcessor,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase._PreviousUser.UserDescription AS LastChangedByUserDescription,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMBusinessProcessCode AS BPEMBusinessProcessCode,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCaseForwardingReason AS BPEMCaseForwardingReason,
  cast(I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCaseCreationDate as e_clarcasecreationdate_vdm preserving type) AS BPEMCaseCreationDate,
  cast(I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCaseDueDate as e_clarcaseduedate_vdm preserving type) AS BPEMCaseDueDate,
  cast(I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCaseOriginalDate as e_clarcaseorigdate_vdm preserving type) AS BPEMCaseOriginalDate,
  cast(I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCasePriority as e_clarcasepriority_vdm preserving type) AS BPEMCasePriority,
  cast(I_UtilsInvcgLtstBPEMCase._OpenBPEMCase.BPEMCaseStatus as e_clarcasestatus_vdm) AS BPEMCaseStatus,
  UtilsInvoicingDocumentTP._BusinessPartner AS _BusinessPartner,
  UtilsInvoicingDocumentTP._UtilitiesPortion AS _UtilitiesPortion,
  ContractAccountPartner._AltvInvoiceRecipient AS _AltvInvoiceRecipient,
  ContractAccountPartner._AltvContrAcc AS _AltvContrAcc,
  ContractAccountPartner._AcctDetnCode AS _AcctDetnCode,
  _ContractAccountHeader._Category AS _Category,
  _UtilsInvcgDocOutsrtgDataCntr._UtilsInvcgDocOutsrtgData._UtilitiesInvoicingCheck AS _UtilitiesInvoicingCheck,
  _UtilsInvcgDocOutsrtgDataRsn._UtilsInvcgDocOutsrtgData._UtilsInvcgMnlOutsortingRsn AS _UtilsInvcgMnlOutsortingRsn,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase._BPEMBusinessProcessCode AS _BPEMBusinessProcessCode,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase._BPEMCaseCategory AS _BPEMCaseCategory,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase._BPEMCasePriority AS _BPEMCasePriority,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase._User AS _User,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase._PreviousUser AS _PreviousUser,
  I_UtilsInvcgLtstBPEMCase._OpenBPEMCase._BPEMCaseForwardReason AS _BPEMCaseForwardReason
FROM I_UtilsInvoicingDocumentTP AS UtilsInvoicingDocumentTP
INNER JOIN I_ContractAccountPartner AS ContractAccountPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilsInvcgDocOutsrtgDataCntr AS UtilsInvcgDocOutsrtgDataCntr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_BPEMCaseTP AS _BPEMCaseTP ON ContractAccount = _BPEMCaseTP.BPEMCaseMainObject AND _BPEMCaseTP.BPEMCaseMainObjectType = 'ISUACCOUNT' AND _BPEMCaseTP.BPEMBusinessProcessCode = 'EIN00001'  -- association [0..*]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_UtilsInvcgDocOutsrtgDataCntr AS _UtilsInvcgDocOutsrtgDataCntr ON UtilitiesInvoicingDocument = _UtilsInvcgDocOutsrtgDataCntr.UtilitiesInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN I_UtilsInvcgDocOutsrtgDataRsn AS _UtilsInvcgDocOutsrtgDataRsn ON UtilitiesInvoicingDocument = _UtilsInvcgDocOutsrtgDataRsn.UtilitiesInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN C_UtilsInvcgDocOutsrtgData AS _UtilsInvcgDocOutsrtgData ON UtilitiesInvoicingDocument = _UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument  -- association [0..*]
LEFT OUTER JOIN C_UtilsInvcgDocBillingData AS _UtilsInvcgDocBillingData ON UtilitiesInvoicingDocument = _UtilsInvcgDocBillingData.UtilitiesInvoicingDocument  -- association [1..*]
LEFT OUTER JOIN C_UtilsInvcgDocContractData AS _UtilsInvcgDocContractData ON UtilitiesInvoicingDocument = _UtilsInvcgDocContractData.UtilitiesInvoicingDocument  -- association [1..*]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_OpenBPEMCaseStatusVH AS _OpenBPEMCaseStatus ON BPEMCaseStatus = _OpenBPEMCaseStatus.BPEMCaseStatus  -- association [0..1]
;