P_CalculatedAllwncCustomers

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_CalculatedAllwncCustomers.
-- 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: PCALALLWNCCUST
-- Parameters: P_KeyDate : sydate

CREATE VIEW P_CalculatedAllwncCustomers AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  SpecialGLCode,
  cast(substring(AssignmentReference, 1, 10) as fis_kunnr) AS ReferencedCustomer,
  cast(substring(AssignmentReference, 1, 10) as farp_belnr_d) AS ReferencedDocument,
  cast(substring(AssignmentReference, 11, 3) as fis_buzei ) AS ReferencedDocumentItem,
  cast(substring(AssignmentReference, 14, 4) as fis_gjahr ) AS ReferencedFiscalYear,
  AccountingDocumentType,
  PostingDate,
  cast('00000000' as farp_netdt) AS NetDueDate,
  GLAccount,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  AssignmentReference
FROM I_OperationalAcctgDocItem
LEFT OUTER JOIN P_CalculatedAllwncCrdtAccount AS _DoubtfulReceivables ON _DoubtfulReceivables.CreditGLAccount = GLAccount  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _ReferencedCustomer ON _ReferencedCustomer.Customer = ReferencedCustomer  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _ReferencedDocument ON _ReferencedDocument.AccountingDocument = ReferencedDocument AND _ReferencedDocument.CompanyCode = CompanyCode AND _ReferencedDocument.FiscalYear = ReferencedFiscalYear AND _ReferencedDocument.AccountingDocumentItem = ReferencedDocumentItem  -- association [0..1]
;