C_Creditmemorequestfs

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_Creditmemorequestfs.
-- 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: CCREDITMRFS

CREATE VIEW C_Creditmemorequestfs AS
SELECT
  CMR.CreditMemoRequest AS CreditMemoRequest,
  concat_with_space( CMR._CreditMemoRequestType._Text[1: Language=$session.system_language ].SalesDocumentTypeName, ltrim(CreditMemoRequest, '0'), 1 ) AS SalesDocumentTypeName,
  CreditMemoRequestType,
  CMR.SoldToParty AS SoldToParty,
  cast('' as ad_namtext ) AS SoldToPartyName,
  cast( CMR._Partner[PartnerFunction='WE'].Customer as kunwe ) AS ShipToParty,
  cast('' as ad_namtext ) AS ShipToPartyName,
  CMR.OverallSDProcessStatus AS OverallSDProcessStatus,
  CMR.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  cast( case when CMR.HeaderBillingBlockReason != '' then 1 else 0 end as abap.int1) as BillingBlockCriticality AS int1asBillingBlockCriticality,
  CMR.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  CMR.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  CMR.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  CMR.CreditMemoReqApprovalReason AS CreditMemoReqApprovalReason,
  _CreditMemoReqApprovalReason._SDApprovalReasonT[1: Language=$session.system_language].SDApprovalReasonName AS SDApprovalReasonName,
  CMR.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  TotalNetAmount,
  TransactionCurrency,
  CMR.OrganizationDivision AS OrganizationDivision,
  CMR.DistributionChannel AS DistributionChannel,
  CMR.SalesOrganization AS SalesOrganization,
  case _EmployeeResponsible.Personnel when '00000000' then '' else _EmployeeResponsible.Personnel end as Employee AS PersonnelendasEmployee,
  CMR.SDDocumentReason AS SDDocumentReason,
  cast('' as ad_namtext ) AS ResponsibleEmployeeName,
  CMR.CreditMemoRequestDate AS CreditMemoRequestDate,
  CMR.PurchaseOrderByCustomer AS PurchaseOrder,
  CMR.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  CMR.CreatedByUser AS CreatedByUser,
  CMR._CreatedByUser.UserDescription AS CreatedByUserDescription,
  CMR.CreationDate AS CreationDate,
  CMR.LastChangedByUser AS LastChangedByUser,
  CMR._LastChangedByUser.UserDescription AS LastChangedByUserDescription
FROM I_CreditMemoRequest AS CMR
LEFT OUTER JOIN C_Q2CCustomerQuickView AS _SoldToPartyVH ON SoldToParty = _SoldToPartyVH.Customer  -- association [0..1]
LEFT OUTER JOIN C_CreditmemorequestItemfs AS _CreditmemorequestItemfs ON CreditMemoRequest = _CreditmemorequestItemfs.CreditMemoRequest  -- association [0..*]
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _SDDocumentPartnerCard ON CreditMemoRequest = _SDDocumentPartnerCard.SDDocument AND _SDDocumentPartnerCard.SDDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentPersonnel AS _EmployeeResponsible ON CreditMemoRequest= _EmployeeResponsible.SDDocument AND _EmployeeResponsible.PartnerFunction = 'ZM'  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON CreditMemoRequest = _Extension.SalesDocument  -- association [1]
;