P_Sales_Organization

DDL: P_SALES_ORGANIZATION SQL: P_TVKO Type: view BASIC

P_Sales_Organization is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (tvko) and exposes 26 fields with key field vkorg.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
tvko tvko from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName P_TVKO 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 (26)

KeyFieldSource TableSource FieldDescription
KEY vkorg vkorg
waers waers
bukrs bukrs
adrnr adrnr
txnam_adr txnam_adr
txnam_kop txnam_kop
txnam_fus txnam_fus
txnam_gru txnam_gru
vkoau vkoau
kunnr kunnr
boavo boavo
vkokl vkokl
ekorg ekorg
ekgrp ekgrp
lifnr lifnr
werks werks
bsart bsart
bstyp bstyp
bwart bwart
lgort lgort
txnam_sdb txnam_sdb
mwskz mwskz
xstceg xstceg
j_1anutime j_1anutime
maxbi maxbi
hide hide 
@AbapCatalog.sqlViewName: 'P_TVKO'
@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_Organization
  as select from tvko 

{
      //tvko

  key vkorg,
      waers,
      bukrs,
      adrnr,
      txnam_adr,
      txnam_kop,
      txnam_fus,
      txnam_gru,
      vkoau,
      kunnr,
      boavo,
      vkokl,
      ekorg,
      ekgrp,
      lifnr,
      werks,
      bsart,
      bstyp,
      bwart,
      lgort,
      txnam_sdb,
      mwskz,
      xstceg,
      j_1anutime,
      maxbi,
      hide

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

Learn More