P_Jp_InvcSmmryHeader

DDL: P_JP_INVCSMMRYHEADER SQL: PJPINVCSMMRYHD Type: view BASIC Package: GLO_FIN_JP
33 Fields 1 Data Sources

Invoice Summary Header

P_Jp_InvcSmmryHeader is a Basic CDS View that provides data about "Invoice Summary Header" in SAP S/4HANA. It reads from 1 data source (isjpinvsumhd) and exposes 33 fields with key fields bukrs, invsumnr, invsumtype. Part of development package GLO_FIN_JP.

Data Sources (1)

SourceAliasJoin Type
isjpinvsumhd isjpinvsumhd from

Annotations (6)

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

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY bukrs bukrs Value
KEY invsumnr invsumnr Inv.Sum.Nr.
KEY invsumtype invsumtype Inv.Sum.Type
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
pinr pinr Payer Inv. Nr.
netamnt netamnt Net Amount
taxamnt taxamnt Tax Amount
paidamnt paidamnt Paid Amount
previnvamnt previnvamnt Prev.Inv.Amnt.
carfwdamnt carfwdamnt Carry fwd Amnt
prevclosdate prevclosdate Previous Clos. Date
prevnetdt prevnetdt Prev. Due Date
previnvsumnr previnvsumnr Prev. Inv.Sum.Nr.
nextinvsumnr nextinvsumnr Next. Inv.Sum.Nr.
openamnt openamnt Open Amount
cleardate cleardate Paid Up To
cancelled cancelled Item Discarded
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
nropenitems nropenitems No of Open Items
banks banks Bank Ctry/Rgn. Key
bankl bankl House Bank
virtacctnr virtacctnr Virt.Acct.Nr.

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_InvcSmmryHeader.
-- 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: PJPINVCSMMRYHD

CREATE VIEW P_Jp_InvcSmmryHeader AS
SELECT
  bukrs,
  invsumnr,
  invsumtype,
  invsumpayer,
  pigrunit,
  waers,
  invsumrecip,
  grunit,
  closdate,
  netdt,
  pinr,
  netamnt,
  taxamnt,
  paidamnt,
  previnvamnt,
  carfwdamnt,
  prevclosdate,
  prevnetdt,
  previnvsumnr,
  nextinvsumnr,
  openamnt,
  cleardate,
  cancelled,
  creauser,
  creadate,
  creatime,
  chanuser,
  chandate,
  chantime,
  nropenitems,
  banks,
  bankl,
  virtacctnr
FROM isjpinvsumhd
;

Learn More