TCCLG
Payment Cards: Settlement Run Log
TCCLG is an SAP database table in S/4HANA. Payment Cards: Settlement Run Log. It contains 22 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FARV_DP_FAIL_CCBTC | view | from | Failed Settlement Runs | |
| I_PaytCardSettlementRunLg | view | from | BASIC | Payment Card Settlement Run Log |
| P_PaytCardSettlementRunLog | view | from | BASIC |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | ccbtc | CCBTC | Settlement | |||
| bukrs | BUKRS | Company Code | ||||
| hkont | HKONT | G/L Acct | ||||
| vblnr | VBLNR | Payment Doc.No. | ||||
| gjahr | GJAHR | Fiscal Year | ||||
| ccwae | WAERS | Currency | ||||
| setwr | SETWR_CC | Amount | ||||
| xpost | XPOST_CC | Posted | ||||
| xsucc | XSUCC_CC | OK | ||||
| xfail | XFAIL_CC | Errors | ||||
| nsent | NSENT_CC | Settlements | ||||
| fname | FNAME_CC | User | ||||
| fdatu | FDATU_CC | Date | ||||
| fzeit | FZEIT_CC | Time | ||||
| lname | LNAME_CC | User | ||||
| ldatu | LDATU_CC | Date | ||||
| lzeit | LZEIT_CC | Time | ||||
| nitem | NITEM_CC | Items | ||||
| pdatu | PDATU_CC | Settlement Date | ||||
| pzeit | PZEIT_CC | Settlement Time | ||||
| hostb | HOSTB_CC | Host Batch |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Payment Cards: Settlement Run Log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCCLG (
MANDT, -- Client [MANDT]
CCBTC, -- Settlement [CCBTC]
BUKRS, -- Company Code [BUKRS]
HKONT, -- G/L Acct [HKONT]
VBLNR, -- Payment Doc.No. [VBLNR]
GJAHR, -- Fiscal Year [GJAHR]
CCWAE, -- Currency [WAERS]
SETWR, -- Amount [SETWR_CC]
XPOST, -- Posted [XPOST_CC]
XSUCC, -- OK [XSUCC_CC]
XFAIL, -- Errors [XFAIL_CC]
NSENT, -- Settlements [NSENT_CC]
FNAME, -- User [FNAME_CC]
FDATU, -- Date [FDATU_CC]
FZEIT, -- Time [FZEIT_CC]
LNAME, -- User [LNAME_CC]
LDATU, -- Date [LDATU_CC]
LZEIT, -- Time [LZEIT_CC]
NITEM, -- Items [NITEM_CC]
PDATU, -- Settlement Date [PDATU_CC]
PZEIT, -- Settlement Time [PZEIT_CC]
HOSTB, -- Host Batch [HOSTB_CC]
PRIMARY KEY (MANDT, CCBTC)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA