R_CreditMemoRequestItemTP

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 R_CreditMemoRequestItemTP.
-- 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.

CREATE VIEW R_CreditMemoRequestItemTP AS
SELECT
  CreditMemoRequestItem.CreditMemoRequest AS CreditMemoRequest,
  CreditMemoRequestItem.CreditMemoRequestItem AS CreditMemoRequestItem,
  CreditMemoRequestItem.HigherLevelItem AS HigherLevelItem,
  CreditMemoRequestItem.CreditMemoRequestItemCategory AS CreditMemoRequestItemCategory,
  CreditMemoRequestItem.CreditMemoRequestItemText AS CreditMemoRequestItemText,
  CreditMemoRequestItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CreditMemoRequestItem.Product AS Product,
  CreditMemoRequestItem.MaterialByCustomer AS MaterialByCustomer,
  CreditMemoRequestItem.ProductGroup AS ProductGroup,
  CreditMemoRequestItem.MaterialPricingGroup AS MaterialPricingGroup,
  CreditMemoRequestItem.Batch AS Batch,
  CreditMemoRequestItem.PricingDate AS PricingDate,
  _CreditMemoRequest.SDPricingProcedure AS SDPricingProcedure,
  CreditMemoRequestItem.RequestedQuantity AS RequestedQuantity,
  CreditMemoRequestItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  CreditMemoRequestItem.TransactionCurrency AS TransactionCurrency,
  CreditMemoRequestItem.NetAmount AS NetAmount,
  CreditMemoRequestItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  CreditMemoRequestItem.Plant AS Plant,
  CreditMemoRequestItem.TargetQuantity AS TargetQuantity,
  CreditMemoRequestItem.TargetQuantityUnit AS TargetQuantityUnit,
  CreditMemoRequestItem.ItemGrossWeight AS ItemGrossWeight,
  CreditMemoRequestItem.ItemNetWeight AS ItemNetWeight,
  CreditMemoRequestItem.ItemWeightUnit AS ItemWeightUnit,
  CreditMemoRequestItem.ItemVolume AS ItemVolume,
  CreditMemoRequestItem.ItemVolumeUnit AS ItemVolumeUnit,
  CreditMemoRequestItem.ServicesRenderedDate AS ServicesRenderedDate,
  CreditMemoRequestItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  CreditMemoRequestItem.TaxAmount AS TaxAmount,
  CreditMemoRequestItem.CustomerGroup AS CustomerGroup,
  CreditMemoRequestItem.BusinessArea AS BusinessArea,
  CreditMemoRequestItem.ControllingArea AS ControllingArea,
  CreditMemoRequestItem.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  CreditMemoRequestItem.IncotermsClassification AS IncotermsClassification,
  CreditMemoRequestItem.IncotermsLocation1 AS IncotermsLocation1,
  CreditMemoRequestItem.IncotermsLocation2 AS IncotermsLocation2,
  CreditMemoRequestItem.IncotermsVersion AS IncotermsVersion,
  CreditMemoRequestItem.BillingDocumentDate AS BillingDocumentDate,
  CreditMemoRequestItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  CreditMemoRequestItem.ProfitCenter AS ProfitCenter,
  CreditMemoRequestItem.WBSElementInternalID AS WBSElementInternalID,
  CreditMemoRequestItem._WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID,
  CreditMemoRequestItem.ReferenceSDDocument AS ReferenceSDDocument,
  CreditMemoRequestItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  CreditMemoRequestItem.SDProcessStatus AS SDProcessStatus,
  CreditMemoRequestItem.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  CreditMemoRequestItem.BillingBlockStatus AS BillingBlockStatus,
  CreditMemoRequestItem.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  CreditMemoRequestItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  CreditMemoRequestItem.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
  _CreditMemoRequest.CreditMemoRequestType AS CreditMemoRequestType,
  _CreditMemoRequest.OrganizationDivision AS OrganizationDivision,
  _CreditMemoRequest.SalesOrganization AS SalesOrganization,
  _CreditMemoRequest.DistributionChannel AS DistributionChannel
FROM I_CreditMemoRequestItem AS CreditMemoRequestItem
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON CreditMemoRequest = _Extension.SalesDocument AND CreditMemoRequestItem = _Extension.SalesDocumentItem  -- association [1]
LEFT OUTER JOIN R_CreditMemoReqItemPartnerTP AS _ItemPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CreditMemoRequestItemTextTP AS _ItemText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CreditMemoReqItemPrcgElmntTP AS _ItemPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
;