A_FinWBSElement

DDL: A_FINWBSELEMENT SQL: AFINWBSELEMENT Type: view BASIC
16 Fields 2 Data Sources

API FIN WBS Element Details

A_FinWBSElement is a Basic CDS View that provides data about "API FIN WBS Element Details" in SAP S/4HANA. It reads from 2 data sources (I_ProjectBasicData, I_WBSElementBasicData) and exposes 16 fields with key field WBSElementInternalID.

Data Sources (2)

SourceAliasJoin Type
I_ProjectBasicData _Project left_outer
I_WBSElementBasicData I_WBSElementBasicData from

Annotations (11)

NameValueLevelField
EndUserText.label API FIN WBS Element Details view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName AFINWBSELEMENT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBS Internal ID
WBSElement WBSElement WBS Internal ID
WBSDescription WBSDescription WBS Element Name
CompanyCode I_WBSElementBasicData CompanyCode Receiver Company Code
ControllingArea I_WBSElementBasicData ControllingArea Controlling Area
FunctionalArea I_WBSElementBasicData FunctionalArea Sendr Fctl Area
ProfitCenter I_WBSElementBasicData ProfitCenter Profit Center
ProjectInternalID
Project I_ProjectBasicData Project WBS Element
WBSElementIsBillingElement WBSElementIsBillingElement Billing elem.
WBSElementObject WBSElementObject Object number
Plant I_WBSElementBasicData Plant Valuation Area
ProjectType I_WBSElementBasicData ProjectType Project Type
ResponsibleCostCenter I_WBSElementBasicData ResponsibleCostCenter Responsible Cost Center
SourceProjectInternalID
_Project _Project

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_FinWBSElement.
-- 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: AFINWBSELEMENT

CREATE VIEW A_FinWBSElement AS
SELECT
  cast ( WBSElementInternalID as ps_posnr1 ) AS WBSElementInternalID,
  WBSElement,
  WBSDescription,
  I_WBSElementBasicData.CompanyCode AS CompanyCode,
  I_WBSElementBasicData.ControllingArea AS ControllingArea,
  I_WBSElementBasicData.FunctionalArea AS FunctionalArea,
  I_WBSElementBasicData.ProfitCenter AS ProfitCenter,
  cast ( I_WBSElementBasicData.ProjectInternalID as abap.numc( 8 ) ) AS ProjectInternalID,
  _Project.Project AS Project,
  WBSElementIsBillingElement,
  WBSElementObject,
  I_WBSElementBasicData.Plant AS Plant,
  I_WBSElementBasicData.ProjectType AS ProjectType,
  I_WBSElementBasicData.ResponsibleCostCenter AS ResponsibleCostCenter,
  cast (I_WBSElementBasicData.ProjectInternalID as ps_s4_pspnr preserving type) AS SourceProjectInternalID
FROM I_WBSElementBasicData
LEFT OUTER JOIN I_ProjectBasicData AS _Project ON /* join condition not captured in parsed metadata */
;

Learn More