R_DebitMemoRequestItemTP

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_DebitMemoRequestItemTP.
-- 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_DebitMemoRequestItemTP AS
SELECT
  DebitMemoRequestItem.DebitMemoRequest AS DebitMemoRequest,
  DebitMemoRequestItem.DebitMemoRequestItem AS DebitMemoRequestItem,
  DebitMemoRequestItem.HigherLevelItem AS HigherLevelItem,
  DebitMemoRequestItem.DebitMemoRequestItemCategory AS DebitMemoRequestItemCategory,
  _ItemEnhancedFields.ItemCategoryGroup AS ItemCategoryGroup,
  _ItemEnhancedFields.SDDocumentItemUsage AS SDDocumentItemUsage,
  DebitMemoRequestItem._HigherLevelItem.DebitMemoRequestItemCategory AS HigherLevelItemCategory,
  DebitMemoRequestItem.DebitMemoRequestItemText AS DebitMemoRequestItemText,
  DebitMemoRequestItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  DebitMemoRequestItem.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  DebitMemoRequestItem.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  DebitMemoRequestItem.CustPurOrdTypeByShipToParty AS CustPurOrdTypeByShipToParty,
  DebitMemoRequestItem.CorrespncExternalReference AS CorrespncExternalReference,
  DebitMemoRequestItem.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  DebitMemoRequestItem.UnderlyingPurchaseOrderItem AS UnderlyingPurchaseOrderItem,
  DebitMemoRequestItem.UndrlgPurOrdItmByShipToParty AS UndrlgPurOrdItmByShipToParty,
  DebitMemoRequestItem.Product AS Product,
  DebitMemoRequestItem.MaterialByCustomer AS MaterialByCustomer,
  DebitMemoRequestItem.ProductGroup AS ProductGroup,
  DebitMemoRequestItem.MaterialPricingGroup AS MaterialPricingGroup,
  DebitMemoRequestItem.Batch AS Batch,
  DebitMemoRequestItem.PricingDate AS PricingDate,
  _DebitMemoRequest.SDPricingProcedure AS SDPricingProcedure,
  DebitMemoRequestItem.RequestedQuantity AS RequestedQuantity,
  DebitMemoRequestItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  DebitMemoRequestItem.TransactionCurrency AS TransactionCurrency,
  DebitMemoRequestItem.NetAmount AS NetAmount,
  DebitMemoRequestItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  DebitMemoRequestItem.Plant AS Plant,
  DebitMemoRequestItem.TargetQuantity AS TargetQuantity,
  DebitMemoRequestItem.TargetQuantityUnit AS TargetQuantityUnit,
  DebitMemoRequestItem.ItemGrossWeight AS ItemGrossWeight,
  DebitMemoRequestItem.ItemNetWeight AS ItemNetWeight,
  DebitMemoRequestItem.ItemWeightUnit AS ItemWeightUnit,
  DebitMemoRequestItem.ItemVolume AS ItemVolume,
  DebitMemoRequestItem.ItemVolumeUnit AS ItemVolumeUnit,
  DebitMemoRequestItem.ServicesRenderedDate AS ServicesRenderedDate,
  DebitMemoRequestItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  DebitMemoRequestItem.TaxAmount AS TaxAmount,
  DebitMemoRequestItem.CustomerGroup AS CustomerGroup,
  DebitMemoRequestItem.BusinessArea AS BusinessArea,
  DebitMemoRequestItem.ControllingArea AS ControllingArea,
  DebitMemoRequestItem.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  DebitMemoRequestItem.IncotermsClassification AS IncotermsClassification,
  DebitMemoRequestItem.IncotermsLocation1 AS IncotermsLocation1,
  DebitMemoRequestItem.IncotermsLocation2 AS IncotermsLocation2,
  DebitMemoRequestItem.IncotermsVersion AS IncotermsVersion,
  DebitMemoRequestItem.BillingDocumentDate AS BillingDocumentDate,
  DebitMemoRequestItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  DebitMemoRequestItem.ProfitCenter AS ProfitCenter,
  DebitMemoRequestItem._WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID,
  DebitMemoRequestItem.ReferenceSDDocument AS ReferenceSDDocument,
  DebitMemoRequestItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  DebitMemoRequestItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  DebitMemoRequestItem.SDProcessStatus AS SDProcessStatus,
  DebitMemoRequestItem.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  DebitMemoRequestItem.BillingBlockStatus AS BillingBlockStatus,
  DebitMemoRequestItem.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  DebitMemoRequestItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  DebitMemoRequestItem.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
  _DebitMemoRequest.DebitMemoRequestType AS DebitMemoRequestType,
  _DebitMemoRequest.OrganizationDivision AS OrganizationDivision,
  _DebitMemoRequest.SalesOrganization AS SalesOrganization,
  _DebitMemoRequest.DistributionChannel AS DistributionChannel,
  _ItemEnhancedFields._ItemCategoryGroup AS _ItemCategoryGroup,
  _ItemEnhancedFields._SDDocumentItemUsage AS _SDDocumentItemUsage
FROM I_DebitMemoRequestItem AS DebitMemoRequestItem
LEFT OUTER JOIN I_SlsDocItemEnhancedFields AS _ItemEnhancedFields ON DebitMemoRequest = _ItemEnhancedFields.SalesDocument AND DebitMemoRequestItem = _ItemEnhancedFields.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _HigherLevelItemCategory ON HigherLevelItemCategory = _HigherLevelItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON DebitMemoRequest = _Extension.SalesDocument AND DebitMemoRequestItem = _Extension.SalesDocumentItem  -- association [1]
LEFT OUTER JOIN R_DebitMemoReqItemPartnerTP AS _ItemPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_DebitMemoRequestItemTextTP AS _ItemText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_DebitMemoReqItemPrcgElmntTP AS _ItemPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
;