R_IsltnCertificatePartnerTP

DDL: R_ISLTNCERTIFICATEPARTNERTP Type: view_entity TRANSACTIONAL
34 Fields 2 Data Sources 9 Associations

Isolation Certificate Partner - TP

R_IsltnCertificatePartnerTP is a Transactional CDS View that provides data about "Isolation Certificate Partner - TP" in SAP S/4HANA. It reads from 2 data sources (I_PlantMaintenancePartner, I_SafetyCertificate) and exposes 34 fields with key fields MaintObjectInternalID, PartnerFunction, MaintenancePartnerObjectNumber. It has 9 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_PlantMaintenancePartner I_PlantMaintenancePartner inner
I_SafetyCertificate I_SafetyCertificate from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_PartnerFunctionText _PartnerFunctionText $projection.PartnerFunction = _PartnerFunctionText.PartnerFunction and _PartnerFunctionText.Language = $session.system_language
[0..1] I_PartnerFunction _PartnerFunction _PartnerFunction.PartnerFunction = $projection.PartnerFunction
[0..1] I_PMPersonResponsible _PMPersonResponsible $projection.PersonResponsible = _PMPersonResponsible.PersonnelNumber
[0..1] I_Customer_VH _CustomerVH $projection.CustomerResponsible = _CustomerVH.Customer
[0..1] I_Supplier_VH _SupplierVH $projection.SupplierResponsible = _SupplierVH.Supplier
[0..1] I_PMUserResponsible _PMUserResponsible $projection.UserResponsible = _PMUserResponsible.UserID
[0..1] I_PMContactPerson _PMContactPerson $projection.MaintenancePartner = _PMContactPerson.ContactPerson
[0..1] I_PMPositionResponsible _PMPositionResponsible $projection.PositionResponsible = _PMPositionResponsible.PositionResponsible
[0..1] I_PMDepartmentResponsible _PMDepartmentResponsible $projection.DepartmentResponsible = _PMDepartmentResponsible.DepartmentResponsible

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Isolation Certificate Partner - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
Metadata.ignorePropagatedAnnotations true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY MaintObjectInternalID I_SafetyCertificate SafetyCertificateInternalID Object number
KEY PartnerFunction
KEY MaintenancePartnerObjectNumber I_PlantMaintenancePartner MaintenancePartnerObjectNumber Counter
IsolationCertificate I_SafetyCertificate SafetyCertificate WC Document
IsolationCertificateType I_SafetyCertificate SafetyCertificateType Usage
MaintenancePlanningPlant I_SafetyCertificate MaintenancePlanningPlant Planning Plant
CustomerResponsible I_PlantMaintenancePartner MaintenancePartner Partner
SupplierResponsible I_PlantMaintenancePartner MaintenancePartner Partner
Customer
PersonResponsible I_PlantMaintenancePartner MaintenancePartner Partner
ContactPersonResponsible I_PlantMaintenancePartner MaintenancePartner Partner
UserResponsible I_PlantMaintenancePartner MaintenancePartner Partner
PositionResponsible I_PlantMaintenancePartner MaintenancePartner Partner
DepartmentResponsible I_PlantMaintenancePartner MaintenancePartner Partner
MaintenancePartner I_PlantMaintenancePartner MaintenancePartner Partner
MaintObjectCategory I_PlantMaintenancePartner MaintObjectCategory Object Type
IsltnCertPartnerIsDeleted
CreatedByUser I_PlantMaintenancePartner CreatedByUser User Name
CreationDate I_PlantMaintenancePartner CreationDate Time Stamp
CreationTime I_PlantMaintenancePartner CreationTime Time of Change
LastChangeDate I_PlantMaintenancePartner LastChangeDate Time Stamp
LastChangeTime I_PlantMaintenancePartner LastChangeTime Time changed
LastChangedByUser I_PlantMaintenancePartner LastChangedByUser User Name
SDDocumentPartnerType
_IsolationCertificate _IsolationCertificate
_PartnerFunctionText _PartnerFunctionText
_PartnerFunction _PartnerFunction
BPCustomerName _CustomerVH BPCustomerName Name of Customer
BPSupplierName _SupplierVH BPSupplierName Supplier Name
PersonResponsibleName _PMPersonResponsible FullName Name
UserName _PMUserResponsible FullName Name
ContactPersonName _PMContactPerson FullName Name
HCMEmployeePositionText _PMPositionResponsible HCMEmployeePositionText Object abbr.
HCMOrganizationalUnitText _PMDepartmentResponsible OrganizationalUnitShortName

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 R_IsltnCertificatePartnerTP.
-- 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 R_IsltnCertificatePartnerTP AS
SELECT
  I_SafetyCertificate.SafetyCertificateInternalID AS MaintObjectInternalID,
  cast(I_PlantMaintenancePartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  I_PlantMaintenancePartner.MaintenancePartnerObjectNumber AS MaintenancePartnerObjectNumber,
  I_SafetyCertificate.SafetyCertificate AS IsolationCertificate,
  I_SafetyCertificate.SafetyCertificateType AS IsolationCertificateType,
  I_SafetyCertificate.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_PlantMaintenancePartner.MaintenancePartner AS CustomerResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS SupplierResponsible,
  I_PlantMaintenancePartner._ContactPerson.Customer AS Customer,
  I_PlantMaintenancePartner.MaintenancePartner AS PersonResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS ContactPersonResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS UserResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS PositionResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS DepartmentResponsible,
  I_PlantMaintenancePartner.MaintenancePartner AS MaintenancePartner,
  I_PlantMaintenancePartner.MaintObjectCategory AS MaintObjectCategory,
  cast( ' ' as kzloesch) AS IsltnCertPartnerIsDeleted,
  I_PlantMaintenancePartner.CreatedByUser AS CreatedByUser,
  I_PlantMaintenancePartner.CreationDate AS CreationDate,
  I_PlantMaintenancePartner.CreationTime AS CreationTime,
  I_PlantMaintenancePartner.LastChangeDate AS LastChangeDate,
  I_PlantMaintenancePartner.LastChangeTime AS LastChangeTime,
  I_PlantMaintenancePartner.LastChangedByUser AS LastChangedByUser,
  I_PlantMaintenancePartner._PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  _CustomerVH.BPCustomerName AS BPCustomerName,
  _SupplierVH.BPSupplierName AS BPSupplierName,
  _PMPersonResponsible.FullName AS PersonResponsibleName,
  _PMUserResponsible.FullName AS UserName,
  _PMContactPerson.FullName AS ContactPersonName,
  _PMPositionResponsible.HCMEmployeePositionText AS HCMEmployeePositionText,
  _PMDepartmentResponsible.OrganizationalUnitShortName AS HCMOrganizationalUnitText
FROM I_SafetyCertificate
INNER JOIN I_PlantMaintenancePartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PartnerFunctionText AS _PartnerFunctionText ON PartnerFunction = _PartnerFunctionText.PartnerFunction AND _PartnerFunctionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON _PartnerFunction.PartnerFunction = PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_PMPersonResponsible AS _PMPersonResponsible ON PersonResponsible = _PMPersonResponsible.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_Customer_VH AS _CustomerVH ON CustomerResponsible = _CustomerVH.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier_VH AS _SupplierVH ON SupplierResponsible = _SupplierVH.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PMUserResponsible AS _PMUserResponsible ON UserResponsible = _PMUserResponsible.UserID  -- association [0..1]
LEFT OUTER JOIN I_PMContactPerson AS _PMContactPerson ON MaintenancePartner = _PMContactPerson.ContactPerson  -- association [0..1]
LEFT OUTER JOIN I_PMPositionResponsible AS _PMPositionResponsible ON PositionResponsible = _PMPositionResponsible.PositionResponsible  -- association [0..1]
LEFT OUTER JOIN I_PMDepartmentResponsible AS _PMDepartmentResponsible ON DepartmentResponsible = _PMDepartmentResponsible.DepartmentResponsible  -- association [0..1]
;

Learn More