GSFINCSILD_PMTS

Transparent Table Application Table
21 Fields 1 CDS Views

Cash Payments

GSFINCSILD_PMTS is an SAP database table in S/4HANA. Cash Payments. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_IL_PaymentItem view_entity from BASIC Payment Item in IL Cash System

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cash_pmt_id gsfincsil_pmt_id Payment ID
KEY bukrs bukrs Company Code
KEY gjahr gjahr Fiscal Year
belnr belnr_d Document Number
pmt gsfincsil_pmt Payment Method
cash_num gsfincsil_csnum Cash Number
amount wrbtr Amount
status gsfincsil_pmtstatus Payment Status
bankl bankl Bank Number
bankn bankn Bank Account
cc_num gsfincsil_ccnum Credit card number
bt_id gsfincsil_bt Bank T. Ref Number
kunnr kunnr Customer
lifnr lifnr Supplier
hkont hkont G/L Acct
cheque_num gsfincsil_cheque_num Cheque Number
cheque_duedate gsfincsil_cheque_duedate Cheque Duedate
zlsch schzw_bseg Payt Method
cc_reference_num gsfincsil_ref_num Reference Number
cc_pmt_trn_type gsfincsil_trn_type Credit Type

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.

-- Cash Payments
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSFINCSILD_PMTS (
    MANDT,             -- Client [mandt]
    CASH_PMT_ID,       -- Payment ID [gsfincsil_pmt_id]
    BUKRS,             -- Company Code [bukrs]
    GJAHR,             -- Fiscal Year [gjahr]
    BELNR,             -- Document Number [belnr_d]
    PMT,               -- Payment Method [gsfincsil_pmt]
    CASH_NUM,          -- Cash Number [gsfincsil_csnum]
    AMOUNT,            -- Amount [wrbtr]
    STATUS,            -- Payment Status [gsfincsil_pmtstatus]
    BANKL,             -- Bank Number [bankl]
    BANKN,             -- Bank Account [bankn]
    CC_NUM,            -- Credit card number [gsfincsil_ccnum]
    BT_ID,             -- Bank T. Ref Number [gsfincsil_bt]
    KUNNR,             -- Customer [kunnr]
    LIFNR,             -- Supplier [lifnr]
    HKONT,             -- G/L Acct [hkont]
    CHEQUE_NUM,        -- Cheque Number [gsfincsil_cheque_num]
    CHEQUE_DUEDATE,    -- Cheque Duedate [gsfincsil_cheque_duedate]
    ZLSCH,             -- Payt Method [schzw_bseg]
    CC_REFERENCE_NUM,  -- Reference Number [gsfincsil_ref_num]
    CC_PMT_TRN_TYPE,   -- Credit Type [gsfincsil_trn_type]
    PRIMARY KEY (MANDT, CASH_PMT_ID, BUKRS, GJAHR)
);

Learn More