C_SalesContractWl_F1851

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_SalesContractWl_F1851.
-- 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: CSCONTRWLF1851

CREATE VIEW C_SalesContractWl_F1851 AS
SELECT
  SalesContract.SalesContract AS SalesContract,
  SalesContract.SoldToParty AS SoldToParty,
  SalesContract._SoldToParty.CustomerName AS SoldToPartyFullName,
  cast('' as ad_namtext ) AS SoldToPartyName,
  SalesContract.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesContract.SalesContractValidityStartDate AS SalesContractValidityStartDate,
  SalesContract.SalesContractValidityEndDate AS SalesContractValidityEndDate,
  SalesContract.OverallSDProcessStatus AS OverallSDProcessStatus,
  SalesContract.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  SalesContract.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  SalesContract.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  SalesContract.ContractDownPaymentStatus AS ContractDownPaymentStatus,
  SalesContract.TransactionCurrency AS TransactionCurrency,
  SalesContract._TransactionCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  SalesContract.TotalNetAmount AS TotalNetAmount,
  SalesContract.SalesContractDate AS SalesContractDate,
  SalesContract.LastChangeDate AS LastChangeDate,
  SalesContract.SalesContractType AS SalesContractType,
  _SalesDocumentType.SalesDocumentTypeName AS SalesContractTypeName,
  SalesContract.SalesOrganization AS SalesOrganization,
  SalesContract.DistributionChannel AS DistributionChannel,
  SalesContract.OrganizationDivision AS OrganizationDivision,
  SalesContract.SalesOffice AS SalesOffice,
  SalesContract.SalesGroup AS SalesGroup,
  SalesContract.CreatedByUser AS CreatedByUser,
  SalesContract.CreationDate AS CreationDate,
  SalesContract.LastChangedByUser AS LastChangedByUser,
  cast(SalesContract.OverallTrdCmplncEmbargoSts as totembargochksts preserving type) AS OverallTrdCmplncEmbargoSts,
  cast(SalesContract.OvrlTrdCmplncSnctndListChkSts as totwatchlistscrngchksts preserving type) AS OvrlTrdCmplncSnctndListChkSts,
  cast( ' ' as abgru_va) AS SalesDocumentRjcnReason,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2
FROM I_SalesContract AS SalesContract
LEFT OUTER JOIN C_SoldToValueHelp AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- 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 _Division ON SalesOrganization = _Division.SalesOrganization AND DistributionChannel = _Division.DistributionChannel AND OrganizationDivision = _Division.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 C_SalesContractTypeValueHelp AS _SalesDocumentType ON SalesContractType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocAllowedRjcnRsn AS _SalesDocumentRjcnReason ON SalesOrganization = _SalesDocumentRjcnReason.SalesOrganization AND SalesContractType = _SalesDocumentRjcnReason.SalesDocumentType  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocRjcnReason ON SalesDocumentRjcnReason = _SalesDocRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_ContractSubsequentDocType AS _SubsequentDocType ON SalesContractType = _SubsequentDocType.SourceSalesDocumentType  -- association [0..*]
LEFT OUTER JOIN P_Contractwl_Duedays AS _SalesContractDueDays ON SalesContract = _SalesContractDueDays.SalesContract  -- association [1..1]
LEFT OUTER JOIN C_SalesDocumentItemWl AS _SalesDocumentItemWl ON SalesContract = _SalesDocumentItemWl.SalesDocument  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesContract = _Extension.SalesDocument  -- association [1]
;