P_Bsec_Glo

DDL: P_BSEC_GLO SQL: PBSECGLO Type: view BASIC

P_Bsec_Glo is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (bsec) and exposes 44 fields with key fields bukrs, belnr, gjahr, buzei.

1 data source(s) 44 fields

Data Sources (1)

SourceAliasJoin Type
bsec bsec from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PBSECGLO view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY bukrs bsec bukrs
KEY belnr bsec belnr
KEY gjahr bsec gjahr
KEY buzei bsec buzei
FirstName bsec name1
LastName bsec name2
name1
name2
name
pstlz bsec pstlz
ort01 bsec ort01
land1 bsec land1
stras bsec stras
pfach bsec pfach
pstl2 bsec pstl2
pskto bsec pskto
bankn bsec bankn
bankl bsec bankl
banks bsec banks
stcd1 bsec stcd1
stcd2 bsec stcd2
stkzu bsec stkzu
stkza bsec stkza
regio bsec regio
bkont bsec bkont
dtaws bsec dtaws
dtams bsec dtams
xcpdk bsec xcpdk
empfg bsec empfg
spras bsec spras
fityp bsec fityp
stcdt bsec stcdt
stkzn bsec stkzn
stcd3 bsec stcd3
stcd4 bsec stcd4
bkref bsec bkref
j_1kfrepre bsec j_1kfrepre
j_1kftbus bsec j_1kftbus
j_1kftind bsec j_1kftind
anred bsec anred
adrnr bsec adrnr
xrguh bsec xrguh
po_box_num bsec po_box_num
begru bsec begru 
@AbapCatalog.sqlViewName: 'PBSECGLO'
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

////////////////////////////////////////////////////////////////////

// This private view is intended to select data from KNAS only   //

// Temporary workaround for Globalization Services                //

////////////////////////////////////////////////////////////////////

define view P_Bsec_Glo as select from bsec
 {
        key bsec.bukrs,
        key bsec.belnr,
        key bsec.gjahr,
        key bsec.buzei,
        bsec.name1 as FirstName,
        bsec.name2 as LastName,
        concat(bsec.name1,bsec.name2) as name1,
        concat(name1,bsec.name3) as name2,
        concat(name2,bsec.name4) as name,
        bsec.pstlz,
        bsec.ort01,
        bsec.land1,
        bsec.stras,
        bsec.pfach,
        bsec.pstl2,
        bsec.pskto,
        bsec.bankn,
        bsec.bankl,
        bsec.banks,
        bsec.stcd1,
        bsec.stcd2,
        bsec.stkzu,
        bsec.stkza,
        bsec.regio,
        bsec.bkont,
        bsec.dtaws,
        bsec.dtams,
        bsec.xcpdk,
        bsec.empfg,
        bsec.spras,
        bsec.fityp,
        bsec.stcdt,
        bsec.stkzn,
        bsec.stcd3,
        bsec.stcd4,
        bsec.bkref,
        bsec.j_1kfrepre,
        bsec.j_1kftbus,
        bsec.j_1kftind,
        bsec.anred,
        bsec.adrnr,
        bsec.xrguh,
        bsec.po_box_num,
        bsec.begru
} 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"BSEC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More