I_ProductStorageProcTP

DDL: I_PRODUCTSTORAGEPROCTP Type: view_entity TRANSACTIONAL
24 Fields 1 Data Sources

I_ProductStorageProcTP is a Transactional CDS View in SAP S/4HANA. It reads from 1 data source (I_ProductStorageProc) and exposes 24 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject.

Data Sources (1)

SourceAliasJoin Type
I_ProductStorageProc I_ProductStorageProc from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
Product Product Product Sold
BaseUnit BaseUnit Unit of Measure
StorageBinInstruction StorageBinInstruction Container
StorageConditions StorageConditions Stor.conditions
TemperatureConditionInd TemperatureConditionInd Temperature
HazardousMaterialNumber HazardousMaterialNumber Haz. matl no.
NmbrOfGROrGISlipsToPrintQty NmbrOfGROrGISlipsToPrintQty Number of GR slips
LabelType LabelType Label Type
LabelForm LabelForm Label Form
MinRemainingShelfLife MinRemainingShelfLife Rem. Shelf Life
TotalShelfLife TotalShelfLife Tot. shelf life
TotalShelfLifeStoragePercent TotalShelfLifeStoragePercent Storage %
ShelfLifeExpirationDatePeriod ShelfLifeExpirationDatePeriod Period Ind.
ShelfLifeExprtnDateRndngRule ShelfLifeExprtnDateRndngRule Rounding rule
ProductExpirationDateCode ProductExpirationDateCode Expiration Date
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime Last Changed On
MDChgProcessValidationStatus MDChgProcessValidationStatus Val. Process Status
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary Modification
_Product _Product

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 I_ProductStorageProcTP.
-- 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 I_ProductStorageProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  Product,
  BaseUnit,
  StorageBinInstruction,
  StorageConditions,
  TemperatureConditionInd,
  HazardousMaterialNumber,
  NmbrOfGROrGISlipsToPrintQty,
  LabelType,
  LabelForm,
  MinRemainingShelfLife,
  TotalShelfLife,
  TotalShelfLifeStoragePercent,
  ShelfLifeExpirationDatePeriod,
  ShelfLifeExprtnDateRndngRule,
  ProductExpirationDateCode,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessValidationStatus,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary
FROM I_ProductStorageProc
;

Learn More