SFPM_IDA_TEST_SEAR_SNWD_BP_CRM

DDL: SFPM_IDA_TEST_SEAR_SNWD_BP_CRM SQL: SFPM_IDA_TEST_BP Type: view
6 Fields 1 Data Sources

SFPM Test CDS view for SNWD_BP_CRM

SFPM_IDA_TEST_SEAR_SNWD_BP_CRM is a CDS View that provides data about "SFPM Test CDS view for SNWD_BP_CRM" in SAP S/4HANA. It reads from 1 data source (snwd_bp_crm) and exposes 6 fields.

Data Sources (1)

SourceAliasJoin Type
snwd_bp_crm snwd_bp_crm from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SFPM_IDA_TEST_BP view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label SFPM Test CDS view for SNWD_BP_CRM view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
last_name last_name LastName
first_name first_name Name
state state Vehicle Region
city city Location
sales_volume sales_volume
count_field 1

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 SFPM_IDA_TEST_SEAR_SNWD_BP_CRM.
-- 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: SFPM_IDA_TEST_BP

CREATE VIEW SFPM_IDA_TEST_SEAR_SNWD_BP_CRM AS
SELECT
  last_name,
  first_name,
  state,
  city,
  sales_volume,
  1 AS count_field
FROM snwd_bp_crm
;

Learn More