FAC_AUDIT_Z3_PROJECT

DDL: FAC_AUDIT_Z3_PROJECT SQL: FAC_AUDPROJECT Type: view
27 Fields 1 Data Sources 1 Associations

Project

FAC_AUDIT_Z3_PROJECT is a CDS View that provides data about "Project" in SAP S/4HANA. It reads from 1 data source (I_ProjectBasicData) and exposes 27 fields with key field ProjectInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBasicData _ProjectBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] proj _Project $projection.ProjectInternalID = _Project.pspnr

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAC_AUDPROJECT view
EndUserText.label Project 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 #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID I_ProjectBasicData ProjectInternalID Project Def.
SystemClient System Client
Project I_ProjectBasicData Project WBS Element
ProjectDescription I_ProjectBasicData ProjectDescription Project Name
CreatedByUser _Project ernam User Name
CreationDate _Project erdat Entered On
LastChangedByUser _Project aenam User Name
LastChangeDate _Project aedat Obsolete
CompanyCode I_ProjectBasicData CompanyCode Receiver Company Code
BusinessArea _Project vgsbr Business area
ControllingArea I_ProjectBasicData ControllingArea Controlling Area
ProfitCenter I_ProjectBasicData ProfitCenter Profit Center
PlannedStartDate I_ProjectBasicData PlannedStartDate Latest Planned Start
PlannedEndDate I_ProjectBasicData PlannedEndDate Ltst Planned Finish
Plant _Project werks Receiving Plant
FactoryCalendar _Project kalid Pub.hol.cal.ID
ProjectProfileCode I_ProjectBasicData ProjectProfileCode Project Profile
BudgetProfile _Project bprof Budget Profile
LogicalSystem _Project logsystem Logical System
UpdateTimestamp _Project cpd_updat Time Stamp
AvailabilityControlProfile I_ProjectBasicData AvailabilityControlProfile Budget Availability Control Profile
AvailabilityControlIsActive I_ProjectBasicData AvailabilityControlIsActive Budget Availability Control is Active
ProjectCurrency I_ProjectBasicData ProjectCurrency Project Currency
_Project _Project
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_ProfitCenter2 _ProfitCenter2

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_PROJECT.
-- 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_AUDPROJECT

CREATE VIEW FAC_AUDIT_Z3_PROJECT AS
SELECT
  _ProjectBasic.ProjectInternalID AS ProjectInternalID,
  $session.client AS SystemClient,
  _ProjectBasic.Project AS Project,
  _ProjectBasic.ProjectDescription AS ProjectDescription,
  _Project.ernam AS CreatedByUser,
  _Project.erdat AS CreationDate,
  _Project.aenam AS LastChangedByUser,
  _Project.aedat AS LastChangeDate,
  _ProjectBasic.CompanyCode AS CompanyCode,
  _Project.vgsbr AS BusinessArea,
  _ProjectBasic.ControllingArea AS ControllingArea,
  _ProjectBasic.ProfitCenter AS ProfitCenter,
  _ProjectBasic.PlannedStartDate AS PlannedStartDate,
  _ProjectBasic.PlannedEndDate AS PlannedEndDate,
  _Project.werks AS Plant,
  _Project.kalid AS FactoryCalendar,
  _ProjectBasic.ProjectProfileCode AS ProjectProfileCode,
  _Project.bprof AS BudgetProfile,
  _Project.logsystem AS LogicalSystem,
  _Project.cpd_updat AS UpdateTimestamp,
  _ProjectBasic.AvailabilityControlProfile AS AvailabilityControlProfile,
  _ProjectBasic.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  _ProjectBasic.ProjectCurrency AS ProjectCurrency
FROM I_ProjectBasicData AS _ProjectBasic
LEFT OUTER JOIN proj AS _Project ON ProjectInternalID = _Project.pspnr  -- association [1..1]
;

Learn More