P_CcpCustLineItem_2

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_2.
-- 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: PCCPCSTLNITM2
-- Parameters: P_AgingSecCount : int4, P_AgingSecDays : int4

CREATE VIEW P_CcpCustLineItem_2 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,
  status,
  display_doc,
  pdf,
  doc_type,
  payment_ind
FROM P_CcpCustLineItem_1
LEFT OUTER JOIN I_CompanyCode AS _comp_code ON bukrs = _comp_code.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _cust ON kunnr = _cust.Customer  -- association [1..1]
LEFT OUTER JOIN I_CustomerCompany AS _cust_comp ON bukrs = _cust_comp.CompanyCode AND kunnr = _cust_comp.Customer  -- association [1..1]
LEFT OUTER JOIN I_PostingKeyWithSpecialGLCode AS _posting_key ON bschl = _posting_key.PostingKey AND umskz = _posting_key.SpecialGLCode  -- association [0..1]
LEFT OUTER JOIN P_CcpLatestDisputeCase AS _dispute_case ON dispute_case_objkey = _dispute_case.obj_key  -- association [0..1]
LEFT OUTER JOIN I_AcctgDocPaymentCardData AS _card_payt_data ON bukrs = _card_payt_data.CompanyCode AND belnr = _card_payt_data.AccountingDocument AND gjahr = _card_payt_data.FiscalYear AND rfzei = _card_payt_data.PaymentCardItem  -- association [0..1]
;