UPOV_DATAGUID_TO_INSPLOT

DDL: UPO_INT_V_DATAGUID_TO_INSPLOT SQL: UPOSPRGUIDTOINSP Type: view
2 Fields 2 Data Sources

Convert GUID to InspLot for Well Test

UPOV_DATAGUID_TO_INSPLOT is a CDS View that provides data about "Convert GUID to InspLot for Well Test" in SAP S/4HANA. It reads from 2 data sources (pcdpos, gho_ppa_request) and exposes 2 fields.

Data Sources (2)

SourceAliasJoin Type
pcdpos changedoc left_outer
gho_ppa_request ppa_request from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOSPRGUIDTOINSP view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Convert GUID to InspLot for Well Test view

Fields (2)

KeyFieldSource TableSource FieldDescription
PPARequestID gho_ppa_request ppa_req_id ID of Data for Audit
InspectionLot

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 UPOV_DATAGUID_TO_INSPLOT.
-- 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: UPOSPRGUIDTOINSP

CREATE VIEW UPOV_DATAGUID_TO_INSPLOT AS
SELECT
  ppa_request.ppa_req_id AS PPARequestID,
  substring(changedoc.tabkey, 4, 12 ) AS InspectionLot
FROM gho_ppa_request AS ppa_request
LEFT OUTER JOIN pcdpos AS changedoc ON /* join condition not captured in parsed metadata */
;

Learn More