What is C_PermitToWorkPartnerValueHelp in SAP S/4HANA?

C_PermitToWorkPartnerValueHelp is a consumption CDS view in SAP S/4HANA. PTW Profile specific BusinessPartnerData It contains 11 fields.

Which tables does C_PermitToWorkPartnerValueHelp read from?

C_PermitToWorkPartnerValueHelp reads data from: I_Customer, I_PartFuncByPartDetnProced, I_PermitToWorkProfile.

What VDM layer is C_PermitToWorkPartnerValueHelp?

C_PermitToWorkPartnerValueHelp is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PermitToWorkPartnerValueHelp

DDL: C_PERMITTOWORKPARTNERVALUEHELP SQL: CPERMITPARTNERVH Type: view CONSUMPTION

11 Fields 3 Data Sources 1 Associations 2 OData Services 3 Fiori Apps

PTW Profile specific BusinessPartnerData

C_PermitToWorkPartnerValueHelp is a Consumption CDS View that provides data about "PTW Profile specific BusinessPartnerData" in SAP S/4HANA. It reads from 3 data sources (I_Customer, I_PartFuncByPartDetnProced, I_PermitToWorkProfile) and exposes 11 fields with key fields PartnerDeterminationProcedure, PartnerFunction, MaintenancePlanningPlant, Partner. It has 1 association to related views. It is exposed through 2 OData services (UI_WORKPERMIT, UI_WORKPERMITTEMPLATE). It is used in 3 Fiori applications: Create Work Permit Request, Manage Work Permit Templates, Manage Work Permits.

Data Sources (3)

Source	Alias	Join Type
I_Customer	_Customer	inner
I_PartFuncByPartDetnProced	_PartnerDetProced	from
I_PermitToWorkProfile	_PermitProfileDetails	inner

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_PartnerFunction	_PartnerFunc	`_PartnerFunc.PartnerFunction = $projection.PartnerFunction`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CPERMITPARTNERVH	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#META	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	PTW Profile specific BusinessPartnerData	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.representativeKey	MaintenancePlanningPlant	view

OData Services (2)

Service	Binding	Version	Contract	Release
UI_WORKPERMIT	UI_WORKPERMIT	V2	C1	NOT_RELEASED
UI_WORKPERMITTEMPLATE	UI_WORKPERMITTEMPLATE	V2	C1	NOT_RELEASED

Fiori Apps (3)

App ID	App Name	Type	Description
F4691	Create Work Permit Request	Transactional	Work Permit is initiated during the planning of a maintenance activity and typically created from a predesigned template, together with the work order associated with the maintenance task. You can use this app to create new Work Permit.
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.
F6579	Manage Work Permits	Transactional	Work Permit is initiated during the planning of a maintenance activity and typically created from a predesigned template, together with the work order associated with the maintenance task. You can use this to search and maintain Work Permits.

Create Work Permit Request

Business Role: Maintenance Planner

The Create Work Permit Request app allows to create new work permit with reference to an existing maintenance order, a predesigned work permit template, or independently. It provides the abilities to perform the following operations:Allows to create and process new work permit using the optimized work permit management solutionProvides the ability to assign multiple functional locations, equipment, maintenance orders, partners, and attachments to enhance work permit with details related to the work activityAllows the configuration of the nature of work, personal protective equipment, and safety precautions to enhance work permit with safety protocols.Offers easy data validation and a simplified approval process that adheres to a four-eyes principleSupports the printing of work permit in the output form maintained by the userProvides the ability to extend the validity even after the creation of work permitSupports all operations relevant to work permit management such as approval, print, issue, return, close, deactivate, cancel, and mark for deletion.Provides the ability to view the records of data transfers using application logs

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

Manage Work Permits

Business Role: Maintenance Planner

The Manage Work Permits app allows you to create, manage, and monitor work permits and gain valuable insights about the progress of your maintenance operations. Using the app, new work permits can be created with reference to an existing maintenance order, a predesigned work permit template, or independently. It provides the following capabilities:Allows to create and process new work permit using the optimized work permit management solutionProvides the ability to assign multiple functional locations, equipment, maintenance orders, partners, and attachments to enhance work permit with details related to the work activityAllows the configuration of the nature of work, personal protective equipment, and safety precautions to enhance work permit with safety protocols.Offers easy data validation and a simplified approval process that adheres to a four-eyes principleSupports the printing of work permit in the output form maintained by the userProvides the ability to extend the validity even after the creation of work permitSupports all operations relevant to work permit management such as approval, print, issue, return, close, deactivate, cancel, and mark for deletion.Provides the ability to view the records of data transfers using application logs

Fields (11)

Key	Field	Source Table	Source Field	Description
KEY	PartnerDeterminationProcedure	I_PartFuncByPartDetnProced	PartnerDeterminationProcedure	Partner Det.Prc
KEY	PartnerFunction	I_PartFuncByPartDetnProced	PartnerFunction	Partner Functn
KEY	MaintenancePlanningPlant	I_PermitToWorkProfile	MaintenancePlanningPlant	Planning Plant
KEY	Partner	I_Customer	Customer	Sold-to Party
	PartnerFullName	I_Customer	CustomerFullName	Customer Name
	PartnerFunctionName
	Country	I_Customer	Country	Venue: Ctry/Reg
	CityName	I_Customer	CityName	Name
	PostalCode	I_Customer	PostalCode	Postal Code
	StreetName	I_Customer	StreetName	Text
	_PartnerFunc		_PartnerFunc

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 C_PermitToWorkPartnerValueHelp.
-- 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: CPERMITPARTNERVH

CREATE VIEW C_PermitToWorkPartnerValueHelp AS
SELECT
  _PartnerDetProced.PartnerDeterminationProcedure AS PartnerDeterminationProcedure,
  _PartnerDetProced.PartnerFunction AS PartnerFunction,
  _PermitProfileDetails.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _Customer.Customer AS Partner,
  _Customer.CustomerFullName AS PartnerFullName,
  _PartnerFunc._Text[ 1: Language = $session.system_language ].PartnerFunctionName AS PartnerFunctionName,
  _Customer.Country AS Country,
  _Customer.CityName AS CityName,
  _Customer.PostalCode AS PostalCode,
  _Customer.StreetName AS StreetName
FROM I_PartFuncByPartDetnProced AS _PartnerDetProced
INNER JOIN I_PermitToWorkProfile AS _PermitProfileDetails ON /* join condition not captured in parsed metadata */
INNER JOIN I_Customer AS _Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunc ON _PartnerFunc.PartnerFunction = PartnerFunction  -- association [1..1]
;

Depth:

C_PermitToWorkPartnerValueHelp view