I_OIL_PartnerRoleBasic

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 I_OIL_PartnerRoleBasic.
-- 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 I_OIL_PartnerRoleBasic AS
SELECT
  kunnr AS Customer,
  lifnr AS Supplier,
  werk AS Plant,
  lgort AS StorageLocation,
  rtype AS PartnerRoleType,
  rdiff AS PartnerRoleDifferentiator,
  rpart AS RolePartnerType,
  cparid AS LocationPartner,
  parnm AS CommonPartnerText,
  tsyst AS TransportSystem,
  locid AS PartnerRoleLocationIdentifier,
  ruleid AS TicketNumberRule,
  tsparid AS PipelinePartner,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS IsBlocked,
  delind AS IsDeleted,
  tktselect AS TicketIsSelectable
FROM oijrra
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON _StorageLocation.StorageLocation = StorageLocation AND _StorageLocation.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_OIL_RolePartnerTypeVH AS _RolePartnerType ON _RolePartnerType.RolePartnerType = RolePartnerType  -- association [0..1]
LEFT OUTER JOIN I_OIL_PartnerRoleType AS _PartnerRoleType ON _PartnerRoleType.PartnerRoleType = PartnerRoleType  -- association [0..1]
LEFT OUTER JOIN I_OIL_TransportSystem AS _TransportSystem ON _TransportSystem.TransportSystem = TransportSystem  -- association [0..1]
LEFT OUTER JOIN I_OIL_BusinessLocationBasic AS _BusinessLocation ON _BusinessLocation.BusinessLocationIdentifier = PartnerRoleLocationIdentifier  -- association [0..1]
LEFT OUTER JOIN I_OIL_TicketNumberRule AS _TicketNumberRule ON _TicketNumberRule.TicketNumberRule = TicketNumberRule  -- association [0..1]
;