Fac_Ppv_Cds_Ppv

DDL: FAC_PPV_CDS_PPV SQL: FACPPVV_PPV Type: view
4 Fields 3 Data Sources

CDS View For PPV value help on Overview page

Fac_Ppv_Cds_Ppv is a CDS View that provides data about "CDS View For PPV value help on Overview page" in SAP S/4HANA. It reads from 3 data sources (Fac_Ppv_Cds_T001b, finsc_ld_cmp, t010p) and exposes 4 fields with key fields company_code, ledger, ppv.

Data Sources (3)

SourceAliasJoin Type
Fac_Ppv_Cds_T001b Fac_Ppv_Cds_T001b inner
finsc_ld_cmp finsc_ld_cmp from
t010p t010p left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACPPVV_PPV view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View For PPV value help on Overview page 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
KEY company_code finsc_ld_cmp bukrs Value
KEY ledger finsc_ld_cmp rldnr Ledger (Compat.)
KEY ppv finsc_ld_cmp opvar Pstg Per.Var.
ppv_descr Fac_Ppv_Cds_T001b opvar_descr 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.
-- 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_PPV

CREATE VIEW Fac_Ppv_Cds_Ppv AS
SELECT
  finsc_ld_cmp.bukrs AS company_code,
  finsc_ld_cmp.rldnr AS ledger,
  finsc_ld_cmp.opvar AS ppv,
  Fac_Ppv_Cds_T001b.opvar_descr AS ppv_descr
FROM finsc_ld_cmp
INNER JOIN Fac_Ppv_Cds_T001b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t010p ON /* join condition not captured in parsed metadata */
;

Learn More