P_Sales_Division

DDL: P_SALES_DIVISION SQL: P_TVTA Type: view BASIC

P_Sales_Division is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (tvta) and exposes 22 fields with key fields vkorg, vtweg, spart.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
tvta tvta from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName P_TVTA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY vkorg vkorg
KEY vtweg vtweg
KEY spart spart
vtwku vtwku
spaku spaku
vtwko vtwko
spako spako
maber maber
vkoau vkoau
vtwau vtwau
spaau spaau
gsber gsber
reggb reggb
revfp revfp
fixmg fixmg
afind afind
kkber kkber
j_1asnr j_1asnr
j_1aesnr j_1aesnr
hide hide
j_3gkbaul j_3gkbaul
oid_checkc oid_checkc 
@AbapCatalog.sqlViewName: 'P_TVTA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_Sales_Division
  as select from tvta 
{
      //tvta

  key vkorg,
  key vtweg,
  key spart,
      vtwku,
      spaku,
      vtwko,
      spako,
      maber,
      vkoau,
      vtwau,
      spaau,
      gsber,
      reggb,
      revfp,
      fixmg,
      afind,
      kkber,
      j_1asnr,
      j_1aesnr,
      hide,
      //isp_vb,

      //ism_bp_vtb_group,

      j_3gkbaul,
      oid_checkc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVTA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More