P_ValuationViewByDeprArea

DDL: P_VALUATIONVIEWBYDEPRAREA SQL: PFIASTVALVIEWDA Type: view BASIC

P_ValuationViewByDeprArea is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (faac_cmp_da0, faac_valview0, faac_valview1a, finsc_ld_cmp, t001) and exposes 4 fields with key fields CompanyCode, ChartOfAccounts, AssetDepreciationArea.

Data Sources (5)

SourceAliasJoin Type
faac_cmp_da0 faac_cmp_da0 from
faac_valview0 faac_valview0 inner
faac_valview1a faac_valview1a inner
finsc_ld_cmp finsc_ld_cmp inner
t001 t001 inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFIASTVALVIEWDA view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode faac_cmp_da0 comp_code Procuring Comp. Cde
KEY ChartOfAccounts t001 ktopl G/L Chart of Accounts
KEY AssetDepreciationArea faac_cmp_da0 depr_area Deprec. Area
AssetValuationView faac_cmp_da0 valview ValView

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 P_ValuationViewByDeprArea.
-- 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: PFIASTVALVIEWDA

CREATE VIEW P_ValuationViewByDeprArea AS
SELECT
  faac_cmp_da0.comp_code AS CompanyCode,
  t001.ktopl AS ChartOfAccounts,
  faac_cmp_da0.depr_area AS AssetDepreciationArea,
  faac_cmp_da0.valview AS AssetValuationView
FROM faac_cmp_da0
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ld_cmp ON /* join condition not captured in parsed metadata */
INNER JOIN faac_valview0 ON /* join condition not captured in parsed metadata */
INNER JOIN faac_valview1a ON /* join condition not captured in parsed metadata */
;