FAC_AUDIT_Z3_ControllingArea

DDL: FAC_AUDIT_Z3_CONTROLLINGAREA SQL: FAC_DZCOAREA Type: view Package: FINS_FI_DART_Z3

Controlling Area

FAC_AUDIT_Z3_ControllingArea is a CDS View that provides data about "Controlling Area" in SAP S/4HANA. It reads from 1 data source (I_ControllingArea) and exposes 16 fields with key field ControllingArea. Part of development package FINS_FI_DART_Z3.

Data Sources (1)

SourceAliasJoin Type
I_ControllingArea I_ControllingArea from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZCOAREA view
EndUserText.label Controlling Area view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
SystemClient System Client
ControllingAreaName ControllingAreaName Long Text
ChartOfAccounts ChartOfAccounts Node Class
_ChartOfAccounts _ChartOfAccounts
_Currency _Currency
ControllingAreaCurrency ControllingAreaCurrency
CostCenterStandardHierarchy CostCenterStandardHierarchy Standard Hierarchy for Cost Centers
OperatingConcern OperatingConcern Operating Concern
ProfitCenterStandardHierarchy ProfitCenterStandardHierarchy Standard Hierarchy Node
BusinessProcessStandardHier BusinessProcessStandardHier Business Process Standard Hierarchy Area
CreditDownPaymentDefaultGLAcct CreditDownPaymentDefaultGLAcct Cost elmnt for vendor dwnpayt w/o PO ref
DebitDownPaymentDefaultGLAcct DebitDownPaymentDefaultGLAcct Revn type for debitor dwnpayt w/o SO ref
ControllingAreaResponsibleUser ControllingAreaResponsibleUser Person Resp. for the Controlling Area
DefaultProfitCenter DefaultProfitCenter Default Prftctr for Nonassgd Processes
CtrlgStdFinStatementVersion CtrlgStdFinStatementVersion Leading Controlling Financial Stmnt Vers

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_ControllingArea.
-- 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_DZCOAREA

CREATE VIEW FAC_AUDIT_Z3_ControllingArea AS
SELECT
  ControllingArea,
  $session.client AS SystemClient,
  ControllingAreaName,
  ChartOfAccounts,
  ControllingAreaCurrency,
  CostCenterStandardHierarchy,
  OperatingConcern,
  ProfitCenterStandardHierarchy,
  BusinessProcessStandardHier,
  CreditDownPaymentDefaultGLAcct,
  DebitDownPaymentDefaultGLAcct,
  ControllingAreaResponsibleUser,
  DefaultProfitCenter,
  CtrlgStdFinStatementVersion
FROM I_ControllingArea
;