SHSM_FAR_CUSTOMER

DDL: SHSM_FAR_CUSTOMER SQL: SHSMFARCUST Type: view

Value-Help for Customers

SHSM_FAR_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 19 fields with key field kunnr.

Data Sources (1)

SourceAliasJoin Type
kna1 kna1 from

Annotations (12)

NameValueLevelField
EndUserText.label Value-Help for Customers view
AbapCatalog.sqlViewName SHSMFARCUST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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 (19)

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
begru begru AuthorizGroup
DataControllerSet xdcset Data Ctrlr. Set
DataController1 data_ctrlr1 Data Controller
DataController2 data_ctrlr2 Data Controller
DataController3 data_ctrlr3 Data Controller
DataController4 data_ctrlr4 Data Controller
DataController5 data_ctrlr5 Data Controller
DataController6 data_ctrlr6 Data Controller
DataController7 data_ctrlr7 Data Controller
DataController8 data_ctrlr8 Data Controller
DataController9 data_ctrlr9 Data Controller
DataController10 data_ctrlr10 Data Controller

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 SHSM_FAR_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: SHSMFARCUST

CREATE VIEW SHSM_FAR_CUSTOMER AS
SELECT
  kunnr,
  sortl,
  land1,
  pstlz,
  mcod3,
  mcod1,
  ktokd,
  begru,
  xdcset AS DataControllerSet,
  data_ctrlr1 AS DataController1,
  data_ctrlr2 AS DataController2,
  data_ctrlr3 AS DataController3,
  data_ctrlr4 AS DataController4,
  data_ctrlr5 AS DataController5,
  data_ctrlr6 AS DataController6,
  data_ctrlr7 AS DataController7,
  data_ctrlr8 AS DataController8,
  data_ctrlr9 AS DataController9,
  data_ctrlr10 AS DataController10
FROM kna1
;