R_CmplRqRsltStorageStabilityTP

DDL: R_CMPLRQRSLTSTORAGESTABILITYTP Type: view_entity TRANSACTIONAL Package: EHSDS_CRPAT_HANDL_STORAGE
33 Fields 1 Data Sources 1 Associations

Storage Stability - TP

R_CmplRqRsltStorageStabilityTP is a Transactional CDS View that provides data about "Storage Stability - TP" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRsltStorageStability) and exposes 33 fields with key field StorageStbltyUUID. It has 1 association to related views. Part of development package EHSDS_CRPAT_HANDL_STORAGE.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltStorageStability I_CmplRqRsltStorageStability from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_CmplRqRsltStorStbltyRatgTP _CmplRqRsltStorStbltyRatgTP

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Storage Stability - TP view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY StorageStbltyUUID StorageStbltyUUID
CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
PCPrptySequence PCPrptySequence Sequence
StorageStbltyPerdLowrQty StorageStbltyPerdLowrQty
StorageStbltyPerdLowrQtyOptr StorageStbltyPerdLowrQtyOptr Operator of Lower Limit
StorageStbltyPerdLowrQtyTxt StorageStbltyPerdLowrQtyTxt
StorageStbltyPerdUprQty StorageStbltyPerdUprQty
StorageStbltyPerdUprQtyOptr StorageStbltyPerdUprQtyOptr Operator of Upper Limit
StorageStbltyPerdUprQtyTxt StorageStbltyPerdUprQtyTxt
StorageStbltyPerdUoM StorageStbltyPerdUoM Unit of Measurement
StorageStbltyTempLowrQty StorageStbltyTempLowrQty
StorageStbltyTempLowrQtyOptr StorageStbltyTempLowrQtyOptr Operator of Lower Limit
StorageStbltyTempLowrQtyTxt StorageStbltyTempLowrQtyTxt
StorageStbltyTempUprQty StorageStbltyTempUprQty
StorageStbltyTempUprQtyOptr StorageStbltyTempUprQtyOptr Operator of Upper Limit
StorageStbltyTempUprQtyTxt StorageStbltyTempUprQtyTxt
StorageStbltyTempUoM StorageStbltyTempUoM Unit of Measurement
StorStbltyBulkMassLowrQty StorStbltyBulkMassLowrQty
StorStbltyBulkMassLowrQtyTxt StorStbltyBulkMassLowrQtyTxt
StorStbltyBulkMassLowrQtyOptr StorStbltyBulkMassLowrQtyOptr Operator of Lower Limit
StorStbltyBulkMassUprQty StorStbltyBulkMassUprQty
StorStbltyBulkMassUprQtyTxt StorStbltyBulkMassUprQtyTxt
StorStbltyBulkMassUprQtyOptr StorStbltyBulkMassUprQtyOptr Operator of Upper Limit
StorageStbltyBulkMassUoM StorageStbltyBulkMassUoM Unit of Measurement
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_CmplRqRsltHndlgStorage _CmplRqRsltHndlgStorage
_CmplRqRsltStorStbltyRatgTP _CmplRqRsltStorStbltyRatgTP
_StorageStbltyPerdUoM _StorageStbltyPerdUoM
_StorageStbltyTempUoM _StorageStbltyTempUoM
_StorageStbltyBulkMassUoM _StorageStbltyBulkMassUoM

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_CmplRqRsltStorageStabilityTP.
-- 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_CmplRqRsltStorageStabilityTP AS
SELECT
  StorageStbltyUUID,
  CmplRqRsltUUID,
  PCPrptySequence,
  StorageStbltyPerdLowrQty,
  StorageStbltyPerdLowrQtyOptr,
  StorageStbltyPerdLowrQtyTxt,
  StorageStbltyPerdUprQty,
  StorageStbltyPerdUprQtyOptr,
  StorageStbltyPerdUprQtyTxt,
  StorageStbltyPerdUoM,
  StorageStbltyTempLowrQty,
  StorageStbltyTempLowrQtyOptr,
  StorageStbltyTempLowrQtyTxt,
  StorageStbltyTempUprQty,
  StorageStbltyTempUprQtyOptr,
  StorageStbltyTempUprQtyTxt,
  StorageStbltyTempUoM,
  StorStbltyBulkMassLowrQty,
  StorStbltyBulkMassLowrQtyTxt,
  StorStbltyBulkMassLowrQtyOptr,
  StorStbltyBulkMassUprQty,
  StorStbltyBulkMassUprQtyTxt,
  StorStbltyBulkMassUprQtyOptr,
  StorageStbltyBulkMassUoM,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_CmplRqRsltStorageStability
LEFT OUTER JOIN R_CmplRqRsltStorStbltyRatgTP AS _CmplRqRsltStorStbltyRatgTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More