fiscds_bkpf_usr

DDL: FISVD_BKPF_USR SQL: FISV_BKPF_USR Type: view

Line Item Browser: DDL Source

fiscds_bkpf_usr is a CDS View that provides data about "Line Item Browser: DDL Source" in SAP S/4HANA. It reads from 3 data sources (adrp, adrp, usr21) and exposes 28 fields with key fields bukrs, belnr, gjahr.

3 data source(s) 28 fields

Data Sources (3)

SourceAliasJoin Type
adrp adrp left_outer
adrp adrp inner
usr21 usr21 left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FISV_BKPF_USR view
EndUserText.label Line Item Browser: DDL Source view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY bukrs bkpf bukrs
KEY belnr bkpf belnr
KEY gjahr bkpf gjahr
bldat bkpf bldat
budat bkpf budat
monat bkpf monat
cpudt bkpf cpudt
cputm bkpf cputm
aedat bkpf aedat
upddt bkpf upddt
wwert bkpf wwert
usnam bkpf usnam
tcode bkpf tcode
bvorg bkpf bvorg
xblnr bkpf xblnr
dbblg bkpf dbblg
stblg bkpf stblg
stjah bkpf stjah
bktxt bkpf bktxt
waers bkpf waers
kursf bkpf kursf
awtyp bkpf awtyp
awkey bkpf awkey
xreversal bkpf xreversal
ldgrp bkpf ldgrp
name_first adrp name_first
name_last adrp name_last
name_text adrp name_text 
@AbapCatalog.sqlViewName: 'FISV_BKPF_USR'
@EndUserText.label: 'Line Item Browser: DDL Source'
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED

-- define view  fiscds_bkpf_usr as select from
-- ( (    bkpf left outer join usr21 on bkpf.usnam = usr21.bname ) 
--             left outer join adrp  on usr21.persnumber = adrp.persnumber )    

define view  fiscds_bkpf_usr as select from
(  bkpf left outer join ( usr21 inner join adrp on usr21.persnumber = adrp.persnumber ) on bkpf.usnam = usr21.bname )         
{
key bkpf.bukrs as bukrs,
key bkpf.belnr as belnr,
key bkpf.gjahr as gjahr,

bkpf.bldat,
bkpf.budat,
bkpf.monat,
bkpf.cpudt,
bkpf.cputm,
bkpf.aedat,
bkpf.upddt,
bkpf.wwert,
bkpf.usnam,
bkpf.tcode,
bkpf.bvorg,
bkpf.xblnr,
bkpf.dbblg,
bkpf.stblg,
bkpf.stjah,
bkpf.bktxt,
bkpf.waers,
bkpf.kursf,
bkpf.awtyp,
bkpf.awkey,
bkpf.xreversal,
bkpf.ldgrp,

adrp.name_first,
adrp.name_last,
adrp.name_text

}

Learn More