fac_ppv_cds_ppv_gl_account

DDL: FAC_PPV_CDS_PPV_GL_ACCOUNT SQL: FACPPVV_ACCT Type: view
4 Fields 3 Data Sources

CDS View for PPV account search help

fac_ppv_cds_ppv_gl_account is a CDS View that provides data about "CDS View for PPV account search help" in SAP S/4HANA. It reads from 3 data sources (fac_ppv_cds_ppv_coa, ska1, skat) and exposes 4 fields.

Data Sources (3)

SourceAliasJoin Type
fac_ppv_cds_ppv_coa fac_ppv_cds_ppv_coa from
ska1 ska1 inner
skat skat left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACPPVV_ACCT view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View for PPV account search help view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (4)

KeyFieldSource TableSource FieldDescription
opvar fac_ppv_cds_ppv_coa ppv
ktopl fac_ppv_cds_ppv_coa coa
saknr ska1 saknr G/L Account
txt50 skat txt50 Status Name

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_ppv_cds_ppv_gl_account.
-- 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: FACPPVV_ACCT

CREATE VIEW fac_ppv_cds_ppv_gl_account AS
SELECT
  fac_ppv_cds_ppv_coa.ppv AS opvar,
  fac_ppv_cds_ppv_coa.coa AS ktopl,
  ska1.saknr AS saknr,
  skat.txt50 AS txt50
FROM fac_ppv_cds_ppv_coa
INNER JOIN ska1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN skat ON /* join condition not captured in parsed metadata */
;

Learn More