fac_ad_cds_customer

DDL: FAC_AD_CDS_CUSTOMER SQL: FACADV_CUST Type: view
7 Fields 1 Data Sources

Value-Help for Customers

fac_ad_cds_customer is a CDS View that provides data about "Value-Help for Customers" in SAP S/4HANA. It reads from 1 data source (kna1) and exposes 7 fields with key field kunnr.

Data Sources (1)

SourceAliasJoin Type
kna1 kna1 from

Annotations (11)

NameValueLevelField
EndUserText.label Value-Help for Customers view
AbapCatalog.sqlViewName FACADV_CUST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY kunnr kunnr Stock customer
sortl sortl Sort Term
land1 land1 Trip Ctry/Reg
pstlz pstlz Postal Code
mcod3 mcod3 City
mcod1 mcod1 Search Term
ktokd ktokd DefCusAcctGr

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_ad_cds_customer.
-- 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: FACADV_CUST

CREATE VIEW fac_ad_cds_customer AS
SELECT
  kunnr,
  sortl,
  land1,
  pstlz,
  mcod3,
  mcod1,
  ktokd
FROM kna1
;

Learn More