I_ProductReplenishmentTP

DDL: I_PRODUCTREPLENISHMENTTP SQL: IPRODREPLNMTTP Type: view TRANSACTIONAL Package: VDM_MD_PRODUCT
10 Fields 1 Data Sources 1 Associations

TP View - Product Replenishment (draft)

I_ProductReplenishmentTP is a Transactional CDS View that provides data about "TP View - Product Replenishment (draft)" in SAP S/4HANA. It reads from 1 data source (I_ProductReplenishment) and exposes 10 fields with key fields Product, ProdReplnmtRqmtGroup. It has 1 association to related views. Part of development package VDM_MD_PRODUCT.

Data Sources (1)

SourceAliasJoin Type
I_ProductReplenishment I_ProductReplenishment from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProductWD _Product $projection.Product = _Product.Product

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPRODREPLNMTTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP View - Product Replenishment (draft) view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PROD_REPLNMT view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
KEY ProdReplnmtRqmtGroup ProdReplnmtRqmtGroup
ProdReplnmtRqmtGroupForEdit ProdReplnmtRqmtGroup
ProdReplnmtTgtStkQuantity ProdReplnmtTgtStkQuantity Target stock
ReorderThresholdQuantity ReorderThresholdQuantity Reorder Point
SafetyStockQuantity SafetyStockQuantity Safety stock
ProdReplnmtMinTgtStockQuantity ProdReplnmtMinTgtStockQuantity Min. target stk
ProdReplnmtMaxTgtStockQuantity ProdReplnmtMaxTgtStockQuantity Upper Limit
BaseUnit BaseUnit Unit of Measure
_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_ProductReplenishmentTP.
-- 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.
-- SQL view name: IPRODREPLNMTTP

CREATE VIEW I_ProductReplenishmentTP AS
SELECT
  Product,
  ProdReplnmtRqmtGroup,
  ProdReplnmtRqmtGroup AS ProdReplnmtRqmtGroupForEdit,
  ProdReplnmtTgtStkQuantity,
  ReorderThresholdQuantity,
  SafetyStockQuantity,
  ProdReplnmtMinTgtStockQuantity,
  ProdReplnmtMaxTgtStockQuantity,
  BaseUnit
FROM I_ProductReplenishment
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
;

Learn More