C_SalesDocumentByObjectStatus

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_SalesDocumentByObjectStatus.
-- 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: CSLSDOCBYOBJSTS

CREATE VIEW C_SalesDocumentByObjectStatus AS
SELECT
  SalesDocument.SalesDocument AS SalesDocument,
  SalesDocumentByMultObjSts.SalesDocumentItem AS SalesDocumentItem,
  SalesDocumentByMultObjSts.SystemStatusName AS SystemStatusName,
  SalesDocumentByMultObjSts.UserStatusName AS UserStatusName,
  SalesDocumentByMultObjSts.SystemStatusShortName AS SystemStatusShortName,
  SalesDocumentByMultObjSts.UserStatusShortName AS UserStatusShortName,
  SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocument.SoldToParty AS SoldToParty,
  cast(_SalesDocumentItem.Material as productnumber preserving type ) AS Material,
  SalesDocument.CreatedByUser AS CreatedByUser,
  SalesDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesDocument.CreationDate AS CreationDate,
  cast((case when SalesDocumentByMultObjSts.SalesDocumentItem = '000000' then SalesDocument.TotalNetAmount else _SalesDocumentItem.NetAmount end) as netwr_ap preserving type) AS NetAmount,
  cast((case when SalesDocumentByMultObjSts.SalesDocumentItem = '000000' then SalesDocument.TransactionCurrency else _SalesDocumentItem.TransactionCurrency end) as waerk preserving type) AS TransactionCurrency,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocument.OrganizationDivision AS OrganizationDivision,
  SalesDocument.SalesOffice AS SalesOffice,
  SalesDocument.SalesGroup AS SalesGroup,
  SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesDocument.OverallSDProcessStatus AS OverallSDProcessStatus
FROM I_SalesDocument AS SalesDocument
INNER JOIN P_SalesDocumentByMultObjSts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN C_Incompl_SalesDocCatVH AS _SalesDocumentCategory ON SDDocumentCategory = _SalesDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN C_Incompl_SalesDocTypeVH 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 I_MaterialStdVH AS _MaterialVH ON Material = _MaterialVH.Material  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- 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_OverallSDProcessStatus AS _OverallSDProcessStatus ON OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument = _Extension.SalesDocument  -- association [1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _ItemExtension ON SalesDocument = _ItemExtension.SalesDocument AND SalesDocumentItem = _ItemExtension.SalesDocumentItem  -- association [1]
;