R_OIL_TransportSystemTP

DDL: R_OIL_TRANSPORTSYSTEMTP Type: view_entity TRANSACTIONAL
84 Fields 1 Data Sources 4 Associations

Trasport System - TP

R_OIL_TransportSystemTP is a Transactional CDS View that provides data about "Trasport System - TP" in SAP S/4HANA. It reads from 1 data source (I_OIL_TransportSystem) and exposes 84 fields with key field TransportSystem. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_OIL_TransportSystem I_OIL_TransportSystem from

Associations (4)

CardinalityTargetAliasCondition
[0..*] R_OIL_TransptSystTransptModeTP _TransptSystTransptMode
[0..*] R_OIL_TransptSystPlngMatlTP _TransptSystPlngMatl
[0..*] R_OIL_TransptSystLocAssgmtTP _TransptSystLocAssgmt
[0..*] R_OIL_TransptDisallowedMatlTP _TransptSystDsblMatl

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Trasport 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 #SAP_INTERNAL_API view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.sapObjectNodeType.name OIL_BulkTransportSystem view

Fields (84)

KeyFieldSource TableSource FieldDescription
KEY TransportSystem TransportSystem Transport System
TransportSystemText TransportSystemText TS name
TransportSystemHasBook TransportSystemHasBook Single-Character Flag
TransptSystShipgTypeTrMode TransptSystShipgTypeTrMode Shp.type: stage
ModeOfTransport ModeOfTransport Mode of Transp.
BulkShipmentType BulkShipmentType Bulk shipm.type
TransptSystDfltTranspVeh TransptSystDfltTranspVeh Default veh.no.
TransportSystemVolumeUnit TransportSystemVolumeUnit UoM volume
TransportSystemWeightUnit TransportSystemWeightUnit UoM weight
TransptSystCycleDurationQty TransptSystCycleDurationQty Cycle duration
TransportSystemDurationUnit TransportSystemDurationUnit UoM
TransportSystemCarrier TransportSystemCarrier Service Agent
InTransitPlant InTransitPlant Plant
InTransitStorageLocation InTransitStorageLocation Sublocation
TransptSystNominationMaskText TransptSystNominationMaskText Nom/batch mask
TransportSystemShipperCode TransportSystemShipperCode Shipper
TransptSystCarrLeadTmeQty TransptSystCarrLeadTmeQty Carr.lead time
TransptSystConfLeadTmeUnt TransptSystConfLeadTmeUnt UoM
TransportationPlnPoint TransportationPlnPoint TransportPlanPt
ToleranceOverRate ToleranceOverRate Over %
ToleranceUnderRate ToleranceUnderRate Under %
TransptSystTolOvrQuantity TransptSystTolOvrQuantity Abs.tol.qty.ovr
PhysStkAbsltQtyTolUndrQty PhysStkAbsltQtyTolUndrQty Abs.tol.Q under
TransportSystemToleranceUnit TransportSystemToleranceUnit Abs.tol.UoM
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed Unlimited Tol.
TransptSystHasBalanceChecked TransptSystHasBalanceChecked Balance check
TransptSystTmpStorLoc TransptSystTmpStorLoc Clipboard LGORT
TransportSystemShipmentType TransportSystemShipmentType Single-Character Flag
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 Search Proced.
TransptSystOutpDetnProcedAppl TransptSystOutpDetnProcedAppl Application
TransptSystOutpDetnOutputType TransptSystOutpDetnOutputType Tax Item Type
MaxRatePerPeriodQuantity MaxRatePerPeriodQuantity Maximum rate
MinRatePerPeriodQuantity MinRatePerPeriodQuantity Minimum rate
OpgRatePerPeriodQuantity OpgRatePerPeriodQuantity operating rate
RateUnit RateUnit Rate unit
RateTimeUnit RateTimeUnit Time UoM
TransptSystHasLocSqnc TransptSystHasLocSqnc Loc seq index
MaxVolumePerPeriodQuantity MaxVolumePerPeriodQuantity Max Volume
MinVolumePerPeriodQuantity MinVolumePerPeriodQuantity Min Volume
UsageUnit UsageUnit Usage unit
UsageTimeUnit UsageTimeUnit Time UoM
TransptSystHasPplineBatActv TransptSystHasPplineBatActv Batch active
TransptSystAvgVelocityQty TransptSystAvgVelocityQty Avg velocity
TransptSystMaxVelocityQty TransptSystMaxVelocityQty Max velocity
TransptSystMinVelocityQty TransptSystMinVelocityQty Min velocity
RetailNetworkBusinessType RetailNetworkBusinessType Business type
TransportSystemVelocityUnit TransportSystemVelocityUnit Velocity UoM
TransptSystVelocityTimeUnit TransptSystVelocityTimeUnit Vel / Time
TransptSystRouteToleranceRatio TransptSystRouteToleranceRatio Route Tolerance
StockProjectionIsActive StockProjectionIsActive Loc SP Act
TransptSystHasTktActualization TransptSystHasTktActualization Actualize Sub-Item
_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
_PartnerRoleShipper _PartnerRoleShipper
_TransptSystTransptMode _TransptSystTransptMode
_TransptSystPlngMatl _TransptSystPlngMatl
_TransptSystLocAssgmt _TransptSystLocAssgmt
_TransptSystDsblMatl _TransptSystDsblMatl

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 R_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 R_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 I_OIL_TransportSystem
LEFT OUTER JOIN R_OIL_TransptSystTransptModeTP AS _TransptSystTransptMode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_OIL_TransptSystPlngMatlTP AS _TransptSystPlngMatl ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_OIL_TransptSystLocAssgmtTP AS _TransptSystLocAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_OIL_TransptDisallowedMatlTP AS _TransptSystDsblMatl ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More