C_DuplicateSalesDocument

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_DuplicateSalesDocument.
-- 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: CSDDPLSLSDOC
-- Parameters: P_DateFunction : datefunctionid

CREATE VIEW C_DuplicateSalesDocument AS
SELECT
  entity: { name: 'C_GregorianCalDateFuncVH', element: 'DateFunction' AS SDDocumentCategoryName,
  ltrim(DuplicateSalesDocument.DuplicateSalesDocumentGroup, '0') AS DuplicateSalesDocumentGroup0
FROM I_SalesDocument AS SalesDocument
INNER JOIN P_DuplicateSalesDocumentGrpg ON /* join condition not captured in parsed metadata */
INNER JOIN C_SglGregorianCalDateFunction ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_DuplicateSalesDocumentItem AS _Item ON SalesDocument = _Item.SalesDocument  -- association [0..*]
LEFT OUTER JOIN P_SalesDocumentItemCount AS _SalesDocumentItemCount ON SalesDocument = _SalesDocumentItemCount.SalesDocument  -- association [1..1]
LEFT OUTER JOIN C_DplSlsDocCatVH AS _SalesDocumentCategory ON SDDocumentCategory = _SalesDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN C_DplSlsDocTypeVH AS _SalesDocumentType ON SDDocumentCategory = _SalesDocumentType.SDDocumentCategory AND SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN C_SoldToValueHelp AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannel ON SalesOrganization = _DistributionChannel.SalesOrganization AND DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _OrganizationDivision ON SalesOrganization = _OrganizationDivision.SalesOrganization AND DistributionChannel = _OrganizationDivision.DistributionChannel AND OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOffice ON SalesOrganization = _SalesOffice.SalesOrganization AND DistributionChannel = _SalesOffice.DistributionChannel AND OrganizationDivision = _SalesOffice.OrganizationDivision AND SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroup ON SalesOffice = _SalesGroup.SalesOffice AND SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN C_ShipToPartyValueHelp AS _ShipToParty ON ShipToParty = _ShipToParty.Customer AND ShipToPartyAddressID = _ShipToParty.AddressID  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument = _Extension.SalesDocument  -- association [0..1]
;