P_CcpCustLineItem_1

DDL: P_CCPCUSTLINEITEM_1 SQL: PCCPCSTLNITM1 Type: view COMPOSITE
143 Fields 1 Data Sources

CCP customer line items cube

P_CcpCustLineItem_1 is a Composite CDS View that provides data about "CCP customer line items cube" in SAP S/4HANA. It reads from 1 data source (P_CcpCustLineItem) and exposes 143 fields with key fields bukrs, gjahr, belnr, buzei.

Data Sources (1)

SourceAliasJoin Type
P_CcpCustLineItem P_CcpCustLineItem from

Parameters (2)

NameTypeDefault
P_AgingSecCount int4
P_AgingSecDays int4

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PCCPCSTLNITM1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CCP customer line items cube view

Fields (143)

KeyFieldSource TableSource FieldDescription
KEY bukrs bukrs Value
KEY gjahr gjahr Settlement Year
KEY belnr belnr SD Document
KEY buzei buzei Posting View Item
kunnr kunnr Stock customer
umsks umsks Transact.Type
umskz umskz Special G/L Ind
augdt augdt Clearing
augbl augbl Clrng doc.
zuonr zuonr Finance Project
budat budat Posting Date
bldat bldat Journal Entry Date
waers waers Transaction Currency
xblnr xblnr Reference
blart blart Rep. rec. doc. type
monat monat Period Block
bschl bschl Posting Key
shkzg shkzg Returns
gsber gsber Business Area
mwskz mwskz Tax Code
dmbtr dmbtr Loc. amount
wrbtr wrbtr Gross Amount
mwsts mwsts LC tax amount
wmwst wmwst Tax Amount
bdiff bdiff Valuation Diff.
bdif2 bdif2 Valuation Diff. 2
sgtxt sgtxt Text
projn projn WBS Element
aufnr aufnr SettlementOrder
anln1 anln1 Asset
anln2 anln2 Sub-number
saknr saknr G/L Account
hkont hkont Transfer acct
filkd filkd Branch
zfbdt zfbdt Payment date
zterm zterm Terms of Payment
zbd1t zbd1t Payment in
zbd2t zbd2t Payment in
zbd3t zbd3t Payment in
zbd1p zbd1p Max. Cash Dis. (%)
zbd2p zbd2p Nrm. Cash Dis. (%)
sk1dt sk1dt Cash Discount 1
sk2dt sk2dt Cash Discount 2
netdt netdt Due On
skfbt skfbt Disc. base
sknto sknto Discount Amt
wskto wskto CD Amount
zlsch zlsch Pymt Meth.
zlspr zlspr Pymt Lock Rsn
zbfix zbfix Fixed
hbkid hbkid House Bank
bvtyp bvtyp Part.bank type
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
samnr samnr Collect.Inv.
mansp mansp DunnLockReason
mschl mschl Dunning key
madat madat Last Dunned
manst manst Dunning Level
maber maber Dunning Area
xzahl xzahl Payt Tran.
mwsk1 mwsk1 Tax Code
mwsk2 mwsk2 W/Tax Code
mwsk3 mwsk3 Tax Code
bstat bstat Document Status
vbund vbund Trading Partner
vbeln vbeln SD Sched. Agmt
rebzt rebzt Follow-On Doc. Type
stceg stceg VAT Reg. No.
egbld egbld Dest. C/R
rstgr rstgr Reason Code
vertt vertt Contract Type
vertn vertn Int. dist. key
vbewa vbewa Flow Type
wverw wverw Usage
projk projk WBS Element
fipos fipos Commitment item
nplnr nplnr Network
aufpl aufpl TaskList No.Ops
aplzl aplzl Plan No.f.Oper.
xegdr xegdr EU Triang. Deal
dmbe2 dmbe2 LC2 Amount
dmbe3 dmbe3 LC3 Amount
bdif3 bdif3 Valuation Diff. 3
xragl xragl Reverse clrg
uzawe uzawe Pmnt Meth. Sup.
xstov xstov Reversal Flag
xref1 xref1 Reference Key 1
xref2 xref2 Reference Key 2
pswsl pswsl G/L Currency
pswbt pswbt G/L Amount
lzbkz lzbkz SCB Ind.
landl landl Supply C/R
imkey imkey Real Estate Key
vbel2 vbel2 Sales Document
posn2 posn2 Item
eten2 eten2 Schedule Line
fistl fistl Funds Center
geber geber Fund
dabrz dabrz Reference date
xnegp xnegp Reversl Posting Type
kostl kostl Substitute CC
rfzei rfzei Payt Card Item
kkber kkber Cred.Contr.Area
prctr prctr Profit Centers
xref3 xref3 Third Reference
qsskz qsskz WTax Code
dtws1 dtws1 Instruct. Key 1
dtws2 dtws2 Instruct. Key 2
dtws3 dtws3 Instruct. key 3
dtws4 dtws4 Instruct. key 4
xpypr xpypr Payment Sent
kidno kidno Payment Ref.
absbt absbt Hedged Amount
ccbtc ccbtc Settlement
pycur pycur Paymnt Crcy
pyamt pyamt Pt Crcy Amt
bupla bupla Business place
secco secco Section Code
cession_kz cession_kz AR Pledging Ind
grant_nbr grant_nbr Receiver Grant
gmvkz gmvkz Execution
fkber fkber Functional Area
pprct pprct Partner PC
buzid buzid Line Item ID
auggj auggj Clrg Fiscal Yr
hktid hktid House Bank Account
budget_pd budget_pd Rec BudPer
pays_prov pays_prov PSP
pays_tran pays_tran PSP Payment Ref.
mndid mndid Mandate Ref.
payt_rsn payt_rsn Payment Reason
vname vname Volatility Name
egrup egrup Equity group
gkont gkont Offsetting Acct
gkart gkart Offst.Acct Type
awtyp awtyp Reference Document Type
bukrs_sender bukrs_sender Sender CoCode
belnr_sender belnr_sender Sender Doc.No.
gjahr_sender gjahr_sender Sender FiscalYr
payment_ind xzahl Payt Tran.
system_date

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_CcpCustLineItem_1.
-- 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: PCCPCSTLNITM1
-- Parameters: P_AgingSecCount : int4, P_AgingSecDays : int4

CREATE VIEW P_CcpCustLineItem_1 AS
SELECT
  bukrs,
  gjahr,
  belnr,
  buzei,
  kunnr,
  umsks,
  umskz,
  augdt,
  augbl,
  zuonr,
  budat,
  bldat,
  waers,
  xblnr,
  blart,
  monat,
  bschl,
  shkzg,
  gsber,
  mwskz,
  dmbtr,
  wrbtr,
  mwsts,
  wmwst,
  bdiff,
  bdif2,
  sgtxt,
  projn,
  aufnr,
  anln1,
  anln2,
  saknr,
  hkont,
  filkd,
  zfbdt,
  zterm,
  zbd1t,
  zbd2t,
  zbd3t,
  zbd1p,
  zbd2p,
  sk1dt,
  sk2dt,
  netdt,
  skfbt,
  sknto,
  wskto,
  zlsch,
  zlspr,
  zbfix,
  hbkid,
  bvtyp,
  rebzg,
  rebzj,
  rebzz,
  samnr,
  mansp,
  mschl,
  madat,
  manst,
  maber,
  xzahl,
  mwsk1,
  mwsk2,
  mwsk3,
  bstat,
  vbund,
  vbeln,
  rebzt,
  stceg,
  egbld,
  rstgr,
  vertt,
  vertn,
  vbewa,
  wverw,
  projk,
  fipos,
  nplnr,
  aufpl,
  aplzl,
  xegdr,
  dmbe2,
  dmbe3,
  bdif3,
  xragl,
  uzawe,
  xstov,
  xref1,
  xref2,
  pswsl,
  pswbt,
  lzbkz,
  landl,
  imkey,
  vbel2,
  posn2,
  eten2,
  fistl,
  geber,
  dabrz,
  xnegp,
  kostl,
  rfzei,
  kkber,
  prctr,
  xref3,
  qsskz,
  dtws1,
  dtws2,
  dtws3,
  dtws4,
  xpypr,
  kidno,
  absbt,
  ccbtc,
  pycur,
  pyamt,
  bupla,
  secco,
  cession_kz,
  grant_nbr,
  gmvkz,
  fkber,
  pprct,
  buzid,
  auggj,
  hktid,
  budget_pd,
  pays_prov,
  pays_tran,
  mndid,
  payt_rsn,
  vname,
  egrup,
  gkont,
  gkart,
  awtyp,
  bukrs_sender,
  belnr_sender,
  gjahr_sender,
  xzahl AS payment_ind,
  $session.system_date AS system_date
FROM P_CcpCustLineItem
;

Learn More