I_AllocationTable

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_AllocationTable.
-- 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: IALLOCATIONTABLE

CREATE VIEW I_AllocationTable AS
SELECT
  abeln AS AllocationTable,
  cast( bezch as allocationtabledescription preserving type ) AS AllocationTableDescription,
  cast( aufar as allocationtabletype preserving type ) AS AllocationTableType,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup,
  cast( astak as alloctableactivitystatus preserving type ) AS AllocTableActivityStatus,
  pstak AS MaintenanceStatus,
  cast( ervon as alloctablecreatingapplication preserving type ) AS AllocTableCreatingApplication,
  erdat AS CreationDate,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aenam AS LastChangedByUser
FROM auko
LEFT OUTER JOIN I_AllocationTableType AS _AllocationTableType ON AllocationTableType = _AllocationTableType.AllocationTableType  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_AllocTableActivityStatus AS _AllocTableActivityStatus ON AllocTableActivityStatus = _AllocTableActivityStatus.AllocTableActivityStatus  -- association [1..1]
LEFT OUTER JOIN I_AllocTableMaintenanceStatus AS _AllocTableMaintenanceStatus ON MaintenanceStatus = _AllocTableMaintenanceStatus.MaintenanceStatus  -- association [1..1]
LEFT OUTER JOIN I_AllocTableCreatingAppl AS _CreatingApplication ON AllocTableCreatingApplication = _CreatingApplication.AllocTableCreatingApplication  -- association [1..1]
LEFT OUTER JOIN I_AllocationTableItem AS _AllocationTableItem ON AllocationTable = _AllocationTableItem.AllocationTable  -- association [0..*]
LEFT OUTER JOIN I_AllocationTableDeliveryPhase AS _DefaultDeliveryPhase ON AllocationTable = _DefaultDeliveryPhase.AllocationTable AND _DefaultDeliveryPhase.AllocationTableItem = '00000' AND _DefaultDeliveryPhase.AllocationTableItemRcpntGrp = '00000' AND _DefaultDeliveryPhase.AllocationTableItemRecipient = '00000' AND _DefaultDeliveryPhase.AllocationTableDeliveryPhase = '001'  -- association [0..1]
LEFT OUTER JOIN I_AllocTableDistrCtrDelivPhase AS _DefaultDistrCtrDelivPhase ON AllocationTable = _DefaultDistrCtrDelivPhase.AllocationTable AND _DefaultDistrCtrDelivPhase.AllocationTableItem = '00000' AND _DefaultDistrCtrDelivPhase.AllocationTableDeliveryPhase = '001' AND _DefaultDistrCtrDelivPhase.DistributionCenter = ''  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;