C_Incompl_SalesDocWL_F2430

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_Incompl_SalesDocWL_F2430.
-- 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: CINCSDOCWLF2430

CREATE VIEW C_Incompl_SalesDocWL_F2430 AS
SELECT
  SalesDocument,
  SDDocumentCategory,
  SalesDocumentType,
  SoldToParty,
  PurchaseOrderByCustomer,
  CreatedByUser,
  CreationDate,
  TotalNetAmount,
  TransactionCurrency,
  _NumberOfIncompleteFields.NumberOfIncompleteFields AS NumberOfIncompleteFields,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  BindingPeriodValidityEndDate,
  RequestedDeliveryDate,
  OverallSDProcessStatus,
  HdrGeneralIncompletionStatus,
  HeaderDelivIncompletionStatus,
  HeaderBillgIncompletionStatus,
  OverallPricingIncompletionSts,
  OvrlItmGeneralIncompletionSts,
  OvrlItmDelivIncompletionSts,
  OvrlItmBillingIncompletionSts
FROM I_SalesDocument
INNER JOIN P_NmbrOfIncmpltFldForSDDoc AS _NumberOfIncompleteFields ON /* join condition not captured in parsed metadata */
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 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 E_SalesDocumentBasic AS _Extension ON SalesDocument = _Extension.SalesDocument  -- association [0..1]
;