fiscds_bkpf_usr

DDL: FISVD_BKPF_USR SQL: FISV_BKPF_USR Type: view
28 Fields 3 Data Sources

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.

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 Value
KEY belnr bkpf belnr SD Document
KEY gjahr bkpf gjahr Settlement Year
bldat bkpf bldat Journal Entry Date
budat bkpf budat Posting Date
monat bkpf monat Period Block
cpudt bkpf cpudt Imported On
cputm bkpf cputm Time
aedat bkpf aedat Obsolete
upddt bkpf upddt Last Update
wwert bkpf wwert Translatn Date
usnam bkpf usnam User Name
tcode bkpf tcode Undefined range (can be used for patch levels)
bvorg bkpf bvorg Intercompany Transac
xblnr bkpf xblnr Reference
dbblg bkpf dbblg Rec.Entry Doc.
stblg bkpf stblg Reversed With
stjah bkpf stjah Year
bktxt bkpf bktxt Header Text
waers bkpf waers Transaction Currency
kursf bkpf kursf Exchange Rate
awtyp bkpf awtyp Reference Document Type
awkey bkpf awkey RefKey GJE
xreversal bkpf xreversal Reversal Transaction
ldgrp bkpf ldgrp Target Ledger Group
name_first adrp name_first First Name
name_last adrp name_last Last Name
name_text adrp name_text Full Name

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 fiscds_bkpf_usr.
-- 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.
-- SQL view name: FISV_BKPF_USR

CREATE VIEW fiscds_bkpf_usr AS
SELECT
  bkpf.bukrs AS bukrs,
  bkpf.belnr AS belnr,
  bkpf.gjahr AS gjahr,
  bkpf.bldat AS bldat,
  bkpf.budat AS budat,
  bkpf.monat AS monat,
  bkpf.cpudt AS cpudt,
  bkpf.cputm AS cputm,
  bkpf.aedat AS aedat,
  bkpf.upddt AS upddt,
  bkpf.wwert AS wwert,
  bkpf.usnam AS usnam,
  bkpf.tcode AS tcode,
  bkpf.bvorg AS bvorg,
  bkpf.xblnr AS xblnr,
  bkpf.dbblg AS dbblg,
  bkpf.stblg AS stblg,
  bkpf.stjah AS stjah,
  bkpf.bktxt AS bktxt,
  bkpf.waers AS waers,
  bkpf.kursf AS kursf,
  bkpf.awtyp AS awtyp,
  bkpf.awkey AS awkey,
  bkpf.xreversal AS xreversal,
  bkpf.ldgrp AS ldgrp,
  adrp.name_first AS name_first,
  adrp.name_last AS name_last,
  adrp.name_text AS name_text
LEFT OUTER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp ON /* join condition not captured in parsed metadata */
INNER JOIN adrp ON /* join condition not captured in parsed metadata */
;

Learn More