C_PURDOCLISTWBSELEMENT

DDL: C_PURDOCLISTWBSELEMENT SQL: CDOCLWBSELE Type: view CONSUMPTION
14 Fields 1 Associations

View to get the WBS details

C_PURDOCLISTWBSELEMENT is a Consumption CDS View that provides data about "View to get the WBS details" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CustomerProjectWorkPackage _CustProjectWorkPackage ekkn.WBSElementObject = _CustProjectWorkPackage.WBSElementObject

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CDOCLWBSELE view
VDM.viewType #CONSUMPTION view
EndUserText.label View to get the WBS details view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder ekkn PurchaseOrder Purchasing Document
KEY PurchaseOrderItem ekkn PurchaseOrderItem Purchasing Document Item
KEY AccountAssignmentNumber ekkn AccountAssignmentNumber Account Assgmt No.
SalesOrder ekkn SalesOrder SD Document
SalesOrderItem ekkn SalesOrderItem Sales Order Item
WBSElementInternalID ekkn WBSElementInternalID WBS Internal ID
CostCenter ekkn CostCenter Cost Center
ControllingArea ekkn ControllingArea Controlling Area
FunctionalArea ekkn FunctionalArea Sendr Fctl Area
GLAccount ekkn GLAccount General Ledger
WBSElementExternalID ekkn WBSElementExternalID WBS Element External ID
WBSElementObject ekkn WBSElementObject Object number
WorkPackageFullName _CustProjectWorkPackage CustProjWorkPackageFullName
WBSDescription _CustProjectWorkPackage WBSDescription WBS Element Name

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_PURDOCLISTWBSELEMENT.
-- 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: CDOCLWBSELE

CREATE VIEW C_PURDOCLISTWBSELEMENT AS
SELECT
  ekkn.PurchaseOrder AS PurchaseOrder,
  ekkn.PurchaseOrderItem AS PurchaseOrderItem,
  ekkn.AccountAssignmentNumber AS AccountAssignmentNumber,
  ekkn.SalesOrder AS SalesOrder,
  ekkn.SalesOrderItem AS SalesOrderItem,
  ekkn.WBSElementInternalID AS WBSElementInternalID,
  ekkn.CostCenter AS CostCenter,
  ekkn.ControllingArea AS ControllingArea,
  ekkn.FunctionalArea AS FunctionalArea,
  ekkn.GLAccount AS GLAccount,
  ekkn.WBSElementExternalID AS WBSElementExternalID,
  ekkn.WBSElementObject AS WBSElementObject,
  _CustProjectWorkPackage.CustProjWorkPackageFullName AS WorkPackageFullName,
  _CustProjectWorkPackage.WBSDescription AS WBSDescription
LEFT OUTER JOIN I_CustomerProjectWorkPackage AS _CustProjectWorkPackage ON ekkn.WBSElementObject = _CustProjectWorkPackage.WBSElementObject  -- association [0..1]
;

Learn More