FAC_AUDIT_Z3_WBSELEMENT

DDL: FAC_AUDIT_Z3_WBSELEMENT SQL: FAC_AUDWBSELMT Type: view
38 Fields 1 Data Sources 1 Associations

WBS Element

FAC_AUDIT_Z3_WBSELEMENT is a CDS View that provides data about "WBS Element" in SAP S/4HANA. It reads from 1 data source (I_WBSElementBasicData) and exposes 38 fields with key field WBSElementInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WBSElementBasicData _WBSBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] prps _WBSElement $projection.WBSElementInternalID = _WBSElement.pspnr

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAC_AUDWBSELMT view
EndUserText.label WBS Element view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID I_WBSElementBasicData WBSElementInternalID WBS Internal ID
WBSElementExternalID I_WBSElementBasicData WBSElementExternalID WBS Element External ID
SystemClient System Client
WBSDescription I_WBSElementBasicData WBSDescription WBS Element Name
CreatedByUser I_WBSElementBasicData CreatedByUser User Name
CreationDate I_WBSElementBasicData CreationDate Time Stamp
LastChangedByUser I_WBSElementBasicData LastChangedByUser User Name
LastChangeDate I_WBSElementBasicData LastChangeDate Time Stamp
CompanyCode I_WBSElementBasicData CompanyCode Receiver Company Code
BusinessArea _WBSElement pgsbr Bus.area
ControllingArea I_WBSElementBasicData ControllingArea Controlling Area
ProfitCenter I_WBSElementBasicData ProfitCenter Profit Center
WBSElementIsBillingElement I_WBSElementBasicData WBSElementIsBillingElement Billing elem.
CostingSheet I_WBSElementBasicData CostingSheet Costing Sheet
RespCostCenterControllingArea I_WBSElementBasicData RespCostCenterControllingArea CA (resp.)
ResponsibleCostCenter I_WBSElementBasicData ResponsibleCostCenter Responsible Cost Center
FactoryCalendar I_WBSElementBasicData FactoryCalendar Factory Calendar
FunctionalLocation I_WBSElementBasicData FunctionalLocation Object ID
Plant I_WBSElementBasicData Plant Valuation Area
CostCenter I_WBSElementBasicData CostCenter Cost Center
StatisticalWBSElement I_WBSElementBasicData WBSIsStatisticalWBSElement Statistical
TaxJurisdiction I_WBSElementBasicData TaxJurisdiction Tax Jurisdiction
InvestmentProfile I_WBSElementBasicData InvestmentProfile Investment Measure Profile
LogicalSystem _WBSElement logsystem Logical System
Location I_WBSElementBasicData Location Text
FunctionalArea I_WBSElementBasicData FunctionalArea Sendr Fctl Area
UpdateTimestamp _WBSElement cpd_updat Time Stamp
LeadingSalesOrder _WBSElement posnr_prps Item
LeadingSalesOrderItem _WBSElement vbeln_prps Sales Document
_WBSElement _WBSElement
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_ResponsibleCostCenter _ResponsibleCostCenter
_FactoryCalendar _FactoryCalendar
_Plant _Plant
_CostCenter _CostCenter
_FunctionalArea _FunctionalArea

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 FAC_AUDIT_Z3_WBSELEMENT.
-- 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: FAC_AUDWBSELMT

CREATE VIEW FAC_AUDIT_Z3_WBSELEMENT AS
SELECT
  _WBSBasic.WBSElementInternalID AS WBSElementInternalID,
  _WBSBasic.WBSElementExternalID AS WBSElementExternalID,
  $session.client AS SystemClient,
  _WBSBasic.WBSDescription AS WBSDescription,
  _WBSBasic.CreatedByUser AS CreatedByUser,
  _WBSBasic.CreationDate AS CreationDate,
  _WBSBasic.LastChangedByUser AS LastChangedByUser,
  _WBSBasic.LastChangeDate AS LastChangeDate,
  _WBSBasic.CompanyCode AS CompanyCode,
  _WBSElement.pgsbr AS BusinessArea,
  _WBSBasic.ControllingArea AS ControllingArea,
  _WBSBasic.ProfitCenter AS ProfitCenter,
  _WBSBasic.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  _WBSBasic.CostingSheet AS CostingSheet,
  _WBSBasic.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  _WBSBasic.ResponsibleCostCenter AS ResponsibleCostCenter,
  _WBSBasic.FactoryCalendar AS FactoryCalendar,
  _WBSBasic.FunctionalLocation AS FunctionalLocation,
  _WBSBasic.Plant AS Plant,
  _WBSBasic.CostCenter AS CostCenter,
  _WBSBasic.WBSIsStatisticalWBSElement AS StatisticalWBSElement,
  _WBSBasic.TaxJurisdiction AS TaxJurisdiction,
  _WBSBasic.InvestmentProfile AS InvestmentProfile,
  _WBSElement.logsystem AS LogicalSystem,
  _WBSBasic.Location AS Location,
  _WBSBasic.FunctionalArea AS FunctionalArea,
  _WBSElement.cpd_updat AS UpdateTimestamp,
  _WBSElement.posnr_prps AS LeadingSalesOrder,
  _WBSElement.vbeln_prps AS LeadingSalesOrderItem
FROM I_WBSElementBasicData AS _WBSBasic
LEFT OUTER JOIN prps AS _WBSElement ON WBSElementInternalID = _WBSElement.pspnr  -- association [1..1]
;

Learn More