P_ABOPFieldCatalog

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 P_ABOPFieldCatalog.
-- 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: PABOPFC

CREATE VIEW P_ABOPFieldCatalog AS
SELECT
  SalesDocument AS ATPRelevantDocument,
  SalesDocumentItem AS ATPRelevantDocumentItem,
  ScheduleLine AS ATPRelevantDocScheduleLine,
  concat('V', _SalesDocument.SDDocumentCategory) AS ATPRelevantDocumentCategory,
  _SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  _SalesDocumentItem.Material AS Material,
  _SalesDocumentItem.Plant AS SupplyingPlant,
  _SalesDocumentItem.MRPArea AS MRPArea,
  _SalesDocumentItem.StorageLocation AS StorageLocation,
  _SalesDocumentItem.Batch AS Batch,
  ProductAvailabilityDate,
  RequestedDeliveryDate,
  _SalesDocument.CreatedByUser AS CreatedByUser,
  _SalesDocument.CreationDate AS OrderCreationDate,
  _SalesDocument.SoldToParty AS SoldToParty,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.SalesDocumentType AS SalesDocumentType,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  _SalesDocumentItem.MaterialGroup AS MaterialGroup,
  _SalesDocumentItem.DeliveryPriority AS DeliveryPriority,
  _SalesDocumentItem.NetAmount AS NetAmount,
  _SalesDocument.OrganizationDivision AS OrganizationDivision,
  cast( case when _SalesDocument.CompleteDeliveryIsDefined = 'X' then '001' else _SalesDocumentItem.DeliveryGroup end as grkor) as DeliveryGroup AS DeliveryGroupendasgrkorasDeliveryGroup,
  cast(case when _SalesDocument.CompleteDeliveryIsDefined = '' and _SalesDocumentItem.QuantityIsFixed = '' and _SalesDocumentItem.BillOfMaterial <> '' then 'B' when _SalesDocument.CompleteDeliveryIsDefined = 'X' or _SalesDocumentItem.DeliveryGroup <> '000' then 'A' else '' end as abap.char(1)) as GroupType AS char1asGroupType,
  _SalesDocument.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  _SalesDocumentItem.InventorySpecialStockType AS InventorySpecialStockType,
  _SalesDocumentItem.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
  _SalesDocumentItem.HigherLevelItem AS HigherLevelItem,
  _SalesDocumentItem.ProdAvailabilityCheckGroup AS ProdAvailabilityCheckGroup,
  _SalesDocumentItem.ShippingPoint AS ShippingPoint,
  _SalesDocumentItem.Route AS Route,
  ScheduleLineCategory,
  _SalesDocument._SDDocumentCategory AS _SDDocumentCategory,
  _SalesDocumentItem._Material AS _Material,
  _SalesDocumentItem._Plant AS _ProductionPlant,
  _SalesDocumentItem._StorageLocation AS _StorageLocation,
  _SalesDocument._CreatedByUser AS _CreatedByUser,
  _SalesDocument._SoldToParty AS _SoldToParty,
  _SalesDocument._SalesOrganization AS _SalesOrganization,
  _SalesDocument._DistributionChannel AS _DistributionChannel,
  _SalesDocument._OrganizationDivision AS _OrganizationDivision,
  _SalesDocument._SalesDocumentType AS _SalesDocumentType,
  _SalesDocumentItem._MaterialGroup AS _MaterialGroup,
  _SalesDocumentItem._DeliveryPriority AS _DeliveryPriority,
  _SalesDocument._ShippingCondition AS _ShippingCondition,
  _SalesDocumentItem._ShippingPoint AS _ShippingPoint
FROM I_SalesDocumentScheduleLine
LEFT OUTER JOIN t459k AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvep AS tv ON /* join condition not captured in parsed metadata */
;