MMPUR_EXT_T052

Transparent Table Application Table
8 Fields 2 CDS Views

Extracted Backend Terms of Payment

MMPUR_EXT_T052 is an SAP database table in S/4HANA. Extracted Backend Terms of Payment. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProcurementHubPaymentTerms view from BASIC Basic View for Payment Terms in Procurement Hub
P_ProcmntHubPayTrmsCndn1 view from BASIC

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY extsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
KEY paymentterms DZTERM Pyt Terms
cashdiscount1days DZTAGE Days from Baseline Date for Payment
cashdiscount2days DZTAGE Days from Baseline Date for Payment
netpaymentdays DZTAGE Days from Baseline Date for Payment
cashdiscount1percent DZPROZ Cash Discount Percentage Rate
cashdiscount2percent DZPROZ Cash Discount Percentage Rate

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.

-- Extracted Backend Terms of Payment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_T052 (
    MANDT,                 -- Client [MANDT]
    EXTSOURCESYSTEM,       -- Connected System ID [MMPUR_D_SOURCE_SYS]
    PAYMENTTERMS,          -- Pyt Terms [DZTERM]
    CASHDISCOUNT1DAYS,     -- Days from Baseline Date for Payment [DZTAGE]
    CASHDISCOUNT2DAYS,     -- Days from Baseline Date for Payment [DZTAGE]
    NETPAYMENTDAYS,        -- Days from Baseline Date for Payment [DZTAGE]
    CASHDISCOUNT1PERCENT,  -- Cash Discount Percentage Rate [DZPROZ]
    CASHDISCOUNT2PERCENT,  -- Cash Discount Percentage Rate [DZPROZ]
    PRIMARY KEY (MANDT, EXTSOURCESYSTEM, PAYMENTTERMS)
);

Learn More