E_BPSALESAREA_D

DDL: E_BPSALESAREA_D SQL: EBPSAC Type: view EXTENSION
5 Fields 1 Data Sources

Extensibility BP Sales Area Core

E_BPSALESAREA_D is a Extension CDS View that provides data about "Extensibility BP Sales Area Core" in SAP S/4HANA. It reads from 1 data source (knvv) and exposes 5 fields with key fields Customer, SalesOrganization, DistributionChannel, Division.

Data Sources (1)

SourceAliasJoin Type
knvv Persistence from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName EBPSAC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #EXTENSION view
EndUserText.label Extensibility BP Sales Area Core view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Customer knvv kunnr Stock customer
KEY SalesOrganization knvv vkorg SD Sales Org.
KEY DistributionChannel knvv vtweg RefDistCh-Cust/Mat.
KEY Division knvv spart Source supplier
IsActiveEntity

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 E_BPSALESAREA_D.
-- 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: EBPSAC

CREATE VIEW E_BPSALESAREA_D AS
SELECT
  Persistence.kunnr AS Customer,
  Persistence.vkorg AS SalesOrganization,
  Persistence.vtweg AS DistributionChannel,
  Persistence.spart AS Division,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity
FROM knvv AS Persistence
;

Learn More