P_Jp_InvcSmmryItem

DDL: P_JP_INVCSMMRYITEM SQL: PJPINVCSMMRYITEM Type: view BASIC
35 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
isjpinvsumit isjpinvsumit from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PJPINVCSMMRYITEM view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY bukrs bukrs Value
KEY belnr belnr SD Document
KEY gjahr gjahr Settlement Year
KEY buzei buzei Posting View Item
bstat bstat Document Status
invsumpayer invsumpayer Inv.Sum.Payer
pigrunit pigrunit Payer Group.Unit
waers waers Transaction Currency
invsumrecip invsumrecip Inv.Sum.Recipt.
grunit grunit Group.Unit
closdate closdate Clos.Date
netdt netdt Due On
minr minr MI Nr.
notincl notincl Not Incl. In MI
miblock miblock MI Block
netamnt netamnt Net Amount
taxamnt taxamnt Tax Amount
mwskz mwskz Tax Code
creauser creauser Created By User
creadate creadate Creation Date
creatime creatime Creation Time
chanuser chanuser Changed By User
chandate chandate Changing Date
chantime chantime Changing Time
itemcat itemcat WComp Item Cat.
cleardate cleardate Paid Up To
netamnt1 netamnt1 Net amount 1
taxamnt1 taxamnt1 Tax amount 1
mwsk1 mwsk1 Tax Code
netamnt2 netamnt2 Net amount 2
taxamnt2 taxamnt2 Tax amount 2
mwsk2 mwsk2 W/Tax Code
netamnt3 netamnt3 Net amount 3
taxamnt3 taxamnt3 Tax amount 3
mwsk3 mwsk3 Tax Code

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 P_Jp_InvcSmmryItem.
-- 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: PJPINVCSMMRYITEM

CREATE VIEW P_Jp_InvcSmmryItem AS
SELECT
  bukrs,
  belnr,
  gjahr,
  buzei,
  bstat,
  invsumpayer,
  pigrunit,
  waers,
  invsumrecip,
  grunit,
  closdate,
  netdt,
  minr,
  notincl,
  miblock,
  netamnt,
  taxamnt,
  mwskz,
  creauser,
  creadate,
  creatime,
  chanuser,
  chandate,
  chantime,
  itemcat,
  cleardate,
  netamnt1,
  taxamnt1,
  mwsk1,
  netamnt2,
  taxamnt2,
  mwsk2,
  netamnt3,
  taxamnt3,
  mwsk3
FROM isjpinvsumit
;

Learn More