C_PurOrdMaintainWBSValHelp

DDL: C_PURORDMAINTAINWBSVALHELP SQL: CPOMAINTVHWBSEL Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN

WBS Element Value Help

C_PurOrdMaintainWBSValHelp is a Consumption CDS View that provides data about "WBS Element Value Help" in SAP S/4HANA. It reads from 6 data sources and exposes 6 fields with key fields WBSElement, PurchasingOrganization. Part of development package ODATA_MM_PUR_PO_MAINTAIN.

6 data source(s) 6 fields

Data Sources (6)

SourceAliasJoin Type
I_PurchasingOrganization _PurchasingOrganization left_outer
I_EngagementProjFinancialPlan FinancialPlan inner
I_EngagementProject Project_Plan from
I_EngmntProjSrvcOrgDetails ServiceOrg inner
I_WBSElement WBSElement inner
I_WorkPackage WorkPackage inner

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPOMAINTVHWBSEL view
EndUserText.label WBS Element Value Help view
AccessControl.authorizationCheck #CHECK view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WBSElement I_WorkPackage WBSElementObject
KEY PurchasingOrganization I_PurchasingOrganization PurchasingOrganization
WBSElementInternalID
CustomerProjectName I_EngagementProject EngagementProjectName
CustProjWorkPackageName I_WorkPackage WorkPackageName
CompanyCode I_EngmntProjSrvcOrgDetails AssignedOrganisation 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CPOMAINTVHWBSEL'
@EndUserText.label: 'WBS Element Value Help'
@AccessControl.authorizationCheck: #CHECK

define view C_PurOrdMaintainWBSValHelp as select from I_EngagementProject as Project_Plan
     inner join I_EngmntProjSrvcOrgDetails as ServiceOrg on Project_Plan.EngagementProjectServiceOrg = ServiceOrg.EngagementProjectServiceOrg
     inner join I_EngagementProjFinancialPlan as FinancialPlan on Project_Plan.EngagementProjectUUID = FinancialPlan.EngagementProjectUUID
     inner join I_WorkPackage as WorkPackage on FinancialPlan.EngagementProjFinPlanUUID = WorkPackage.EngagementProjFinPlanUUID
     inner join I_WBSElement as WBSElement on WorkPackage.WBSElementObject = WBSElement.WBSElementObject
     left outer join I_PurchasingOrganization as _PurchasingOrganization on _PurchasingOrganization.CompanyCode = ServiceOrg.AssignedOrganisation
   
{ 
    key WorkPackage.WBSElementObject              as WBSElement,
    key _PurchasingOrganization.PurchasingOrganization as PurchasingOrganization,
    WorkPackage._WBSElement.WBSElementInternalID  as WBSElementInternalID,
    Project_Plan.EngagementProjectName            as CustomerProjectName,
    WorkPackage.WorkPackageName                   as CustProjWorkPackageName,
    ServiceOrg.AssignedOrganisation               as CompanyCode

}

  where ServiceOrg.AssignedOrganisationType = 'CC'

Learn More