C_CreditMemoReqWorkflowDetail

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_CreditMemoReqWorkflowDetail.
-- 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: CMRWFDETAIL

CREATE VIEW C_CreditMemoReqWorkflowDetail AS
SELECT
  CreditMemoRequest.CreditMemoRequest AS CreditMemoRequest,
  concat_with_space(concat_with_space(_CreditMemoRequestType._Text[1: Language=$session.system_language].SalesDocumentTypeName, '-', 1), ltrim(CreditMemoRequest.CreditMemoRequest,'0'), 1) as DocumentTitle AS CreditMemoRequest01asDocumentTitle,
  _SoldToParty.CustomerName AS CustomerName,
  SoldToParty,
  _StandardPartner._ShipToParty.CustomerName AS ShipToPartyName,
  _StandardPartner.ShipToParty AS ShipToParty,
  CreditMemoRequestPartner._DfltAddrRprstn.CityName AS CityName,
  CreditMemoRequestPartner._DfltAddrRprstn._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  CreditMemoRequestPartner._DfltAddrRprstn.Country AS Country,
  PurchaseOrderByCustomer,
  TransactionCurrency,
  TotalNetAmount,
  _SDDocumentReason._Text[1: Language=$session.system_language ].SDDocumentReasonText AS SDDocumentReasonText,
  SDDocumentReason,
  _CreditMemoReqApprovalReason._SDApprovalReasonT[1: Language=$session.system_language ].SDApprovalReasonName AS SDApprovalReasonName,
  CreditMemoReqApprovalReason,
  _TotalCreditCheckStatus._Text[1: Language=$session.system_language ].TotalCreditCheckStatusDesc AS TotalCreditCheckStatusDesc,
  TotalCreditCheckStatus,
  HeaderBillingBlockReason,
  _HeaderBillingBlockReason._Text[1: Language=$session.system_language ].BillingBlockReasonDescription AS BillingBlockReasonDescription,
  _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,
  _CreatedByUser.UserDescription AS UserName,
  CreatedByUser,
  CreationDate,
  _LastChangedByUser.UserDescription AS UserDescription,
  LastChangedByUser,
  LastChangeDateTime,
  CreditMemoRequestType,
  _StandardPartner._ShipToParty AS _ShipToParty
FROM I_CreditMemoRequest AS CreditMemoRequest
LEFT OUTER JOIN C_CreditMemoReqWorkflowItmDets AS _CMRWorkflowItem ON CreditMemoRequest = _CMRWorkflowItem.CreditMemoRequest  -- association [0..*]
;