A_ProjSrvcOrgTP

DDL: A_PROJSRVCORGTP Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 1 OData Services

Service Organization

A_ProjSrvcOrgTP is a Consumption CDS View that provides data about "Service Organization" in SAP S/4HANA. It reads from 1 data source (R_ProjSrvcOrgTP) and exposes 17 fields with key field ProjectServiceOrganizationUUID. It is exposed through 1 OData service (API_SERVICEORGANIZATION).

Data Sources (1)

SourceAliasJoin Type
R_ProjSrvcOrgTP R_ProjSrvcOrgTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Service Organization view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
OData.entityType.name ServiceOrganization_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_SERVICEORGANIZATION API_SERVICEORGANIZATION V4 C2 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProjectServiceOrganizationUUID ProjectServiceOrganizationUUID
ProjectServiceOrganizationOID ProjectServiceOrganizationOID
ProjectServiceOrganization ProjectServiceOrganization
ProjSrvcOrgIsProjDeliveryOrg ProjSrvcOrgIsProjDeliveryOrg
ProjSrvcOrgIsResourceOrg ProjSrvcOrgIsResourceOrg
ProjSrvcOrgIsTimePostingAllwd ProjSrvcOrgIsTimePostingAllwd
ProjSrvcOrgControllingArea ProjSrvcOrgControllingArea
ProjSrvcOrgCompanyCode ProjSrvcOrgCompanyCode
ProjSrvcOrgSalesOrg ProjSrvcOrgSalesOrg
ProjSrvcOrgDivision ProjSrvcOrgDivision
ProjSrvcOrgDistributionChannel ProjSrvcOrgDistributionChannel
ProjSrvcOrgPurchaseOrg ProjSrvcOrgPurchaseOrg
ProjSrvcOrgPlant ProjSrvcOrgPlant
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp

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 A_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 A_ProjSrvcOrgTP AS
SELECT
  ProjectServiceOrganizationUUID,
  ProjectServiceOrganizationOID,
  ProjectServiceOrganization,
  ProjSrvcOrgIsProjDeliveryOrg,
  ProjSrvcOrgIsResourceOrg,
  ProjSrvcOrgIsTimePostingAllwd,
  ProjSrvcOrgControllingArea,
  ProjSrvcOrgCompanyCode,
  ProjSrvcOrgSalesOrg,
  ProjSrvcOrgDivision,
  ProjSrvcOrgDistributionChannel,
  ProjSrvcOrgPurchaseOrg,
  ProjSrvcOrgPlant,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjSrvcOrgTP
;

Learn More