I_ProjCustSrvcOrgDetails

DDL: I_PROJCUSTSRVCORGDETAILS SQL: IPCUSTSRVORGDET Type: view COMPOSITE
12 Fields 3 Data Sources 1 Associations

Customer Service Organisation Details

I_ProjCustSrvcOrgDetails is a Composite CDS View that provides data about "Customer Service Organisation Details" in SAP S/4HANA. It reads from 3 data sources (I_Customer, I_CustomerSalesArea, I_EngagementProjectSrvcOrgDets) and exposes 12 fields with key fields Customer, CustomerProjectServiceOrg, SalesOrganization, DistributionChannel, Division. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_Customer Customer from
I_CustomerSalesArea CustomerSalesArea inner
I_EngagementProjectSrvcOrgDets CustProjSrvc inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPCUSTSRVORGDET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Customer Service Organisation Details view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer Sold-to Party
KEY CustomerProjectServiceOrg I_EngagementProjectSrvcOrgDets EngagementProjectServiceOrg Service Org.
KEY SalesOrganization I_CustomerSalesArea SalesOrganization Sales Organization
KEY DistributionChannel I_CustomerSalesArea DistributionChannel RefDistCh-Cust/Mat.
KEY Division I_CustomerSalesArea Division Internal Division ID
CustomerName I_Customer CustomerName Name of Customer
OrganizationBPName1 I_Customer OrganizationBPName1 Name 1
OrganizationBPName2 I_Customer OrganizationBPName2 Name 2
Currency I_CustomerSalesArea Currency Valuation Crcy
CustomerAccountGroup I_Customer CustomerAccountGroup Account group
AuthorizationGroup I_Customer AuthorizationGroup AuthorizGroup
_Customer _Customer

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_ProjCustSrvcOrgDetails.
-- 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: IPCUSTSRVORGDET

CREATE VIEW I_ProjCustSrvcOrgDetails AS
SELECT
  Customer.Customer AS Customer,
  CustProjSrvc.EngagementProjectServiceOrg AS CustomerProjectServiceOrg,
  CustomerSalesArea.SalesOrganization AS SalesOrganization,
  CustomerSalesArea.DistributionChannel AS DistributionChannel,
  CustomerSalesArea.Division AS Division,
  Customer.CustomerName AS CustomerName,
  Customer.OrganizationBPName1 AS OrganizationBPName1,
  Customer.OrganizationBPName2 AS OrganizationBPName2,
  CustomerSalesArea.Currency AS Currency,
  Customer.CustomerAccountGroup AS CustomerAccountGroup,
  Customer.AuthorizationGroup AS AuthorizationGroup
FROM I_Customer AS Customer
INNER JOIN I_CustomerSalesArea AS CustomerSalesArea ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngagementProjectSrvcOrgDets AS CustProjSrvc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
;

Learn More