I_PurReqnCoOfAuthor

DDL: I_PURREQNCOOFAUTHOR SQL: ISSPPRCOOFAUTHOR Type: view COMPOSITE
3 Fields 1 Data Sources

Company of Author in SSP PR

I_PurReqnCoOfAuthor is a Composite CDS View that provides data about "Company of Author in SSP PR" in SAP S/4HANA. It reads from 1 data source (I_ProcmtEmployeeUserDetails) and exposes 3 fields with key fields BusinessPartnerUUID, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_ProcmtEmployeeUserDetails I_ProcmtEmployeeUserDetails from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISSPPRCOOFAUTHOR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Company of Author in SSP PR view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID BusinessPartnerUUID UUID
KEY CompanyCode CompanyCode Receiver Company Code
PersonExternalID Employee Object ID

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_PurReqnCoOfAuthor.
-- 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: ISSPPRCOOFAUTHOR

CREATE VIEW I_PurReqnCoOfAuthor AS
SELECT
  BusinessPartnerUUID,
  CompanyCode,
  Employee AS PersonExternalID
FROM I_ProcmtEmployeeUserDetails
;

Learn More