I_CustSalesPartnerFunc_2

DDL: I_CUSTSALESPARTNERFUNC_2 SQL: ICUSTPARTFUNC2 Type: view BASIC Package: VDM_MD_COMMON
19 Fields 1 Data Sources 4 Associations

Customer Sales Area Partner Function

I_CustSalesPartnerFunc_2 is a Basic CDS View that provides data about "Customer Sales Area Partner Function" in SAP S/4HANA. It reads from 1 data source (knvp) and exposes 19 fields with key fields Customer, SalesOrganization, DistributionChannel, Division, PartnerCounter. It has 4 associations to related views. Part of development package VDM_MD_COMMON.

Data Sources (1)

SourceAliasJoin Type
knvp knvp from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization
[0..1] I_DistributionChannel _DistributionChannel $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..1] I_Division _Division $projection.Division = _Division.Division
[0..1] I_CustSalesPartnerCounter _CustSalesPartnerCounter $projection.PartnerCounter = _CustSalesPartnerCounter.PartnerCounter

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPARTFUNC2 view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey PartnerFunction view
Analytics.internalName #LOCAL view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Customer Sales Area Partner Function view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Customer knvp kunnr Stock customer
KEY SalesOrganization knvp vkorg SD Sales Org.
KEY DistributionChannel knvp vtweg RefDistCh-Cust/Mat.
KEY Division knvp spart Source supplier
KEY PartnerCounter knvp parza Partner counter
KEY PartnerFunction
BPCustomerNumber knvp kunn2 Customer
CustomerPartnerDescription knvp knref Partner Desc.
DefaultPartner knvp defpa Default Partner
Supplier knvp lifnr Vendor no.
PersonnelNumber knvp pernr Personnel no.
ContactPerson knvp parnr Responsible
AddressID knvp adrnr Sold-To Address
_CustomerSalesArea _CustomerSalesArea
_Customer _Customer
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_CustSalesPartnerCounter _CustSalesPartnerCounter

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_CustSalesPartnerFunc_2.
-- 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: ICUSTPARTFUNC2

CREATE VIEW I_CustSalesPartnerFunc_2 AS
SELECT
  knvp.kunnr AS Customer,
  knvp.vkorg AS SalesOrganization,
  knvp.vtweg AS DistributionChannel,
  knvp.spart AS Division,
  knvp.parza AS PartnerCounter,
  cast(knvp.parvw as parvw_unv) AS PartnerFunction,
  knvp.kunn2 AS BPCustomerNumber,
  knvp.knref AS CustomerPartnerDescription,
  knvp.defpa AS DefaultPartner,
  knvp.lifnr AS Supplier,
  knvp.pernr AS PersonnelNumber,
  knvp.parnr AS ContactPerson,
  knvp.adrnr AS AddressID
FROM knvp
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_CustSalesPartnerCounter AS _CustSalesPartnerCounter ON PartnerCounter = _CustSalesPartnerCounter.PartnerCounter  -- association [0..1]
;

Learn More