C_FldLogsSupplierItemTP

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 C_FldLogsSupplierItemTP.
-- 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 C_FldLogsSupplierItemTP AS
SELECT
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemType,
  FldLogsSuplrParentItemUUID,
  FldLogsSuplrItemSerialNumber,
  FldLogsSuplrItemName,
  PreferredSupplier,
  FldLogsSuplrBasePlant,
  FldLogsRemotePlant,
  FldLogsSuplrItmPOItmUniqueID,
  PurchasingDocument AS PurchaseOrder,
  FldLogsSupplyProcess,
  FldLogsSuplrItemVislInspCode,
  PurgDocNetPriceAmount,
  FldLogsSuplrItemRateUnit,
  FldLogsSuplrItemQuantityUnit,
  FldLogsSuplrItemQuantity,
  EntryUnit,
  FldLogsGRQty,
  ReturnQuantity,
  OpenQtyInPurchaseOrderUnit,
  FldLogsSuplrItemGrossVolume,
  FldLogsSuplrItmGrossVolumeUnit,
  ProductGrossWeight,
  ProductWeightUnit,
  FldLogsSuplrItemLength,
  FldLogsSuplrItemWidth,
  FldLogsSuplrItemHeight,
  FldLogsSuplrItemMeasureUnit,
  FldLogsSuplrItemStatusID,
  FldLogsSuplrItemDimnInfoText,
  FldLogsSuplrItmDimnInfoCritlty,
  ItemIsDangerousGood,
  FldLogsSuplrItemDngrsGdsCat,
  FldLogsIsWorkOrderOnHold,
  MaintenanceOrder,
  OrderCategory,
  _OrderCatTxt.OrderCategoryName AS OrderCategoryName,
  PurchaseRequisition,
  PurchaseContract,
  ProcmtHubPOItemUniqueID,
  FldLogsSuplrItemPlndDelivDate,
  FldLogsPlndSrvcStartDate,
  FldLogsPlndSrvcEndDate,
  FldLogsActlSrvcStartDate,
  FldLogsActlSrvcEndDate,
  FldLogsSuplrItmChangeDateTime,
  FldLogsLoadingPointID,
  FldLogsUnloadingPointID,
  FldLogsStorageLocationID,
  EWMStorageBin,
  FldLogsContainerID,
  FldLogsTranspContainerID,
  cast( Project as cats_cpr_extid preserving type) AS Project,
  ProjectDemand,
  HandlingUnitId,
  HandlingUnitExternalID,
  FldLogsSuplrItmDelivCritlty,
  FldLogsLtstMilestoneEventID,
  FldLogsMilestoneEventType,
  FldLogsSuplrItmDelivStatusText,
  _SuplrItemPriorityText.FldLogsSuplrItemPriorityText AS FldLogsSuplrItemPriorityText,
  FldLogsMaintOrdPrioCriticality,
  FldLogsSuplrItmPackggTypeCode,
  FldLogsSuplrItmPackggTypeTxt,
  MaterialDocument,
  MaterialDocumentYear,
  FldLogsSuplrItmGRDocID,
  FldLogsSuplrItmRvslGRDocID,
  OutboundDelivery,
  FldLogsSuplrItmPOItmUniqueID1,
  FldLogsSuplrItemSerialNumber1,
  _QtyUnitOfMeasureText.UnitOfMeasureLongName AS FldLogsQtyUnitOfMsrLongName,
  _VolUnitOfMeasureText.UnitOfMeasureLongName AS FldLogsVolUnitOfMsrLongName,
  _WgtUnitOfMeasureText.UnitOfMeasureLongName AS FldLogsWgtUnitOfMsrLongName,
  _UnitOfMeasureText.UnitOfMeasureLongName AS UnitOfMeasureText,
  _Supplier.SupplierName AS SupplierName,
  _RemotePlantText.PlantName AS FldLogsRemotePlantName,
  _BasePlantText.PlantName AS PlantName,
  DangerousGoodsClassDescription,
  PackagingMaterial,
  FldLogsContainerOwner,
  FldLogsSealNumber1,
  FldLogsSealNumber2,
  FldLogsSealNumber3,
  FldLogsSealNumber4,
  FldLogsSealNumber5,
  IsBusinessPurposeCompleted,
  SuplrCoIsBusPrpsCmpltd,
  RemoteStorageLocation,
  SemanticObject,
  _SuplrItemTypeCncDesc.FldLogsSuplrItemTypeText AS FldLogsSuplrItemTypeText,
  FldLogsCtnInfoSecIsHidden,
  IsEndOfPurposeBlocked,
  MaterialGroup,
  FldLogsWarehouseTaskID,
  FldLogsPutawayWarehouseTask,
  ReferenceDocumentItemText,
  FldLogsReferenceObjectType,
  _RefObjTypeDesc.FldLogsReferenceObjectTypeText AS FldLogsReferenceObjectTypeText,
  FldLogsReferenceObjectNumber,
  FldLogsItemIsRestricted,
  FldLogsReferenceDocumentNumber
FROM R_FldLogsSupplierItemTP
LEFT OUTER JOIN C_FldLogsWhseTaskInfo AS _FldLogsWarehouseTasks ON FldLogsSuplrItemUUID = _FldLogsWarehouseTasks.FldLogsSuplrItemUUID AND _FldLogsWarehouseTasks.IsHandlingUnitWarehouseTask is not initial  -- association [0..*]
;