R_ProjSrvcOrgTP

DDL: R_PROJSRVCORGTP Type: view_entity TRANSACTIONAL
20 Fields 1 Data Sources 2 Associations

Service Organization

R_ProjSrvcOrgTP is a Transactional CDS View that provides data about "Service Organization" in SAP S/4HANA. It reads from 1 data source (R_ProjSrvcOrg) and exposes 20 fields with key field ProjectServiceOrganizationUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjSrvcOrg ServiceOrganization from

Associations (2)

CardinalityTargetAliasCondition
[1..*] R_ProjSrvcOrgCostCenterTP _CostCenter
[1..*] R_ProjSrvcOrgTextTP _Text

Annotations (8)

NameValueLevelField
EndUserText.label Service Organization view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name ProjectServiceOrganization view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ProjectServiceOrganizationUUID ProjectServiceOrganizationUUID Service Org UUID
ProjectServiceOrganizationOID ProjectServiceOrganizationOID ServOrgOID
ProjectServiceOrganization Service Org.
ProjSrvcOrgIsProjDeliveryOrg ProjSrvcOrgIsProjDeliveryOrg
ProjSrvcOrgIsResourceOrg ProjSrvcOrgIsResourceOrg
ProjSrvcOrgIsTimePostingAllwd ProjSrvcOrgIsTimePostingAllwd
ProjSrvcOrgControllingArea ProjSrvcOrgControllingArea
ProjSrvcOrgCompanyCode ProjSrvcOrgCompanyCode
ProjSrvcOrgSalesOrg ProjSrvcOrgSalesOrg
ProjSrvcOrgDivision ProjSrvcOrgDivision
ProjSrvcOrgDistributionChannel ProjSrvcOrgDistributionChannel
ProjSrvcOrgPurchaseOrg ProjSrvcOrgPurchaseOrg
ProjSrvcOrgPlant ProjSrvcOrgPlant
ProjSrvcOrgDataMigrationStatus ProjSrvcOrgDataMigrationStatus Migration Status
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_CostCenter _CostCenter
_Text _Text

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_ProjSrvcOrgTP.
-- 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_ProjSrvcOrgTP AS
SELECT
  ProjectServiceOrganizationUUID,
  ProjectServiceOrganizationOID,
  cast (ProjectServiceOrganization as /s4ppm/tv_svorg_id) AS ProjectServiceOrganization,
  ProjSrvcOrgIsProjDeliveryOrg,
  ProjSrvcOrgIsResourceOrg,
  ProjSrvcOrgIsTimePostingAllwd,
  ProjSrvcOrgControllingArea,
  ProjSrvcOrgCompanyCode,
  ProjSrvcOrgSalesOrg,
  ProjSrvcOrgDivision,
  ProjSrvcOrgDistributionChannel,
  ProjSrvcOrgPurchaseOrg,
  ProjSrvcOrgPlant,
  ProjSrvcOrgDataMigrationStatus,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjSrvcOrg AS ServiceOrganization
LEFT OUTER JOIN R_ProjSrvcOrgCostCenterTP AS _CostCenter ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_ProjSrvcOrgTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More