C_SetlMgmtJrnlCostDistrBizVol

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_SetlMgmtJrnlCostDistrBizVol.
-- 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_SetlMgmtJrnlCostDistrBizVol AS
SELECT
  JournalEntry.SourceLedger AS SourceLedger,
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.LedgerGLLineItem AS LedgerGLLineItem,
  ConditionContract.ConditionContract AS ConditionContract,
  ConditionContractItem.ConditionDocumentItem AS ConditionContractItem,
  JournalEntry.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntry.ReferenceDocumentContext AS ReferenceDocumentContext,
  JournalEntry.ReferenceDocument AS ReferenceDocument,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.ControllingBusTransacType AS ControllingBusTransacType,
  JournalEntry.AssignmentReference AS AssignmentReference,
  JournalEntry.LastChangeDateTime AS LastChangeDateTime,
  ConditionContractItem.SettlementDistributionRatio AS SettlementDistributionRatio,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntry.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntry.ControllingObjectCurrency AS ControllingObjectCurrency,
  JournalEntry.AmountInObjectCurrency AS AmountInObjectCurrency,
  JournalEntry.AccountAssignmentType AS AccountAssignmentType,
  JournalEntry.GLAccount AS GLAccount,
  JournalEntry.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  JournalEntry.Product AS Product,
  JournalEntry.BusinessArea AS BusinessArea,
  JournalEntry.SettlmtRefDocCat AS SettlmtRefDocCat,
  JournalEntry.SettlmtRefDoc AS SettlmtRefDoc,
  JournalEntry.SettlmtRefDocFiscalYear AS SettlmtRefDocFiscalYear,
  JournalEntry.SettlmtRefDocCompanyCode AS SettlmtRefDocCompanyCode,
  _SettlmtMgmtSenderSupplier.Supplier AS SettlmtMgmtSenderSupplier,
  _SettlmtMgmtSenderSupplier.SalesOrganization AS SalesOrganization,
  _SettlmtMgmtSenderSupplier.DistributionChannel AS DistributionChannel,
  _SettlmtMgmtSenderSupplier.Division AS Division,
  cast( _SettlmtMgmtReceiverCustomer.Customer as wlf_bukrs_kunnr_receiving preserving type ) AS SettlmtMgmtReceiverCustomer,
  cast( ConditionContractItem.CompanyCode as wlf_bukrs_receiving preserving type ) AS ReceiverCompanyCode,
  cast( ConditionContractItem.SettlmtMgmtOrder as wlf_aufnr_receiving preserving type ) AS ReceiverOrder,
  cast( ConditionContractItem.WBSElementInternalID as wlf_ps_psp_pnr_receiving preserving type ) AS ReceiverWBSElementInternalID,
  cast( ConditionContractItem.CostCenter as wlf_kostl_receiving preserving type ) AS ReceiverCostCenter
FROM R_SetlMgmtUnivJrnlEntrBizVol AS JournalEntry
INNER JOIN R_ConditionContract AS ConditionContract ON /* join condition not captured in parsed metadata */
INNER JOIN R_ConditionDocumentItem AS ConditionContractItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SetlMgmtCoCodeSettlmtRprstn AS _SettlmtMgmtSenderSupplier ON JournalEntry.CompanyCode = _SettlmtMgmtSenderSupplier.CompanyCode  -- association [0..1]
LEFT OUTER JOIN R_SetlMgmtCoCodeSettlmtRprstn AS _SettlmtMgmtReceiverCustomer ON ConditionContractItem.CompanyCode = _SettlmtMgmtReceiverCustomer.CompanyCode  -- association [0..1]
LEFT OUTER JOIN R_SettlmtDoc AS _SettlmtDoc ON _SettlmtDoc.SettlmtDoc = JournalEntry.ReferenceDocument AND JournalEntry.ReferenceDocumentType = 'WBRK' AND _SettlmtDoc.CustSettlmtCompanyCode = JournalEntry.CompanyCode  -- association [0..1]
LEFT OUTER JOIN P_StlMnBzVlSetldSetlDocRlvtSel AS _StlMnBzVlSetldSetlDocRlvtSel ON _StlMnBzVlSetldSetlDocRlvtSel.ConditionContract = ConditionContract.ConditionContract AND _StlMnBzVlSetldSetlDocRlvtSel.SetldBusVolDocCategory = '07' AND _StlMnBzVlSetldSetlDocRlvtSel.SetldBusVolDocKey1 = JournalEntry.AccountingDocument AND _StlMnBzVlSetldSetlDocRlvtSel.SetldBusVolDocKey2 = JournalEntry.CompanyCode AND _StlMnBzVlSetldSetlDocRlvtSel.SetldBusVolDocKey3 = JournalEntry.FiscalYear AND _StlMnBzVlSetldSetlDocRlvtSel.SetldBusVolDocItem = JournalEntry.LedgerGLLineItem AND _StlMnBzVlSetldSetlDocRlvtSel.SettlmtDocIsCanceled <> 'X' AND _StlMnBzVlSetldSetlDocRlvtSel.SettlmtMgmtAcctgTransfSts <> 'R'  -- association [0..1]
;