C_CreditMemoRequestWl_F1989

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_CreditMemoRequestWl_F1989.
-- 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: CCREDITMRWLF1989

CREATE VIEW C_CreditMemoRequestWl_F1989 AS
SELECT
  CreditMemoRequest.CreditMemoRequest AS CreditMemoRequest,
  CreditMemoRequest.SoldToParty AS SoldToParty,
  CreditMemoRequest._SoldToParty.CustomerName AS SoldToPartyFullName,
  cast('' as ad_namtext ) AS SoldToPartyName,
  CreditMemoRequest.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CreditMemoRequest.BillingDocumentDate AS BillingDocumentDate,
  CreditMemoRequest.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  CreditMemoRequest.OverallSDProcessStatus AS OverallSDProcessStatus,
  CreditMemoRequest.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  CreditMemoRequest.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  CreditMemoRequest.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  CreditMemoRequest.CreditMemoRequestDate AS CreditMemoRequestDate,
  CreditMemoRequest.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  CreditMemoRequest._HeaderBillingBlockReason._Text[1: Language = $session.system_language ]. BillingBlockReasonDescription AS BillingBlockReasonDescription,
  CreditMemoRequest.CreditMemoRequestType AS CreditMemoRequestType,
  CreditMemoRequest.SalesOrganization AS SalesOrganization,
  CreditMemoRequest.DistributionChannel AS DistributionChannel,
  CreditMemoRequest.OrganizationDivision AS OrganizationDivision,
  CreditMemoRequest.SalesOffice AS SalesOffice,
  CreditMemoRequest.SalesGroup AS SalesGroup,
  CreditMemoRequest.CreationDate AS CreationDate,
  CreditMemoRequest.LastChangeDate AS LastChangeDate,
  CreditMemoRequest.CreatedByUser AS CreatedByUser,
  CreditMemoRequest.LastChangedByUser AS LastChangedByUser,
  CreditMemoRequest.ReferenceSDDocument AS ReferenceSDDocument,
  CreditMemoRequest.SDDocumentReason AS SDDocumentReason,
  CreditMemoRequest._SDDocumentReason._Text[1: Language = $session.system_language ]. SDDocumentReasonText AS SDDocumentReasonText,
  cast( ' ' as abgru_va) AS SalesDocumentRjcnReason,
  CreditMemoRequest.TransactionCurrency AS TransactionCurrency,
  CreditMemoRequest._TransactionCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  CreditMemoRequest.TotalNetAmount AS TotalNetAmount,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2
FROM I_CreditMemoRequest AS CreditMemoRequest
LEFT OUTER JOIN C_Q2CCustomerQuickView 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_CreditMemoReqTypeVH_F1989 AS _CreditMemoRequestType ON CreditMemoRequestType = _CreditMemoRequestType.CreditMemoRequestType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocAllowedRjcnRsn AS _SalesDocumentRjcnReason ON SalesOrganization = _SalesDocumentRjcnReason.SalesOrganization AND CreditMemoRequestType = _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_SalesDocumentItemWl AS _SalesDocumentItemWl ON CreditMemoRequest = _SalesDocumentItemWl.SalesDocument  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON CreditMemoRequest = _Extension.SalesDocument  -- association [1]
;