C_SlsDocFlfllmntAnalyzer

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_SlsDocFlfllmntAnalyzer.
-- 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: CSOFANALYZER

CREATE VIEW C_SlsDocFlfllmntAnalyzer AS
SELECT
  SalesDocument.SalesDocument AS SalesDocument,
  FulfillmentStatus.OverallFulfillmentStatus AS OverallFulfillmentStatus,
  FulfillmentStatus.FulfillmentStatusInOrder AS FulfillmentStatusInOrder,
  FulfillmentStatus.FulfillmentStatusInSupply AS FulfillmentStatusInSupply,
  FulfillmentStatus.FulfillmentStatusInDelivery AS FulfillmentStatusInDelivery,
  FulfillmentStatus.FulfillmentStatusInTransit AS FulfillmentStatusInTransit,
  FulfillmentStatus.FulfillmentStatusInInvoice AS FulfillmentStatusInInvoice,
  FulfillmentStatus.FulfillmentStatusInAccounting AS FulfillmentStatusInAccounting,
  FulfillmentProcessPhase,
  SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocument.SalesDocumentProcessingType AS SalesDocumentProcessingType,
  SalesDocument.CreatedByUser AS CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  SalesDocument.LastChangedByUser AS LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserName,
  SalesDocument.CreationDate AS CreationDate,
  SalesDocument.LastChangeDate AS LastChangeDate,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocument.OrganizationDivision AS OrganizationDivision,
  SalesDocument.SalesGroup AS SalesGroup,
  SalesDocument.SalesOffice AS SalesOffice,
  SalesDocument.SoldToParty AS SoldToParty,
  cast(SoldToPartyAddressInfo.PartnerIsOneTimeAccount as isonetimeaccountsoldtoparty) AS SoldToPartyIsOneTimeAccount,
  SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  SalesDocument.TotalNetAmount AS TotalNetAmount,
  SalesDocument.TransactionCurrency AS TransactionCurrency,
  cast( 0 as slsdoc_totalamount) AS TotalGrossAmount,
  SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  SalesDocument.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
  cast(SalesDocument.OverallPurchaseConfStatus as totpurchaseconfsts preserving type ) AS OverallPurchaseConfStatus,
  SalesDocument.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  SalesDocument.DeliveryBlockReason AS DeliveryBlockReason,
  SalesDocument.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  cast( ' ' as abgru_va) AS SalesDocumentRjcnReason,
  SalesDocApprovalStatus,
  cast(SalesDocument.OverallChmlCmplncStatus as mon_tdd_total_pcsta preserving type) AS OverallChmlCmplncStatus,
  cast(SalesDocument.OverallDangerousGoodsStatus as mon_tdd_total_dgsta preserving type) AS OverallDangerousGoodsStatus,
  cast(SalesDocument.OverallSafetyDataSheetStatus as mon_tdd_total_sdssta preserving type) AS OverallSafetyDataSheetStatus,
  cast(SalesDocument.OverallTrdCmplncEmbargoSts as totembargochksts preserving type) AS OverallTrdCmplncEmbargoSts,
  cast(SalesDocument.OvrlTrdCmplncSnctndListChkSts as totwatchlistscrngchksts preserving type) AS OvrlTrdCmplncSnctndListChkSts,
  cast(SalesDocument.OvrlTrdCmplncLegalCtrlChkSts as totlglctrlchksts preserving type) AS OvrlTrdCmplncLegalCtrlChkSts,
  cast( '' as vcm_business_object_id ) AS ValueChainBusinessObject,
  cast( '' as vcm_value_chain_type ) AS ValueChainType,
  cast( '' as slsdocvalchnintegrationtext ) AS SlsDocValChnIntegrationText,
  SalesDocument.BusinessSolutionOrder AS BusinessSolutionOrder,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  _LastChangedByUser.UserDescription AS UserDescription,
  SalesDocument._SolutionOrder AS _SolutionOrderATAddedforCE2008
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannelVH ON SalesOrganization = _DistributionChannelVH.SalesOrganization AND DistributionChannel = _DistributionChannelVH.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _OrganizationDivisionVH ON SalesOrganization = _OrganizationDivisionVH.SalesOrganization AND DistributionChannel = _OrganizationDivisionVH.DistributionChannel AND OrganizationDivision = _OrganizationDivisionVH.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOfficeVH ON SalesOrganization = _SalesOfficeVH.SalesOrganization AND DistributionChannel = _SalesOfficeVH.DistributionChannel AND OrganizationDivision = _SalesOfficeVH.OrganizationDivision AND SalesOffice = _SalesOfficeVH.SalesOffice  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroupVH ON SalesOffice = _SalesGroupVH.SalesOffice AND SalesGroup = _SalesGroupVH.SalesGroup  -- association [0..1]
LEFT OUTER JOIN C_Overallsddocumentrjcnstatus AS _OverallSDDocRejectionStsVH ON OverallSDDocumentRejectionSts = _OverallSDDocRejectionStsVH.OverallSDDocumentRejectionSts  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument.SalesDocument = _Extension.SalesDocument  -- association [0..1]
;