R_PRATankStorObjCharcSgmtHdrTP

DDL: R_PRATANKSTOROBJCHARCSGMTHDRTP Type: view_entity TRANSACTIONAL Package: OIU_RAP_PRD_TANK
35 Fields 1 Data Sources 1 Associations

Tank Storage Object Segment Header

R_PRATankStorObjCharcSgmtHdrTP is a Transactional CDS View that provides data about "Tank Storage Object Segment Header" in SAP S/4HANA. It reads from 1 data source (I_PRAStorObjCharcsSgmtHdr) and exposes 35 fields with key field TankStorageObjUUID. It has 1 association to related views. Part of development package OIU_RAP_PRD_TANK.

Data Sources (1)

SourceAliasJoin Type
I_PRAStorObjCharcsSgmtHdr PRATankStorageObjectCharcsSgmt from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_PRATankCalibrnSetHdrTP _PRATankCalibrnSetHdr

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Tank Storage Object Segment Header view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name PRATankStorageObjectSegment view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY TankStorageObjUUID TankStorageObjUUID UUID
MeasurementPoint MeasurementPoint Measurement Pt
MeasurementPtName _MeasurementPoint MeasurementPtName MP descr.
StorageObjEquipmentNumber StorageObjEquipmentNumber Equipment
StorageObjectFunctionalLoc StorageObjectFunctionalLoc Funct.location
ManufacturerName ManufacturerName Manufacturer
CountryOrRegion CountryOrRegion Country/Reg.
ManufacturerDrawingNumber ManufacturerDrawingNumber Drawing no.
ManufacturerSerialNumber ManufacturerSerialNumber Mnf.serial no.
ManufacturerModelNumber ManufacturerModelNumber Model number
EquipmentYearOfManufacture EquipmentYearOfManufacture ConstructYear
EquipmentMonthOfManufacture EquipmentMonthOfManufacture ConstructMth
MaterialVolumeUoM MaterialVolumeUoM Volume UoM
MassUoMTank MassUoMTank UoM mass
TankDipTotalHeightUoM TankDipTotalHeightUoM Length UoM
FlowRateUnitOfMeasure FlowRateUnitOfMeasure UoM flow rate
UnitOfMeasureTemperatureUnit UnitOfMeasureTemperatureUnit UoM Temp
DensityUnitOfMeasure DensityUnitOfMeasure Density UoM
VolumePerHeightUnitOfMeasure VolumePerHeightUnitOfMeasure Vol/height UoM
DensityType DensityType Dens. Type
TankCapacity TankCapacity Max. capacity
OilTankMaximumSafetyWeight OilTankMaximumSafetyWeight Max.safety wgt.
OilTankStorageExpryDte OilTankStorageExpryDte Expiry date
OilTankStorageExpryTime OilTankStorageExpryTime Expiry time
OilTankExpiryReason OilTankExpiryReason Expiry reason
StorObjGroupName StorObjGroupName SO is group
PRACreationDateTime PRACreationDateTime Time Stamp
CreatedByUser CreatedByUser User Name
PRAChangeDateTime PRAChangeDateTime Time Stamp
OilTankDipChangedByUser OilTankDipChangedByUser Changed By
PRALoclLastChgdAtDateTime PRALoclLastChgdAtDateTime Time Stamp
Associations_PRATankCalibrnSetHdr
_MeasurementPoint _MeasurementPoint
_UnitOfMeasure _UnitOfMeasure
_Month _Month

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_PRATankStorObjCharcSgmtHdrTP.
-- 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_PRATankStorObjCharcSgmtHdrTP AS
SELECT
  TankStorageObjUUID,
  MeasurementPoint,
  _MeasurementPoint.MeasurementPtName AS MeasurementPtName,
  StorageObjEquipmentNumber,
  StorageObjectFunctionalLoc,
  ManufacturerName,
  CountryOrRegion,
  ManufacturerDrawingNumber,
  ManufacturerSerialNumber,
  ManufacturerModelNumber,
  EquipmentYearOfManufacture,
  EquipmentMonthOfManufacture,
  MaterialVolumeUoM,
  MassUoMTank,
  TankDipTotalHeightUoM,
  FlowRateUnitOfMeasure,
  UnitOfMeasureTemperatureUnit,
  DensityUnitOfMeasure,
  VolumePerHeightUnitOfMeasure,
  DensityType,
  TankCapacity,
  OilTankMaximumSafetyWeight,
  OilTankStorageExpryDte,
  OilTankStorageExpryTime,
  OilTankExpiryReason,
  StorObjGroupName,
  PRACreationDateTime,
  CreatedByUser,
  PRAChangeDateTime,
  OilTankDipChangedByUser,
  PRALoclLastChgdAtDateTime
FROM I_PRAStorObjCharcsSgmtHdr AS PRATankStorageObjectCharcsSgmt
LEFT OUTER JOIN R_PRATankCalibrnSetHdrTP AS _PRATankCalibrnSetHdr ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More