What is I_WorkPermitTemplateType in SAP S/4HANA?

I_WorkPermitTemplateType is a basic CDS view in SAP S/4HANA. Work Permit Template Type It contains 7 fields.

Which tables does I_WorkPermitTemplateType read from?

I_WorkPermitTemplateType reads data from: ptwpermittype.

What VDM layer is I_WorkPermitTemplateType?

I_WorkPermitTemplateType is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_WorkPermitTemplateType

DDL: I_WORKPERMITTEMPLATETYPE Type: view_entity BASIC Package: VDM_EAM_WCM_PERMIT_TO_WORK

7 Fields 1 Data Sources 2 Associations 2 OData Services 1 Fiori Apps

Work Permit Template Type

I_WorkPermitTemplateType is a Basic CDS View that provides data about "Work Permit Template Type" in SAP S/4HANA. It reads from 1 data source (ptwpermittype) and exposes 7 fields with key fields MaintenancePlanningPlant, WorkPermitType. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F4692, UI_WORKPERMITTEMPLATE). It is used in 1 Fiori application: Manage Work Permit Templates. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

Data Sources (1)

Source	Alias	Join Type
ptwpermittype	ptwpermittype	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_WorkPermitTypeText	_WorkPermitTypeText	`$projection.WorkPermitType = _WorkPermitTypeText.WorkPermitType and $projection.MaintenancePlanningPlant = _WorkPermitTypeText.MaintenancePlanningPlant and _WorkPermitTypeText.Language = $session.system_language`
[1..1]	I_PermitToWorkProfile	_PermitToWorkProfile	`$projection.MaintenancePlanningPlant = _PermitToWorkProfile.MaintenancePlanningPlant`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Search.searchable	true	view
EndUserText.label	Work Permit Template Type	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#BASIC	view
ObjectModel.representativeKey	WorkPermitType	view
Analytics.technicalName	IWRKPMTTMPLTYPE	view

OData Services (2)

Service	Binding	Version	Contract	Release
ASQL_F4692	ASQL_F4692		C2	NOT_RELEASED
UI_WORKPERMITTEMPLATE	UI_WORKPERMITTEMPLATE	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F4692	Manage Work Permit Templates	Transactional	Work permit template provides a predesigned structure that can be used to create work permits of consistent format. This can help you streamline the process when Permits for similar work are required to be created periodically. You can use this app to maintain the re-use library of templates to use them for creating actual work permits.

Manage Work Permit Templates

Business Role: Industrial Hygienist

The Manage Work Permit Templates app allows to create work permit templates as predesigned models for creating work permits. The templates can be used as they are, or easily modified while work permits are created. Usage of work permit templates can help to streamline the work permit creation process when identical work permits are generated often. The app can perform the following operations:Allows to create, process, and manage work permit templatesProvides the ability to assign multiple functional locations, equipment, partners, and attachmentsAllows the configuration of the nature of work, personal protective equipment, and safety precautionsOffers easy data validation and a simplified approval process that adheres to a four-eyes principleProvides the ability to view the records of data transfers using application logs

Fields (7)

Key	Field	Source Table	Source Field	Description
KEY	MaintenancePlanningPlant		iwerk	Planning Plant
KEY	WorkPermitType		workpermittype	Work Permit Type
	WorkPermitTypeDescription	_WorkPermitTypeText	WorkPermitTypeDescription	Work Permit Usg Desc
	_WorkPermitTypeText		_WorkPermitTypeText
	_PermitToWorkProfile		_PermitToWorkProfile
	InternalNumberRangeInterval		int_range	No. Range No.
	ExternalNumberRangeInterval		ext_range	No. Range No.

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_WorkPermitTemplateType.
-- 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_WorkPermitTemplateType AS
SELECT
  iwerk AS MaintenancePlanningPlant,
  WorkPermitType,
  _WorkPermitTypeText.WorkPermitTypeDescription AS WorkPermitTypeDescription,
  int_range AS InternalNumberRangeInterval,
  ext_range AS ExternalNumberRangeInterval
FROM ptwpermittype
LEFT OUTER JOIN I_WorkPermitTypeText AS _WorkPermitTypeText ON WorkPermitType = _WorkPermitTypeText.WorkPermitType AND MaintenancePlanningPlant = _WorkPermitTypeText.MaintenancePlanningPlant AND _WorkPermitTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PermitToWorkProfile AS _PermitToWorkProfile ON MaintenancePlanningPlant = _PermitToWorkProfile.MaintenancePlanningPlant  -- association [1..1]
;

Depth:

I_WorkPermitTemplateType view_entity

ptwpermittype