P_PaytCardSettlementRunLog

DDL: P_PAYTCARDSETTLEMENTRUNLOG SQL: PTCCLG Type: view BASIC
21 Fields 1 Data Sources

P_PaytCardSettlementRunLog is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (tcclg) and exposes 21 fields with key field PaymentCardPaymentSettlement.

Data Sources (1)

SourceAliasJoin Type
tcclg tcclg from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PTCCLG view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PaymentCardPaymentSettlement ccbtc Settlement
CompanyCode bukrs Value
GLAccount hkont Transfer acct
PaymentDocument vblnr Payment Doc.No.
FiscalYear gjahr Settlement Year
Currency ccwae Currency
PaytCardToBeSettledAmount setwr Amount
PaytCardSettlementDocIsPosted xpost To Be Posted
PaytCardSettlementIsSuccessful xsucc OK
xfail xfail Errors
nsent nsent Settlements
fname fname User
fdatu fdatu From Date
fzeit fzeit Time
lname lname User
ldatu ldatu Date
lzeit lzeit Time
nitem nitem Items
pdatu pdatu Settlement Date
pzeit pzeit Time
hostb hostb Host Batch

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_PaytCardSettlementRunLog.
-- 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: PTCCLG

CREATE VIEW P_PaytCardSettlementRunLog AS
SELECT
  ccbtc AS PaymentCardPaymentSettlement,
  bukrs AS CompanyCode,
  hkont AS GLAccount,
  vblnr AS PaymentDocument,
  gjahr AS FiscalYear,
  ccwae AS Currency,
  setwr AS PaytCardToBeSettledAmount,
  xpost AS PaytCardSettlementDocIsPosted,
  xsucc AS PaytCardSettlementIsSuccessful,
  xfail,
  nsent,
  fname,
  fdatu,
  fzeit,
  lname,
  ldatu,
  lzeit,
  nitem,
  pdatu,
  pzeit,
  hostb
FROM tcclg
;

Learn More