SAFT_PTD_PAYM_A

Transparent Table Temporary Data
23 Fields 1 CDS Views

SAF-T PT Payment Analytics

SAFT_PTD_PAYM_A is an SAP database table in S/4HANA. SAF-T PT Payment Analytics. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PT_SAFTPaymentStructure view_entity from BASIC

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY companycode BUKRS Company Code
KEY paymentreference abap.char
KEY fiscalyear GJAHR Fiscal Year
documentitemnumber POSNR Item
pt_seriesdocumenttype GLO_PT_SERIES_DT SAF-T Document Type
documentbillingstatus FKSAA Ord.Rel.BillgSt
pt_seriesdocumentnumber GLO_PT_ATCUD ATCUD Code
companycodecurrency WAERS Currency
debitamountincocodecrcy FIS_DR_HSL Debit Amount in Company Code Currency
creditamountincocodecrcy FIS_CR_HSL Credit Amount in Company Code Currency
customerpaymentmethod CHAR2 Component of the Version Number
paymentamount SUMMH Credit total
paymentdate FARP_PAYMENT_DATE Payment Date
netamount SUMMH Credit total
grossamount SUMMH Credit total
businesspartnercustomer abap.char
exchangerate FIS_EXCHANGE_RATE Exchange Rate
transactioncurrency FIS_RWCUR Transaction Currency
totalgrossamountintranscrcy GLO_TOTAL_AMOUNT_INTRANCRCY Total Amt In Tr Crcy
pt_saftinvoicereference SAFT_PT_DOCUMENTNUMBER Document Number
invoicedate abap.dats
in_invoicedate abap.dats

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.

-- SAF-T PT Payment Analytics
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFT_PTD_PAYM_A (
    MANDT,                        -- Client [MANDT]
    COMPANYCODE,                  -- Company Code [BUKRS]
    PAYMENTREFERENCE,             -- abap.char
    FISCALYEAR,                   -- Fiscal Year [GJAHR]
    DOCUMENTITEMNUMBER,           -- Item [POSNR]
    PT_SERIESDOCUMENTTYPE,        -- SAF-T Document Type [GLO_PT_SERIES_DT]
    DOCUMENTBILLINGSTATUS,        -- Ord.Rel.BillgSt [FKSAA]
    PT_SERIESDOCUMENTNUMBER,      -- ATCUD Code [GLO_PT_ATCUD]
    COMPANYCODECURRENCY,          -- Currency [WAERS]
    DEBITAMOUNTINCOCODECRCY,      -- Debit Amount in Company Code Currency [FIS_DR_HSL]
    CREDITAMOUNTINCOCODECRCY,     -- Credit Amount in Company Code Currency [FIS_CR_HSL]
    CUSTOMERPAYMENTMETHOD,        -- Component of the Version Number [CHAR2]
    PAYMENTAMOUNT,                -- Credit total [SUMMH]
    PAYMENTDATE,                  -- Payment Date [FARP_PAYMENT_DATE]
    NETAMOUNT,                    -- Credit total [SUMMH]
    GROSSAMOUNT,                  -- Credit total [SUMMH]
    BUSINESSPARTNERCUSTOMER,      -- abap.char
    EXCHANGERATE,                 -- Exchange Rate [FIS_EXCHANGE_RATE]
    TRANSACTIONCURRENCY,          -- Transaction Currency [FIS_RWCUR]
    TOTALGROSSAMOUNTINTRANSCRCY,  -- Total Amt In Tr Crcy [GLO_TOTAL_AMOUNT_INTRANCRCY]
    PT_SAFTINVOICEREFERENCE,      -- Document Number [SAFT_PT_DOCUMENTNUMBER]
    INVOICEDATE,                  -- abap.dats
    IN_INVOICEDATE,               -- abap.dats
    PRIMARY KEY (MANDT, COMPANYCODE, PAYMENTREFERENCE, FISCALYEAR)
);

Learn More