C_SalesContractWrkflwInbox

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_SalesContractWrkflwInbox.
-- 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: CCONTRWFIN

CREATE VIEW C_SalesContractWrkflwInbox AS
SELECT
  SalesContract.SalesContract AS SalesContract,
  concat_with_space(concat_with_space(_SalesContractType._Text[1: Language=$session.system_language].SalesDocumentTypeName, '-', 1), ltrim(SalesContract.SalesContract,'0'), 1) as DocumentTitle AS SalesContract01asDocumentTitle,
  _SoldToParty.CustomerName AS CustomerName,
  SoldToParty,
  _ShipToParty.CustomerName AS ShipToPartyName,
  _SalesContractPartner.Customer AS ShipToParty,
  concat(concat(_SalesContractPartner._DfltAddrRprstn.CityName, '/'), _SalesContractPartner._DfltAddrRprstn.Country) AS CityName,
  PurchaseOrderByCustomer,
  TransactionCurrency,
  TotalNetAmount,
  _SDDocumentReason._Text[1: Language=$session.system_language ].SDDocumentReasonText AS SDDocumentReasonText,
  SDDocumentReason,
  SalesContractApprovalReason,
  _SalesOrganization._Text[1: Language=$session.system_language ].SalesOrganizationName AS SalesOrganizationName,
  SalesOrganization,
  _DistributionChannel._Text[1: Language=$session.system_language ].DistributionChannelName AS DistributionChannelName,
  DistributionChannel,
  _OrganizationDivision._Text[1: Language=$session.system_language ].DivisionName AS DivisionName,
  OrganizationDivision,
  SalesContractValidityStartDate,
  SalesContractValidityEndDate,
  _CreatedByUser.UserDescription AS UserName,
  CreatedByUser,
  CreationDate,
  _LastChangedByUser.UserDescription AS UserDescription,
  LastChangedByUser,
  LastChangeDateTime,
  SalesContractType
FROM I_SalesContract AS SalesContract
LEFT OUTER JOIN C_SalesContractItemWrkflwInbox AS _SalesContractWorkflowInItem ON SalesContract = _SalesContractWorkflowInItem.SalesContract  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON _SalesContractPartner.Customer = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesContract = _Extension.SalesDocument  -- association [0..1]
;