C_ShipToPartyByCustSalesAreaVH

DDL: C_SHIPTOPARTYBYCUSTSALESAREAVH Type: view_entity CONSUMPTION
12 Fields 1 Data Sources 1 Associations

Ship To Party By Sales Area

C_ShipToPartyByCustSalesAreaVH is a Consumption CDS View that provides data about "Ship To Party By Sales Area" in SAP S/4HANA. It reads from 1 data source (I_CustSalesPartnerFunc_2) and exposes 12 fields with key fields Customer, SalesOrganization, DistributionChannel, Division, PartnerCounter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustSalesPartnerFunc_2 CustomerSalesPartnerFunction from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Customer _ShipToParty $projection.ShipToParty = _ShipToParty.Customer

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Consumption.ranked true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Ship To Party By Sales Area view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustSalesPartnerFunc_2 Customer Sold-to Party
KEY SalesOrganization I_CustSalesPartnerFunc_2 SalesOrganization Sales Organization
KEY DistributionChannel I_CustSalesPartnerFunc_2 DistributionChannel RefDistCh-Cust/Mat.
KEY Division I_CustSalesPartnerFunc_2 Division Internal Division ID
KEY PartnerCounter I_CustSalesPartnerFunc_2 PartnerCounter Partner counter
ShipToParty Ship-to Party
ShipToPartyName
OrganizationBPName1 _ShipToParty OrganizationBPName1 Name 1
OrganizationBPName2 _ShipToParty OrganizationBPName2 Name 2
_Customer I_CustSalesPartnerFunc_2 _Customer
_CustomerSalesArea I_CustSalesPartnerFunc_2 _CustomerSalesArea
_ShipToParty _ShipToParty

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 C_ShipToPartyByCustSalesAreaVH.
-- 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.

CREATE VIEW C_ShipToPartyByCustSalesAreaVH AS
SELECT
  CustomerSalesPartnerFunction.Customer AS Customer,
  CustomerSalesPartnerFunction.SalesOrganization AS SalesOrganization,
  CustomerSalesPartnerFunction.DistributionChannel AS DistributionChannel,
  CustomerSalesPartnerFunction.Division AS Division,
  CustomerSalesPartnerFunction.PartnerCounter AS PartnerCounter,
  cast ( CustomerSalesPartnerFunction.BPCustomerNumber as kunnr preserving type ) AS ShipToParty,
  cast ( _ShipToParty.CustomerName as vdm_ship_to_name preserving type ) AS ShipToPartyName,
  _ShipToParty.OrganizationBPName1 AS OrganizationBPName1,
  _ShipToParty.OrganizationBPName2 AS OrganizationBPName2,
  CustomerSalesPartnerFunction._Customer AS _Customer,
  CustomerSalesPartnerFunction._CustomerSalesArea AS _CustomerSalesArea
FROM I_CustSalesPartnerFunc_2 AS CustomerSalesPartnerFunction
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
;

Learn More