C_ProjectServiceOrg

DDL: C_PROJECTSERVICEORG SQL: CPSRVCORG Type: view CONSUMPTION
14 Fields 1 Data Sources

Service Organization

C_ProjectServiceOrg is a Consumption CDS View that provides data about "Service Organization" in SAP S/4HANA. It reads from 1 data source (I_EngagementProjectSrvcOrg) and exposes 14 fields with key field EngagementProjectServiceOrg.

Data Sources (1)

SourceAliasJoin Type
I_EngagementProjectSrvcOrg I_EngagementProjectSrvcOrg from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPSRVCORG view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Service Organization view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectServiceOrg I_EngagementProjectSrvcOrg EngagementProjectServiceOrg Service Org.
EngmtProjectServiceOrgName I_EngagementProjectSrvcOrgText EngmtProjectServiceOrgName Service Organization Name
EngmntProjectCompanyCode CompanyCode AssignedOrganisation Company Code
CompanyCodeName CompanyCodeName CompanyCodeName Company Code Name
EngagementProjectCostCenter CostCenter AssignedOrganisation Default Cost Center
CostCenterName CostCenterName CostCenterName Name
EngmntProjectPurchaseOrg PurchasingOrg AssignedOrganisation Purchasing Organization
PurchasingOrganizationName PurchasingOrgName PurchasingOrganizationName Purch. Org. Name
EngagementProjectSalesOrg SalesOrg AssignedOrganisation Sales Organization
SalesOrganizationName SalesOrgName SalesOrganizationName Sales Org. Name
EngagementProjectPlant Plant AssignedOrganisation Plant
PlantName PlantName PlantName Plant Name
EngmtProjServiceOrgIsSales I_EngagementProjectSrvcOrg EngmtProjServiceOrgIsSales Sales Organization
EngmtProjServiceOrgIsDelivery I_EngagementProjectSrvcOrg EngmtProjServiceOrgIsDelivery Delivery Organization

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_ProjectServiceOrg.
-- 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: CPSRVCORG

CREATE VIEW C_ProjectServiceOrg AS
SELECT
  I_EngagementProjectSrvcOrg.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  I_EngagementProjectSrvcOrgText.EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  CompanyCode.AssignedOrganisation AS EngmntProjectCompanyCode,
  CompanyCodeName.CompanyCodeName AS CompanyCodeName,
  CostCenter.AssignedOrganisation AS EngagementProjectCostCenter,
  CostCenterName.CostCenterName AS CostCenterName,
  PurchasingOrg.AssignedOrganisation AS EngmntProjectPurchaseOrg,
  PurchasingOrgName.PurchasingOrganizationName AS PurchasingOrganizationName,
  SalesOrg.AssignedOrganisation AS EngagementProjectSalesOrg,
  SalesOrgName.SalesOrganizationName AS SalesOrganizationName,
  Plant.AssignedOrganisation AS EngagementProjectPlant,
  PlantName.PlantName AS PlantName,
  I_EngagementProjectSrvcOrg.EngmtProjServiceOrgIsSales AS EngmtProjServiceOrgIsSales,
  I_EngagementProjectSrvcOrg.EngmtProjServiceOrgIsDelivery AS EngmtProjServiceOrgIsDelivery
FROM I_EngagementProjectSrvcOrg
;

Learn More