I_CAPostingAreaData

DDL: I_CAPOSTINGAREADATA Type: view_entity BASIC
20 Fields 1 Data Sources 3 Associations

Contract Accounting Posting Area Data

I_CAPostingAreaData is a Basic CDS View that provides data about "Contract Accounting Posting Area Data" in SAP S/4HANA. It reads from 1 data source (tfk033d) and exposes 20 fields with key fields CAApplicationArea, CAPostingArea, ChartOfAccounts, CAPostingAreaFirstKeyField, CAPostingAreaSecondKeyField. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
tfk033d tfk033d from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CAApplicationArea _CAApplicationArea $projection.CAApplicationArea = _CAApplicationArea.CAApplicationArea
[1..1] I_CAPostingArea _CAPostingArea $projection.CAPostingArea = _CAPostingArea.CAPostingArea
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Contract Accounting Posting Area Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CAApplicationArea applk ApplicationArea
KEY CAPostingArea buber Posting area
KEY ChartOfAccounts ktopl G/L Chart of Accounts
KEY CAPostingAreaFirstKeyField key01 Key field
KEY CAPostingAreaSecondKeyField key02 Key field
KEY CAPostingAreaThirdKeyField key03 Key field
KEY CAPostingAreaFourthKeyField key04 Key field
KEY CAPostingAreaFifthKeyField key05 Key field
KEY CAPostingAreaSixthKeyField key06 Key field
KEY CAPostingAreaSeventhKeyField key07 Key field
KEY CAPostingAreaEighthKeyField key08 Key
CAPostingAreaFirstFuncField fun01 Function
CAPostingAreaSecondFuncField fun02 Function
CAPostingAreaThirdFuncField fun03 Function
CAPostingAreaFourthFuncField fun04 Function
CAPostingAreaFifthFuncField fun05 Function
CAPostingAreaSixthFuncField fun06 Function
_CAApplicationArea _CAApplicationArea
_CAPostingArea _CAPostingArea
_ChartOfAccounts _ChartOfAccounts

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 I_CAPostingAreaData.
-- 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.

CREATE VIEW I_CAPostingAreaData AS
SELECT
  applk AS CAApplicationArea,
  buber AS CAPostingArea,
  ktopl AS ChartOfAccounts,
  key01 AS CAPostingAreaFirstKeyField,
  key02 AS CAPostingAreaSecondKeyField,
  key03 AS CAPostingAreaThirdKeyField,
  key04 AS CAPostingAreaFourthKeyField,
  key05 AS CAPostingAreaFifthKeyField,
  key06 AS CAPostingAreaSixthKeyField,
  key07 AS CAPostingAreaSeventhKeyField,
  key08 AS CAPostingAreaEighthKeyField,
  fun01 AS CAPostingAreaFirstFuncField,
  fun02 AS CAPostingAreaSecondFuncField,
  fun03 AS CAPostingAreaThirdFuncField,
  fun04 AS CAPostingAreaFourthFuncField,
  fun05 AS CAPostingAreaFifthFuncField,
  fun06 AS CAPostingAreaSixthFuncField
FROM tfk033d
LEFT OUTER JOIN I_CAApplicationArea AS _CAApplicationArea ON CAApplicationArea = _CAApplicationArea.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CAPostingArea AS _CAPostingArea ON CAPostingArea = _CAPostingArea.CAPostingArea  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
;

Learn More