I_CustprojsrvcOrgDetails

DDL: I_CUSTPROJSRVCORGDETAILS SQL: ICUSPROJORGDETLS Type: view BASIC Package: CPD_CDS
4 Fields 1 Data Sources

Customer Project Service Org Details

I_CustprojsrvcOrgDetails is a Basic CDS View that provides data about "Customer Project Service Org Details" in SAP S/4HANA. It reads from 1 data source (/cpd/pwsc_orgpid) and exposes 4 fields with key fields CustomerProjectServiceOrg, AssignedOrganisation, AssignedOrganisationType. Part of development package CPD_CDS.

Data Sources (1)

SourceAliasJoin Type
/cpd/pwsc_orgpid CustProjServiceOrgDetails from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICUSPROJORGDETLS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Customer Project Service Org Details view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 000 view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CustomerProjectServiceOrg /cpd/pwsc_orgpid org_unit_id Service Org.
KEY AssignedOrganisation /cpd/pwsc_orgpid org_unit_key Org. Unit Key
KEY AssignedOrganisationType /cpd/pwsc_orgpid org_unit_typ Org. Unit Type
AssignedOrganisationIsDefault /cpd/pwsc_orgpid default_val Default

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_CustprojsrvcOrgDetails.
-- 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: ICUSPROJORGDETLS

CREATE VIEW I_CustprojsrvcOrgDetails AS
SELECT
  CustProjServiceOrgDetails.org_unit_id AS CustomerProjectServiceOrg,
  CustProjServiceOrgDetails.org_unit_key AS AssignedOrganisation,
  CustProjServiceOrgDetails.org_unit_typ AS AssignedOrganisationType,
  CustProjServiceOrgDetails.default_val AS AssignedOrganisationIsDefault
FROM /cpd/pwsc_orgpid AS CustProjServiceOrgDetails
;

Learn More