PPMGAG_T_PTERMS

Transparent Table Application Table
22 Fields 2 CDS Views

Prepayment Payment Terms

PPMGAG_T_PTERMS is an SAP database table in S/4HANA. Prepayment Payment Terms. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PrepaymentAgreementRequest view from BASIC Prepayment Request Tab Contract
I_PrepaymentPaymentTerms view from BASIC Prepayment Payment Terms

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY payment_terms_guid SYSUUID_X16 UUID
sapbusinessobjecttypecode SBO_OBJ_NAME SAP Obj Rep
docnumber PPMGAC_E_DOC_NO Document Number
documentitemnumber POSNR Item
serial_number PPMGAG_E_SERIAL_NUMBER Serial Number
zterm DZTERM Pyt Terms
ppmt_req PPMGAG_E_PPMT_REQ Release Settlement
ppmt_date PPMGAG_E_PPMT_DATE Prepayment Date
ppmt_rcvd PPMGAG_E_PPMT_RCVD Prepayment Received
ppmt_made PPMGAG_E_PPMT_MADE Prepayment Made
ppmt_typ PPMGAG_E_AGMNTYP Prepay Agreemnt Type
ppmt_amt PPMGAG_E_AGMAMT Pre Agrm Amount
waers PPMGAG_E_AGMCUR Currency
prepaymentagreement PPMGAC_E_AGMNT Prepayment Agreement
deleted PPMGAC_E_DELETE Delete
status PPMGAG_E_PPMT_STATUS Pmt Term Post Status
conditionapplication KAPPL Application
createdbyuser PPMGAG_E_CREATEDBYUSER Created By
creationdatetime PPMGAG_E_CREATIONDATETIME Rec. Crtn Timestamp
lastchangedbyuser PPMGAG_E_LASTCHANGEDBYUSER Last Changed By
lastchangedatetime PPMGAG_E_LASTCHANGEDATETIME Last Changed On

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.

-- Prepayment Payment Terms
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPMGAG_T_PTERMS (
    MANDT,                      -- Client [MANDT]
    PAYMENT_TERMS_GUID,         -- UUID [SYSUUID_X16]
    SAPBUSINESSOBJECTTYPECODE,  -- SAP Obj Rep [SBO_OBJ_NAME]
    DOCNUMBER,                  -- Document Number [PPMGAC_E_DOC_NO]
    DOCUMENTITEMNUMBER,         -- Item [POSNR]
    SERIAL_NUMBER,              -- Serial Number [PPMGAG_E_SERIAL_NUMBER]
    ZTERM,                      -- Pyt Terms [DZTERM]
    PPMT_REQ,                   -- Release Settlement [PPMGAG_E_PPMT_REQ]
    PPMT_DATE,                  -- Prepayment Date [PPMGAG_E_PPMT_DATE]
    PPMT_RCVD,                  -- Prepayment Received [PPMGAG_E_PPMT_RCVD]
    PPMT_MADE,                  -- Prepayment Made [PPMGAG_E_PPMT_MADE]
    PPMT_TYP,                   -- Prepay Agreemnt Type [PPMGAG_E_AGMNTYP]
    PPMT_AMT,                   -- Pre Agrm Amount [PPMGAG_E_AGMAMT]
    WAERS,                      -- Currency [PPMGAG_E_AGMCUR]
    PREPAYMENTAGREEMENT,        -- Prepayment Agreement [PPMGAC_E_AGMNT]
    DELETED,                    -- Delete [PPMGAC_E_DELETE]
    STATUS,                     -- Pmt Term Post Status [PPMGAG_E_PPMT_STATUS]
    CONDITIONAPPLICATION,       -- Application [KAPPL]
    CREATEDBYUSER,              -- Created By [PPMGAG_E_CREATEDBYUSER]
    CREATIONDATETIME,           -- Rec. Crtn Timestamp [PPMGAG_E_CREATIONDATETIME]
    LASTCHANGEDBYUSER,          -- Last Changed By [PPMGAG_E_LASTCHANGEDBYUSER]
    LASTCHANGEDATETIME,         -- Last Changed On [PPMGAG_E_LASTCHANGEDATETIME]
    PRIMARY KEY (MANDT, PAYMENT_TERMS_GUID)
);

Learn More