What is I_ProductionHoldTP in SAP S/4HANA?

I_ProductionHoldTP is a transactional CDS view in SAP S/4HANA. Manage Production Hold It contains 83 fields.

Which tables does I_ProductionHoldTP read from?

I_ProductionHoldTP reads data from: P_ProductionHoldTP.

What VDM layer is I_ProductionHoldTP?

I_ProductionHoldTP is classified as a Transactional view that supports create, update, and delete operations.

I_ProductionHoldTP

DDL: I_PRODUCTIONHOLDTP SQL: IMPEPRODHOLDTP Type: view TRANSACTIONAL

83 Fields 1 Data Sources 4 Associations

Manage Production Hold

I_ProductionHoldTP is a Transactional CDS View that provides data about "Manage Production Hold" in SAP S/4HANA. It reads from 1 data source (P_ProductionHoldTP) and exposes 83 fields with key field ProductionHold. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_ProductionHoldTP	ProductionHold	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_User	_AppliedByUser	`$projection.ProductionHoldAppliedByUser = _AppliedByUser.UserID`
[1..1]	I_User	_ReleasedByUser	`$projection.ProductionHoldReleasedByUser = _ReleasedByUser.UserID`
[1..1]	I_User	_ApplyChangedByUser	`$projection.ProdnHoldApplyLastChgdByUsr = _ApplyChangedByUser.UserID`
[1..1]	I_User	_ReleaseChangedByUser	`$projection.ProdnHoldReleaseLastChgdByUsr = _ReleaseChangedByUser.UserID`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	IMPEPRODHOLDTP	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.compositionRoot	true	view
ObjectModel.transactionalProcessingEnabled	true	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view
ObjectModel.draftEnabled	false	view
ObjectModel.writeDraftPersistence	IMPEPHTPDRAFT	view
ObjectModel.writeActivePersistence	IMPEPRODHOLDTP	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#TRANSACTIONAL	view
EndUserText.label	Manage Production Hold	view

Fields (83)

Key	Field	Source Table	Source Field	Description
KEY	ProductionHold	P_ProductionHoldTP	ProductionHold
	ProductionHoldObjectType	P_ProductionHoldTP	ProductionHoldObjectType
	MfgObjectType	P_ProductionHoldTP	MfgObjectType
	ProductionHoldObjectTypeName
	ProductionHoldObject
	ProdnHoldObjectDescription
	ProductionPlant	P_ProductionHoldTP	ProductionPlant	Prod plnt
	Material	P_ProductionHoldTP	Material	Vehicle Model
	MaterialName
	WorkCenterInternalID	P_ProductionHoldTP	WorkCenterInternalID	Work Center
	WorkCenterTypeCode	P_ProductionHoldTP	WorkCenterTypeCode	Object Type
	WorkCenter	P_ProductionHoldTP	WorkCenter	Work Center
	WorkCenterText	P_ProductionHoldTP	WorkCenterText	Work Center Text
	ManufacturingOrder	P_ProductionHoldTP	ManufacturingOrder	Order
	OrderInternalID	P_ProductionHoldTP	OrderInternalID	Plan No.f.Oper.
	OrderOperationInternalID	P_ProductionHoldTP	OrderOperationInternalID
	ManufacturingOrderSequence	P_ProductionHoldTP	ManufacturingOrderSequence
	ManufacturingOrderOperation	P_ProductionHoldTP	ManufacturingOrderOperation	Activity
	OperationText	P_ProductionHoldTP	OperationText	Description
	ShopFloorItem	P_ProductionHoldTP	ShopFloorItem	Serial.Mat. ID
	SerialNumber	P_ProductionHoldTP	SerialNumber	Serial Number
	OpActyNtwkInstance	P_ProductionHoldTP	OpActyNtwkInstance	Instance ID
	OpActyNtwkElement	P_ProductionHoldTP	OpActyNtwkElement	Element Number
	OperationActivitySFIGroup	P_ProductionHoldTP	OperationActivitySFIGroup
	OpActySFIGroupName	P_ProductionHoldTP	OpActySFIGroupName
	OperationActivityName	P_ProductionHoldTP	OperationActivityName
	OpActyNtwkElementExternalID	P_ProductionHoldTP	OpActyNtwkElementExternalID	Op. Activity
	ProductionHoldStartDateTime	P_ProductionHoldTP	ProductionHoldStartDateTime
	ProductionHoldEndDateTime	P_ProductionHoldTP	ProductionHoldEndDateTime
	ProductionHoldStatus	P_ProductionHoldTP	ProductionHoldStatus
	ProductionHoldStatusName	P_ProductionHoldTP	ProductionHoldStatusName
	HoldDurationInSeconds	P_ProductionHoldTP	HoldDurationInSeconds
	CalendarBasedNetDurnInSeconds	P_ProductionHoldTP	CalendarBasedNetDurnInSeconds
	WorkCenterBsdNetDurnInSeconds	P_ProductionHoldTP	WorkCenterBsdNetDurnInSeconds
	CalendarBasedNetDuration
	DurationUnit
	StatusIsActive	P_ProductionHoldTP	StatusIsActive
	MfgExecDocNoteIsExisting	P_ProductionHoldTP	MfgExecDocNoteIsExisting
	ProdnHoldAppliedByUserName	_AppliedByUser	UserDescription	Full Name
	ProdnHoldApplyRsnCodeGrpCtlg	P_ProductionHoldTP	ProdnHoldApplyRsnCodeGrpCtlg
	ProdnHoldApplyRsnCodeGroup	P_ProductionHoldTP	ProdnHoldApplyRsnCodeGroup
	ProductionHoldApplyReasonCode	P_ProductionHoldTP	ProductionHoldApplyReasonCode
	ProdnHoldApplyReasonCodeName	P_ProductionHoldTP	ProdnHoldApplyReasonCodeName
	ProductionHoldApplyNote	P_ProductionHoldTP	ProductionHoldApplyNote
	ProdnHoldApplyLastChgdByUsr	P_ProductionHoldTP	ProdnHoldApplyLastChgdByUsr
	ProdnHoldApplyLstChgByUsrName	_ApplyChangedByUser	UserDescription	Full Name
	ProdnHoldApplyLastChgdDteTme	P_ProductionHoldTP	ProdnHoldApplyLastChgdDteTme
	ProdnHoldReleasedByUserName	_ReleasedByUser	UserDescription	Full Name
	ProdnHoldRelRsnCodeGrpCtlg	P_ProductionHoldTP	ProdnHoldRelRsnCodeGrpCtlg
	ProdnHoldRelRsnCodeGroup	P_ProductionHoldTP	ProdnHoldRelRsnCodeGroup
	ProductionHoldRelReasonCode	P_ProductionHoldTP	ProductionHoldRelReasonCode
	ProdnHoldRelReasonCodeName	P_ProductionHoldTP	ProdnHoldRelReasonCodeName
	ProductionHoldReleaseNote	P_ProductionHoldTP	ProductionHoldReleaseNote
	ProdnHoldReleaseLastChgdByUsr	P_ProductionHoldTP	ProdnHoldReleaseLastChgdByUsr
	ProdnHoldRelLastChgdByUsrName	_ReleaseChangedByUser	UserDescription	Full Name
	ProdnHoldReleaseLastChgdDteTme	P_ProductionHoldTP	ProdnHoldReleaseLastChgdDteTme
	DefectInternalIDasDefectInternalID
	Notification	P_ProductionHoldTP	Notification	Notification
	NotificationItem	P_ProductionHoldTP	NotificationItem
	ProdnHoldApplyNoteRequirement
	ProdnHoldApplyRsnCodeRqmt
	ProdnHoldRelSttgRsnCodeGroup
	ProdnHoldRelNoteRequirement
	ProdnHoldRelRsnCodeRqmt
	ProdnHoldIsAppldForOrderChg	P_ProductionHoldTP	ProdnHoldIsAppldForOrderChg
	_ProductionHoldObjectType
	_ProductionHoldStatus	P_ProductionHoldTP	_ProductionHoldStatus
	_ProductionPlant	P_ProductionHoldTP	_ProductionPlant
	_Material	P_ProductionHoldTP	_Material
	_WorkCenter	P_ProductionHoldTP	_WorkCenter
	_WorkCenterBySemanticKey	P_ProductionHoldTP	_WorkCenterBySemanticKey
	_MfgOrder	P_ProductionHoldTP	_MfgOrder
	_MfgOrderOperation	P_ProductionHoldTP	_MfgOrderOperation
	_ShopFloorItem	P_ProductionHoldTP	_ShopFloorItem
	_OpActyNtwkInstance	P_ProductionHoldTP	_OpActyNtwkInstance
	_OperationActivityInstance	P_ProductionHoldTP	_OperationActivityInstance
	_OperationActivitySFIGroup	P_ProductionHoldTP	_OperationActivitySFIGroup
	_AppliedByUser		_AppliedByUser
	_ReleasedByUser		_ReleasedByUser
	_ApplyChangedByUser		_ApplyChangedByUser
	_ReleaseChangedByUser		_ReleaseChangedByUser
	_Notification	P_ProductionHoldTP	_Notification
	_Defect	P_ProductionHoldTP	_Defect

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_ProductionHoldTP.
-- 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: IMPEPRODHOLDTP

CREATE VIEW I_ProductionHoldTP AS
SELECT
  ProductionHold.ProductionHold AS ProductionHold,
  ProductionHold.ProductionHoldObjectType AS ProductionHoldObjectType,
  ProductionHold.MfgObjectType AS MfgObjectType,
  ProductionHold._ProductionHoldObjectType._Text[1: Language=$session.system_language].ProductionHoldObjectTypeName AS ProductionHoldObjectTypeName,
  cast (' ' as mpe_hold_object) AS ProductionHoldObject,
  cast(' ' as mpe_hold_object_name) AS ProdnHoldObjectDescription,
  ProductionHold.ProductionPlant AS ProductionPlant,
  ProductionHold.Material AS Material,
  ProductionHold._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ProductionHold.WorkCenterInternalID AS WorkCenterInternalID,
  ProductionHold.WorkCenterTypeCode AS WorkCenterTypeCode,
  ProductionHold.WorkCenter AS WorkCenter,
  ProductionHold.WorkCenterText AS WorkCenterText,
  ProductionHold.ManufacturingOrder AS ManufacturingOrder,
  ProductionHold.OrderInternalID AS OrderInternalID,
  ProductionHold.OrderOperationInternalID AS OrderOperationInternalID,
  ProductionHold.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  ProductionHold.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  ProductionHold.OperationText AS OperationText,
  ProductionHold.ShopFloorItem AS ShopFloorItem,
  ProductionHold.SerialNumber AS SerialNumber,
  ProductionHold.OpActyNtwkInstance AS OpActyNtwkInstance,
  ProductionHold.OpActyNtwkElement AS OpActyNtwkElement,
  ProductionHold.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  ProductionHold.OpActySFIGroupName AS OpActySFIGroupName,
  ProductionHold.OperationActivityName AS OperationActivityName,
  ProductionHold.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  ProductionHold.ProductionHoldStartDateTime AS ProductionHoldStartDateTime,
  ProductionHold.ProductionHoldEndDateTime AS ProductionHoldEndDateTime,
  ProductionHold.ProductionHoldStatus AS ProductionHoldStatus,
  ProductionHold.ProductionHoldStatusName AS ProductionHoldStatusName,
  ProductionHold.HoldDurationInSeconds AS HoldDurationInSeconds,
  ProductionHold.CalendarBasedNetDurnInSeconds AS CalendarBasedNetDurnInSeconds,
  ProductionHold.WorkCenterBsdNetDurnInSeconds AS WorkCenterBsdNetDurnInSeconds,
  cast(0 as mpe_hold_net_calendar_durn) AS CalendarBasedNetDuration,
  cast('' as durationunit) AS DurationUnit,
  ProductionHold.StatusIsActive AS StatusIsActive,
  ProductionHold.MfgExecDocNoteIsExisting AS MfgExecDocNoteIsExisting,
  _AppliedByUser.UserDescription AS ProdnHoldAppliedByUserName,
  ProductionHold.ProdnHoldApplyRsnCodeGrpCtlg AS ProdnHoldApplyRsnCodeGrpCtlg,
  ProductionHold.ProdnHoldApplyRsnCodeGroup AS ProdnHoldApplyRsnCodeGroup,
  ProductionHold.ProductionHoldApplyReasonCode AS ProductionHoldApplyReasonCode,
  ProductionHold.ProdnHoldApplyReasonCodeName AS ProdnHoldApplyReasonCodeName,
  ProductionHold.ProductionHoldApplyNote AS ProductionHoldApplyNote,
  ProductionHold.ProdnHoldApplyLastChgdByUsr AS ProdnHoldApplyLastChgdByUsr,
  _ApplyChangedByUser.UserDescription AS ProdnHoldApplyLstChgByUsrName,
  ProductionHold.ProdnHoldApplyLastChgdDteTme AS ProdnHoldApplyLastChgdDteTme,
  _ReleasedByUser.UserDescription AS ProdnHoldReleasedByUserName,
  ProductionHold.ProdnHoldRelRsnCodeGrpCtlg AS ProdnHoldRelRsnCodeGrpCtlg,
  ProductionHold.ProdnHoldRelRsnCodeGroup AS ProdnHoldRelRsnCodeGroup,
  ProductionHold.ProductionHoldRelReasonCode AS ProductionHoldRelReasonCode,
  ProductionHold.ProdnHoldRelReasonCodeName AS ProdnHoldRelReasonCodeName,
  ProductionHold.ProductionHoldReleaseNote AS ProductionHoldReleaseNote,
  ProductionHold.ProdnHoldReleaseLastChgdByUsr AS ProdnHoldReleaseLastChgdByUsr,
  _ReleaseChangedByUser.UserDescription AS ProdnHoldRelLastChgdByUsrName,
  ProductionHold.ProdnHoldReleaseLastChgdDteTme AS ProdnHoldReleaseLastChgdDteTme,
  ProductionHold.Notification AS Notification,
  ProductionHold.NotificationItem AS NotificationItem,
  ProductionHold._ApplyActionSetting.MfgActionNoteRequirement AS ProdnHoldApplyNoteRequirement,
  ProductionHold._ApplyActionSetting.MfgActionReasonCodeRequirement AS ProdnHoldApplyRsnCodeRqmt,
  ProductionHold._ReleaseActionSetting.MfgActionReasonCodeGroup AS ProdnHoldRelSttgRsnCodeGroup,
  ProductionHold._ReleaseActionSetting.MfgActionNoteRequirement AS ProdnHoldRelNoteRequirement,
  ProductionHold._ReleaseActionSetting.MfgActionReasonCodeRequirement AS ProdnHoldRelRsnCodeRqmt,
  ProductionHold.ProdnHoldIsAppldForOrderChg AS ProdnHoldIsAppldForOrderChg,
  ProductionHold._ProductionHoldStatus AS _ProductionHoldStatus,
  ProductionHold._ProductionPlant AS _ProductionPlant,
  ProductionHold._Material AS _Material,
  ProductionHold._WorkCenter AS _WorkCenter,
  ProductionHold._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  ProductionHold._MfgOrder AS _MfgOrder,
  ProductionHold._MfgOrderOperation AS _MfgOrderOperation,
  ProductionHold._ShopFloorItem AS _ShopFloorItem,
  ProductionHold._OpActyNtwkInstance AS _OpActyNtwkInstance,
  ProductionHold._OperationActivityInstance AS _OperationActivityInstance,
  ProductionHold._OperationActivitySFIGroup AS _OperationActivitySFIGroup,
  ProductionHold._Notification AS _Notification,
  ProductionHold._Defect AS _Defect
FROM P_ProductionHoldTP AS ProductionHold
LEFT OUTER JOIN I_User AS _AppliedByUser ON ProductionHoldAppliedByUser = _AppliedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ReleasedByUser ON ProductionHoldReleasedByUser = _ReleasedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ApplyChangedByUser ON ProdnHoldApplyLastChgdByUsr = _ApplyChangedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ReleaseChangedByUser ON ProdnHoldReleaseLastChgdByUsr = _ReleaseChangedByUser.UserID  -- association [1..1]
;

Depth:

I_ProductionHoldTP view

P_ProductionHoldTP view

C_ProductionHoldTP view