R_OIL_LocStorageObjectCharcTP

DDL: R_OIL_LOCSTORAGEOBJECTCHARCTP Type: view_entity TRANSACTIONAL
38 Fields 1 Data Sources 2 Associations

Loc Storage Object Characteristic - TP

R_OIL_LocStorageObjectCharcTP is a Transactional CDS View that provides data about "Loc Storage Object Characteristic - TP" in SAP S/4HANA. It reads from 1 data source (I_OIL_LocStorageObjectCharc) and exposes 38 fields with key fields BusinessLocationIdentifier, MktgRtlNtwkBusinessPartnerRole, BizLocStorObjectAssgmtSqncNmbr, StorObjectCharcSegmentNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_OIL_LocStorageObjectCharc I_OIL_LocStorageObjectCharc from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_OIL_StorageObjectCharcMatlTP _StorObjCharcMaterialTP
[0..*] R_OIL_StorageObjCharcAssgmtTP _StorObjCharcAssignmentTP

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Loc Storage Object Characteristic - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY BusinessLocationIdentifier BusinessLocationIdentifier Location ID
KEY MktgRtlNtwkBusinessPartnerRole MktgRtlNtwkBusinessPartnerRole Partner role
KEY BizLocStorObjectAssgmtSqncNmbr BizLocStorObjectAssgmtSqncNmbr Seq no.
KEY StorObjectCharcSegmentNumber StorObjectCharcSegmentNumber SOCSEG number
StorObjectCharacteristicClass _OIL_StorageObjCharcSegment StorObjectCharacteristicClass SOC class
StorageObjectType _OIL_StorageObjCharcSegment StorageObjectType Stor.obj.type
StorageObjectCapacity _OIL_StorageObjCharcSegment StorageObjectCapacity Max. capacity
TankVolumeUnitOfMeasure _OIL_StorageObjCharcSegment TankVolumeUnitOfMeasure Volume UoM
TankMassUnit _OIL_StorageObjCharcSegment TankMassUnit UoM mass
TankLengthUnit _OIL_StorageObjCharcSegment TankLengthUnit Length UoM
FlowRateUnitOfMeasure _OIL_StorageObjCharcSegment FlowRateUnitOfMeasure UoM flow rate
GenStorageObjectUsgeExpiryDate _OIL_StorageObjCharcSegment GenStorageObjectUsgeExpiryDate Expiry date
GenStorObjectUsgeExpiryReason _OIL_StorageObjCharcSegment GenStorObjectUsgeExpiryReason Expiry reason
GenStorageObjectUsgeExpiryTime _OIL_StorageObjCharcSegment GenStorageObjectUsgeExpiryTime Expiry time
StopGaugeCalculationRoutine _OIL_StorageObjCharcSegment StopGaugeCalculationRoutine Stp Gauge Routine
StorageObjectHasGroup _OIL_StorageObjCharcSegment StorageObjectHasGroup SO is group
StorObjEquipmentManufacturer _OIL_StorageObjCharcSegment StorObjEquipmentManufacturer Manufacturer
StorObjectYearOfConstruction _OIL_StorageObjCharcSegment StorObjectYearOfConstruction ConstructYear
ManufacturerModelNumber _OIL_StorageObjCharcSegment ManufacturerModelNumber Model number
ManufacturerSerialNumber _OIL_StorageObjCharcSegment ManufacturerSerialNumber Mnf.serial no.
ManufacturerCountry _OIL_StorageObjCharcSegment ManufacturerCountry Mnf. Cntry/Regn
StorObjectMonthOfConstruction _OIL_StorageObjCharcSegment StorObjectMonthOfConstruction ConstructMth
ManufacturerDrawingNumber _OIL_StorageObjCharcSegment ManufacturerDrawingNumber Drawing no.
StorageObjectMaxSafetyWeight _OIL_StorageObjCharcSegment StorageObjectMaxSafetyWeight Max.safety wgt.
SpecialAllowanceTime _StorObjCharcSegmentSilo SpecialAllowanceTime Sp.allow.time
OilTankMaximumContaminantPct _StorObjCharcSegmentSilo OilTankMaximumContaminantPct Max.contam. %
MaximumPermissibleDipQuantity _StorObjCharcSegmentBulk MaximumPermissibleDipQuantity Maximum dip
MinimumPermissibleDipQuantity _StorObjCharcSegmentBulk MinimumPermissibleDipQuantity Minimum dip
UnpumpableQuantity _StorObjCharcSegmentBulk UnpumpableQuantity Unp.qty.
UnpumpableQuantityInPct _StorObjCharcSegmentBulk UnpumpableQuantityInPct Unp.qty. %
OilTankMaxContaminantQtyInPct _StorObjCharcSegmentBulk OilTankMaxContaminantQtyInPct Max.contam. %
FloatingRoofWeight _StorObjCharcSegmentBulk FloatingRoofWeight Foat. roof w.
_BusinessLocationTP _BusinessLocationTP
_StorObjCharcMaterialTP _StorObjCharcMaterialTP
_StorObjCharcAssignmentTP _StorObjCharcAssignmentTP
_BusinessLocation _BusinessLocation
_BusinessPartnerRoleVH _BusinessPartnerRoleVH
_OIL_StorageObjCharcSegment _OIL_StorageObjCharcSegment

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_LocStorageObjectCharcTP.
-- 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_LocStorageObjectCharcTP AS
SELECT
  BusinessLocationIdentifier,
  MktgRtlNtwkBusinessPartnerRole,
  BizLocStorObjectAssgmtSqncNmbr,
  StorObjectCharcSegmentNumber,
  _OIL_StorageObjCharcSegment.StorObjectCharacteristicClass AS StorObjectCharacteristicClass,
  _OIL_StorageObjCharcSegment.StorageObjectType AS StorageObjectType,
  _OIL_StorageObjCharcSegment.StorageObjectCapacity AS StorageObjectCapacity,
  _OIL_StorageObjCharcSegment.TankVolumeUnitOfMeasure AS TankVolumeUnitOfMeasure,
  _OIL_StorageObjCharcSegment.TankMassUnit AS TankMassUnit,
  _OIL_StorageObjCharcSegment.TankLengthUnit AS TankLengthUnit,
  _OIL_StorageObjCharcSegment.FlowRateUnitOfMeasure AS FlowRateUnitOfMeasure,
  _OIL_StorageObjCharcSegment.GenStorageObjectUsgeExpiryDate AS GenStorageObjectUsgeExpiryDate,
  _OIL_StorageObjCharcSegment.GenStorObjectUsgeExpiryReason AS GenStorObjectUsgeExpiryReason,
  _OIL_StorageObjCharcSegment.GenStorageObjectUsgeExpiryTime AS GenStorageObjectUsgeExpiryTime,
  _OIL_StorageObjCharcSegment.StopGaugeCalculationRoutine AS StopGaugeCalculationRoutine,
  _OIL_StorageObjCharcSegment.StorageObjectHasGroup AS StorageObjectHasGroup,
  _OIL_StorageObjCharcSegment.StorObjEquipmentManufacturer AS StorObjEquipmentManufacturer,
  _OIL_StorageObjCharcSegment.StorObjectYearOfConstruction AS StorObjectYearOfConstruction,
  _OIL_StorageObjCharcSegment.ManufacturerModelNumber AS ManufacturerModelNumber,
  _OIL_StorageObjCharcSegment.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  _OIL_StorageObjCharcSegment.ManufacturerCountry AS ManufacturerCountry,
  _OIL_StorageObjCharcSegment.StorObjectMonthOfConstruction AS StorObjectMonthOfConstruction,
  _OIL_StorageObjCharcSegment.ManufacturerDrawingNumber AS ManufacturerDrawingNumber,
  _OIL_StorageObjCharcSegment.StorageObjectMaxSafetyWeight AS StorageObjectMaxSafetyWeight,
  _StorObjCharcSegmentSilo.SpecialAllowanceTime AS SpecialAllowanceTime,
  _StorObjCharcSegmentSilo.OilTankMaximumContaminantPct AS OilTankMaximumContaminantPct,
  _StorObjCharcSegmentBulk.MaximumPermissibleDipQuantity AS MaximumPermissibleDipQuantity,
  _StorObjCharcSegmentBulk.MinimumPermissibleDipQuantity AS MinimumPermissibleDipQuantity,
  _StorObjCharcSegmentBulk.UnpumpableQuantity AS UnpumpableQuantity,
  _StorObjCharcSegmentBulk.UnpumpableQuantityInPct AS UnpumpableQuantityInPct,
  _StorObjCharcSegmentBulk.OilTankMaxContaminantQtyInPct AS OilTankMaxContaminantQtyInPct,
  _StorObjCharcSegmentBulk.FloatingRoofWeight AS FloatingRoofWeight
FROM I_OIL_LocStorageObjectCharc
LEFT OUTER JOIN R_OIL_StorageObjectCharcMatlTP AS _StorObjCharcMaterialTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_OIL_StorageObjCharcAssgmtTP AS _StorObjCharcAssignmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More