I_SupDmndSalesArea

DDL: I_SUPDMNDSALESAREA Type: view BASIC
15 Fields 1 Data Sources

Basic View for STO

I_SupDmndSalesArea is a Basic CDS View that provides data about "Basic View for STO" in SAP S/4HANA. It reads from 1 data source (knvv) and exposes 15 fields with key fields Customer, SalesOrganization, DistributionChannel, OrganizationDivision.

Data Sources (1)

SourceAliasJoin Type
knvv SalesArea from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Basic View for STO view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDOSA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Customer knvv kunnr Stock customer
KEY SalesOrganization knvv vkorg SD Sales Org.
KEY DistributionChannel knvv vtweg RefDistCh-Cust/Mat.
KEY OrganizationDivision knvv spart Source supplier
CustomerGroup knvv kdgrp Customer group
SalesDistrict knvv bzirk Sales District
DeliveryIsBlockedForCustomer
BillingIsBlockedForCustomer
SalesGroup
SalesOffice
AdditionalCustomerGroup1
AdditionalCustomerGroup2
AdditionalCustomerGroup3
AdditionalCustomerGroup4
AdditionalCustomerGroup5

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_SupDmndSalesArea.
-- 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 I_SupDmndSalesArea AS
SELECT
  SalesArea.kunnr AS Customer,
  SalesArea.vkorg AS SalesOrganization,
  SalesArea.vtweg AS DistributionChannel,
  SalesArea.spart AS OrganizationDivision,
  SalesArea.kdgrp AS CustomerGroup,
  SalesArea.bzirk AS SalesDistrict,
  '' AS DeliveryIsBlockedForCustomer,
  cast ('' as faksd_x ) AS BillingIsBlockedForCustomer,
  '' AS SalesGroup,
  '' AS SalesOffice,
  '' AS AdditionalCustomerGroup1,
  '' AS AdditionalCustomerGroup2,
  '' AS AdditionalCustomerGroup3,
  '' AS AdditionalCustomerGroup4,
  '' AS AdditionalCustomerGroup5
FROM knvv AS SalesArea
;

Learn More