R_RenegotiationItemListTP

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_RenegotiationItemListTP.
-- 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_RenegotiationItemListTP AS
SELECT
  RenegotiationHeaderUUID,
  RenegotiationItemUUID,
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  PurchasingDocumentItemUniqueID,
  ExtSourceSystem,
  Material,
  Plant,
  MaterialGroup,
  PurchasingDocumentCategory,
  PurchaseContractType,
  PurchasingGroup,
  ValidityStartDate,
  ValidityEndDate,
  ProcessingStatus,
  ProductTypeCode,
  ContractNetPriceAmount,
  TargetQuantity,
  OrderQuantityUnit,
  TargetAmount,
  OrderPriceUnit,
  _Renegotiation.DocumentCurrency AS DocumentCurrency,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  PurchasingDocumentItemCategory,
  RenegttnItemPriceCheckStatus,
  RenegttnItmAcceptanceStatus,
  PurchaseContractItemText
FROM R_RenegotiationItemList
LEFT OUTER JOIN I_RenegttnItemPriceCheckStatus AS _RenegttnItemPriceCheckStatus ON RenegttnItemPriceCheckStatus = _RenegttnItemPriceCheckStatus.RenegttnItemPriceCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_RenegttnItmAcceptanceStatus AS _RenegttnItmAcceptanceStatus ON RenegttnItmAcceptanceStatus = _RenegttnItmAcceptanceStatus.RenegttnItmAcceptanceStatus  -- association [0..1]
LEFT OUTER JOIN E_RenegotiationItemList AS _Extension ON RenegotiationHeaderUUID = _Extension.RenegotiationHeaderUUID AND RenegotiationItemUUID = _Extension.RenegotiationItemUUID  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurchaseContractItem AS _CntrlPurchaseContractItem ON CentralPurchaseContract = _CntrlPurchaseContractItem.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurchaseContractItem.CentralPurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN R_RenegotiationItemPriceCndnTP AS _PricingCondition ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_RenegotiationPricingTP AS _PricingLog ON /* condition not available in parsed metadata */  -- association [1..*]
;