C_PRATankCalibrnSetHdrTP

DDL: C_PRATANKCALIBRNSETHDRTP Type: view_entity CONSUMPTION

Tank Calibration Header for Projection

C_PRATankCalibrnSetHdrTP is a Consumption CDS View that provides data about "Tank Calibration Header for Projection" in SAP S/4HANA. It reads from 1 data source (R_PRATankCalibrnSetHdrTP) and exposes 48 fields with key field TankStrappingHdrUUID. It is exposed through 1 OData service (UI_PRATANKSTOROBJ_MANAGE). It is used in 1 Fiori application: Tank Strapping.

Data Sources (1)

SourceAliasJoin Type
R_PRATankCalibrnSetHdrTP R_PRATankCalibrnSetHdrTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Tank Calibration Header for Projection view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
Search.searchable false view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRATANKSTOROBJ_MANAGE UI_PRATANKSTOROBJ_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5516 Tank Strapping Transactional An Application to maintain Tank Strapping information. Tank strapping is the process whereby the quantity of a material in a storage object such as Measurement Point can be determined from the depth of material in that storage object.

Tank Strapping

Business Role: Hydrocarbon Analyst (Oil & Gas)

With Tank Strapping app, you can assign Measurement Points to Tanks, Create Tank Strapping (i.e. Calibration) readings. The Tank strapping information will be used during the Measurement Point volume creation for the Measurement Points that are assigned to Tanks via Tank Strapping Application.

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY TankStrappingHdrUUID TankStrappingHdrUUID
TankStorageObjUUID TankStorageObjUUID UUID
MeasurementPoint _PRATankStorObjCharcSgmtHdr MeasurementPoint Measurement Pt
MeasurementPtName _PRATankStorObjCharcSgmtHdr MeasurementPtName MP descr.
TankStrappingEffctvFrmDate TankStrappingEffctvFrmDate
TankStrappingEffctvToDate TankStrappingEffctvToDate
TankStrappingUoMNmbrOfDecimals TankStrappingUoMNmbrOfDecimals
FlowRateUnitOfMeasure FlowRateUnitOfMeasure UoM flow rate
OilTankMaximumInFlowQty OilTankMaximumInFlowQty Max. inflow
OilTankMaximumOutFlowQty OilTankMaximumOutFlowQty Max. outflow
OilTankMaximumContaminantQty OilTankMaximumContaminantQty Max.contam.qty.
OilTankMaximumContaminantPct OilTankMaximumContaminantPct Max.contam. %
ThermalExpansionIsSelected ThermalExpansionIsSelected
FloatingRoofCrrtnIsSelected FloatingRoofCrrtnIsSelected
WaterCorrectionIsSelected WaterCorrectionIsSelected
DippingMethodInnageUllage DippingMethodInnageUllage
TankThrmlInsulationIsSelected TankThrmlInsulationIsSelected
MaximumHeight MaximumHeight
MinimumHeight MinimumHeight
UnpumpableQuantity UnpumpableQuantity Unp.qty.
UnpumpableQuantityInPct UnpumpableQuantityInPct Unp.qty. %
FloatingRoofWeight FloatingRoofWeight Foat. roof w.
ThermalExpansionCoefficientVal ThermalExpansionCoefficientVal
TankDipTotalHeight TankDipTotalHeight
OilTankCalibrationTemperature OilTankCalibrationTemperature
OilTankCalibrationLqdDens OilTankCalibrationLqdDens
OilTankCalibratorName OilTankCalibratorName
OilTankCalibrationDate OilTankCalibrationDate
MinimumFloatingRoofHeight MinimumFloatingRoofHeight
TankCapacity TankCapacity Max. capacity
NumberOfInchesIncrements NumberOfInchesIncrements
MaterialVolumeUoM MaterialVolumeUoM Volume UoM
MassUoMTank MassUoMTank UoM mass
TankDipTotalHeightUoM TankDipTotalHeightUoM Length UoM
VolumePerHeightUnitOfMeasure VolumePerHeightUnitOfMeasure Vol/height UoM
DisplayTimeUnit DisplayTimeUnit
UnitOfMeasureTemperatureUnit UnitOfMeasureTemperatureUnit UoM Temp
UnitForDensity UnitForDensity
DensityType DensityType Dens. Type
PRALoclLastChgdAtDateTime PRALoclLastChgdAtDateTime Time Stamp
TankDippingMethodText
MassUoMTankTxt
TankDipTotalHeightUoMTxt
TemperatureUoMTxt
VolumePerHeightUoMTxt
DensityUoMTxt
FlowRateUoMTxt
MaterialVolumeUoMTxt

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_PRATankCalibrnSetHdrTP.
-- 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_PRATankCalibrnSetHdrTP AS
SELECT
  TankStrappingHdrUUID,
  TankStorageObjUUID,
  _PRATankStorObjCharcSgmtHdr.MeasurementPoint AS MeasurementPoint,
  _PRATankStorObjCharcSgmtHdr.MeasurementPtName AS MeasurementPtName,
  TankStrappingEffctvFrmDate,
  TankStrappingEffctvToDate,
  TankStrappingUoMNmbrOfDecimals,
  FlowRateUnitOfMeasure,
  OilTankMaximumInFlowQty,
  OilTankMaximumOutFlowQty,
  OilTankMaximumContaminantQty,
  OilTankMaximumContaminantPct,
  ThermalExpansionIsSelected,
  FloatingRoofCrrtnIsSelected,
  WaterCorrectionIsSelected,
  DippingMethodInnageUllage,
  TankThrmlInsulationIsSelected,
  MaximumHeight,
  MinimumHeight,
  UnpumpableQuantity,
  UnpumpableQuantityInPct,
  FloatingRoofWeight,
  ThermalExpansionCoefficientVal,
  TankDipTotalHeight,
  OilTankCalibrationTemperature,
  OilTankCalibrationLqdDens,
  OilTankCalibratorName,
  OilTankCalibrationDate,
  MinimumFloatingRoofHeight,
  TankCapacity,
  NumberOfInchesIncrements,
  MaterialVolumeUoM,
  MassUoMTank,
  TankDipTotalHeightUoM,
  VolumePerHeightUnitOfMeasure,
  DisplayTimeUnit,
  UnitOfMeasureTemperatureUnit,
  UnitForDensity,
  DensityType,
  PRALoclLastChgdAtDateTime,
  _PRATankDippingMeth._PRATankDippingMethTxt[1: Language=$session.system_language].TankDippingMethodText AS TankDippingMethodText,
  _PRAMassUoMTank._Text[1:Language=$session.system_language].UnitOfMeasureName AS MassUoMTankTxt,
  _PRALengthUoM._Text[1:Language=$session.system_language].UnitOfMeasureName AS TankDipTotalHeightUoMTxt,
  _PRATempUoM._Text[1:Language=$session.system_language].UnitOfMeasureName AS TemperatureUoMTxt,
  _PRAVolPerHgtUoM._Text[1:Language=$session.system_language].UnitOfMeasureName AS VolumePerHeightUoMTxt,
  _PRADenUoM._Text[1:Language=$session.system_language].UnitOfMeasureName AS DensityUoMTxt,
  _PRAFlowRateUoM._Text[1:Language=$session.system_language].UnitOfMeasureName AS FlowRateUoMTxt,
  _UnitOfMeasure._Text[1:Language=$session.system_language].UnitOfMeasureName AS MaterialVolumeUoMTxt
FROM R_PRATankCalibrnSetHdrTP
;