P_AR_LengthOfRefDoc

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_AR_LengthOfRefDoc.
-- 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: PLENREFDOC

CREATE VIEW P_AR_LengthOfRefDoc AS
SELECT
  I_AccountingDocument.CompanyCode AS CompanyCode,
  I_AccountingDocument.AccountingDocument AS AccountingDocument,
  I_AccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  I_AccountingDocument.FiscalYear AS FiscalYear,
  I_AR_DocumentTypeClass.AccountingDocumentType AS AccountingDocumentType,
  I_AR_DocumentTypeClass.DocumentClass AS DocumentClass,
  length (I_AccountingDocument.DocumentReferenceID ) AS refdoc,
  substring(I_AccountingDocument.DocumentReferenceID,2,4) AS subsbl,
  substring(I_AccountingDocument.DocumentReferenceID,1,4) as subsbl1 AS CompanyCodeasCompanyCode,
  case when I_SalesOrganization.ArgentinaDeliveryDateEvent = '1' then substring(I_DeliveryDocument.ActualGoodsMovementDate,1,4) else case when I_SalesOrganization.ArgentinaDeliveryDateEvent = '3' then substring(I_DeliveryDocument.CreationDate,1,4) end end as Fiscalyear AS CreationDate14endendasFiscalyear,
  case when I_SalesOrganization.ArgentinaDeliveryDateEvent = '1' then I_DeliveryDocument.ActualGoodsMovementDate else case when I_SalesOrganization.ArgentinaDeliveryDateEvent = '3' then I_DeliveryDocument.CreationDate end end as ReportingDate AS CreationDateendendasReportingDate,
  I_BillingDocumentBasic.BillingDocumentDate AS ReportingDate,
  substring(I_BillingDocumentBasic.DocumentReferenceID,1,4) AS subsbl1
FROM I_AccountingDocument
INNER JOIN I_AR_DocumentTypeClass ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesOrganization ON /* join condition not captured in parsed metadata */
INNER JOIN I_DeliveryDocumentType ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocumentType ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_DeliveryDocument, I_BillingDocumentBasic
;