I_OIL_TransportSystemTP

DDL: I_OIL_TRANSPORTSYSTEMTP Type: view_entity TRANSACTIONAL
79 Fields 1 Data Sources

Transport System - TP

I_OIL_TransportSystemTP is a Transactional CDS View that provides data about "Transport System - TP" in SAP S/4HANA. It reads from 1 data source (R_OIL_TransportSystemTP) and exposes 79 fields with key field TransportSystem.

Data Sources (1)

SourceAliasJoin Type
R_OIL_TransportSystemTP R_OIL_TransportSystemTP projection

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transport System - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey TransportSystem view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.sapObjectNodeType.name OIL_BulkTransportSystem view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY TransportSystem TransportSystem Transport System
TransportSystemText TransportSystemText
TransportSystemHasBook TransportSystemHasBook
TransptSystShipgTypeTrMode TransptSystShipgTypeTrMode
ModeOfTransport ModeOfTransport Mode of Transp.
BulkShipmentType BulkShipmentType
TransptSystDfltTranspVeh TransptSystDfltTranspVeh
TransportSystemVolumeUnit TransportSystemVolumeUnit
TransportSystemWeightUnit TransportSystemWeightUnit
TransptSystCycleDurationQty TransptSystCycleDurationQty
TransportSystemDurationUnit TransportSystemDurationUnit
TransportSystemCarrier TransportSystemCarrier
InTransitPlant InTransitPlant
InTransitStorageLocation InTransitStorageLocation
TransptSystNominationMaskText TransptSystNominationMaskText
TransportSystemShipperCode TransportSystemShipperCode
TransptSystCarrLeadTmeQty TransptSystCarrLeadTmeQty
TransptSystConfLeadTmeUnt TransptSystConfLeadTmeUnt
TransportationPlnPoint TransportationPlnPoint TransportPlanPt
ToleranceOverRate ToleranceOverRate
ToleranceUnderRate ToleranceUnderRate Under %
TransptSystTolOvrQuantity TransptSystTolOvrQuantity
PhysStkAbsltQtyTolUndrQty PhysStkAbsltQtyTolUndrQty Abs.tol.Q under
TransportSystemToleranceUnit TransportSystemToleranceUnit
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed Unlimited Tol.
TransptSystHasBalanceChecked TransptSystHasBalanceChecked
TransptSystTmpStorLoc TransptSystTmpStorLoc
TransportSystemShipmentType TransportSystemShipmentType
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangedByUser LastChangedByUser User Name
IsBlocked IsBlocked Boolean Variable (X = True, - = False, Space = Unknown)
IsDeleted IsDeleted TRUE
TicketIsSelectable TicketIsSelectable Flag to Select Tkt
TransptSystOutpDetnProced TransptSystOutpDetnProced
TransptSystOutpDetnProcedAppl TransptSystOutpDetnProcedAppl
TransptSystOutpDetnOutputType TransptSystOutpDetnOutputType
MaxRatePerPeriodQuantity MaxRatePerPeriodQuantity Maximum rate
MinRatePerPeriodQuantity MinRatePerPeriodQuantity Minimum rate
OpgRatePerPeriodQuantity OpgRatePerPeriodQuantity operating rate
RateUnit RateUnit
RateTimeUnit RateTimeUnit
TransptSystHasLocSqnc TransptSystHasLocSqnc
MaxVolumePerPeriodQuantity MaxVolumePerPeriodQuantity Max Volume
MinVolumePerPeriodQuantity MinVolumePerPeriodQuantity Min Volume
UsageUnit UsageUnit
UsageTimeUnit UsageTimeUnit
TransptSystHasPplineBatActv TransptSystHasPplineBatActv
TransptSystAvgVelocityQty TransptSystAvgVelocityQty
TransptSystMaxVelocityQty TransptSystMaxVelocityQty
TransptSystMinVelocityQty TransptSystMinVelocityQty
RetailNetworkBusinessType RetailNetworkBusinessType Business type
TransportSystemVelocityUnit TransportSystemVelocityUnit
TransptSystVelocityTimeUnit TransptSystVelocityTimeUnit
TransptSystRouteToleranceRatio TransptSystRouteToleranceRatio
StockProjectionIsActive StockProjectionIsActive
TransptSystHasTktActualization TransptSystHasTktActualization
_TranspSchedgPointVH _TranspSchedgPointVH
_BulkShipmentType _BulkShipmentType
_BulkTransportVehicle _BulkTransportVehicle
_ConditionApplication _ConditionApplication
_DurationUnitOfMeasure _DurationUnitOfMeasure
_ModesOfTransport _ModesOfTransport
_Plant _Plant
_RateTimeUnitOfMeasure _RateTimeUnitOfMeasure
_RateUnitOfMeasure _RateUnitOfMeasure
_BusinessTypeVH _BusinessTypeVH
_ShipgTypeTransptMode _ShipgTypeTransptMode
_StorageLocation _StorageLocation
_Supplier _Supplier
_ToleranceUnitOfMeasure _ToleranceUnitOfMeasure
_VelocityUnitOfMeasure _VelocityUnitOfMeasure
_VolumeUnitOfMeasure _VolumeUnitOfMeasure
_WeightUnitOfMeasure _WeightUnitOfMeasure
_BulkShipmentVehicleHeaderTxt _BulkShipmentVehicleHeaderTxt
_BulkShipmentTypeTxt _BulkShipmentTypeTxt

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_TransportSystemTP.
-- 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_TransportSystemTP AS
SELECT
  TransportSystem,
  TransportSystemText,
  TransportSystemHasBook,
  TransptSystShipgTypeTrMode,
  ModeOfTransport,
  BulkShipmentType,
  TransptSystDfltTranspVeh,
  TransportSystemVolumeUnit,
  TransportSystemWeightUnit,
  TransptSystCycleDurationQty,
  TransportSystemDurationUnit,
  TransportSystemCarrier,
  InTransitPlant,
  InTransitStorageLocation,
  TransptSystNominationMaskText,
  TransportSystemShipperCode,
  TransptSystCarrLeadTmeQty,
  TransptSystConfLeadTmeUnt,
  TransportationPlnPoint,
  ToleranceOverRate,
  ToleranceUnderRate,
  TransptSystTolOvrQuantity,
  PhysStkAbsltQtyTolUndrQty,
  TransportSystemToleranceUnit,
  UnlimitedOverdeliveryIsAllowed,
  TransptSystHasBalanceChecked,
  TransptSystTmpStorLoc,
  TransportSystemShipmentType,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  IsBlocked,
  IsDeleted,
  TicketIsSelectable,
  TransptSystOutpDetnProced,
  TransptSystOutpDetnProcedAppl,
  TransptSystOutpDetnOutputType,
  MaxRatePerPeriodQuantity,
  MinRatePerPeriodQuantity,
  OpgRatePerPeriodQuantity,
  RateUnit,
  RateTimeUnit,
  TransptSystHasLocSqnc,
  MaxVolumePerPeriodQuantity,
  MinVolumePerPeriodQuantity,
  UsageUnit,
  UsageTimeUnit,
  TransptSystHasPplineBatActv,
  TransptSystAvgVelocityQty,
  TransptSystMaxVelocityQty,
  TransptSystMinVelocityQty,
  RetailNetworkBusinessType,
  TransportSystemVelocityUnit,
  TransptSystVelocityTimeUnit,
  TransptSystRouteToleranceRatio,
  StockProjectionIsActive,
  TransptSystHasTktActualization
FROM R_OIL_TransportSystemTP
;

Learn More