I_ContactPersonFunction

DDL: I_CONTACTPERSONFUNCTION SQL: I_MD_FUNCTION Type: view BASIC Package: VDM_MD_BP_BASE
2 Fields 1 Data Sources 1 Associations 5 OData Services

Value Help for Func of Contact Person

I_ContactPersonFunction (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

BPContactPersonFunction · Database & Data Management

I_ContactPersonFunction is a Basic CDS View (Dimension) that provides data about "Value Help for Func of Contact Person" in SAP S/4HANA. It reads from 1 data source (tb912) and exposes 2 fields with key field ContactPersonFunction. It has 1 association to related views. It is exposed through 5 OData services (ASQL_F2607, ASQL_F2608, ASQL_F4707, ...). Part of development package VDM_MD_BP_BASE.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentAP-MD-BP
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tb912 tb912 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ContactPersonFunctionT _Text $projection.ContactPersonFunction = _Text.ContactPersonFunction

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName I_MD_FUNCTION view
EndUserText.label Value Help for Func of Contact Person view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.sapObjectNodeType.name BPContactPersonFunction view
ObjectModel.representativeKey ContactPersonFunction view
Search.searchable true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

OData Services (5)

ServiceBindingVersionContractRelease
ASQL_F2607 ASQL_F2607 C2 NOT_RELEASED
ASQL_F2608 ASQL_F2608 C2 NOT_RELEASED
ASQL_F4707 ASQL_F4707 C2 NOT_RELEASED
ASQL_F4708 ASQL_F4708 C2 NOT_RELEASED
ASQL_F7204A ASQL_F7204A C2 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ContactPersonFunction tb912 pafkt Function of Partner
_Text _Text

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 I_ContactPersonFunction.
-- 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: I_MD_FUNCTION

CREATE VIEW I_ContactPersonFunction AS
SELECT
  tb912.pafkt AS ContactPersonFunction
FROM tb912
LEFT OUTER JOIN I_ContactPersonFunctionT AS _Text ON ContactPersonFunction = _Text.ContactPersonFunction  -- association [0..*]
;

Learn More