PPMGAG_T_PPMT

Transparent Table Application Table
95 Fields 2 CDS Views

Pepayment Agreement Details

PPMGAG_T_PPMT is an SAP database table in S/4HANA. Pepayment Agreement Details. It contains 95 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PrepaymentAgreement view from EXTENSION Prepayment Agreement Extension View
I_PrepaymentAgreement view from BASIC Prepayment Agreement Interface View

Fields (95)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prepaymentagreementuuid /BOBF/UUID Key
prepaymentagreement PPMGAC_E_AGMNT Prepayment Agreement
prepaymentagreementtype PPMGAG_E_AGMNTYP Prepay Agreemnt Type
prepaymentagreementcategory PPMGAG_E_AGMNCAT Prepayment Category
prepaymentagreementstatus PPMGAG_E_AGMSTATUS Pre Agreement Status
prepaymentagrmtlinkstatus PPMGAG_E_LINKSTATUS Link Status
prepaymentagrmtpostingstatus PPMGAG_E_POSTSTATUS Pre Posting Status
prepaymentpostingprofile PPMGAG_E_POST_PR Settl Recvry Profile
prepaymentbarterlinkstatus PPMGAG_E_BRSTATUS Prepmt Barter Status
prepaymentagreementdescription PPMGAG_E_AGMDESCRIPTION Pre Agreement Desc.
counterparty PPMGAG_E_COUNTERPARTY Counterparty
prepaymentagrmtbptype PPMGAG_E_COUNTERPARTYTYPE Counterparty Type
companycode BUKRS Company Code
prepaymentagrmtcreditarea PPMGAG_E_CREDITAREA Credit Area
purchasinggroup EKGRP Purch. Group
purchasingorganization EKORG Purchasing Org.
salesorganization VKORG Sales Org.
distributionchannel VTWEG Distr. Channel
division SPART Division
plant WERKS_D Plant
prepaymentagrmtcropseason PPMGAG_E_CROPSEASON Crop Season
prepaymenteconomicgroup PPMGAG_E_ECONOMICGROUP Economic Group
prepaymentagreementamount PPMGAG_E_AGMAMT Pre Agrm Amount
prepaymentagreementcurrency PPMGAG_E_AGMCUR Currency
prepaymentagreementcommodity TBA_STOEFFCHEN Commodity
isarchived PPMGAG_E_ARCHIVE Archive Status
prepaymentagrmtduedate PPMGAG_E_DUEDATE Credit Due Date
prepaymentagreementrating PPMGAG_E_CREDITRATING Credit Rating
prepaymentleasedplantareaqty PPMGAG_E_LEASEDPLANTINGAREA Size-Leasd PlntgArea
prepaymentplantingareauom PPMGAG_E_PLANTINGAREAUOM Size of Leased Pl.Ar
prepaymentprodtvplantareaqty PPMGAG_E_PROTVPLANTINGAREA Prod Planting Area
prepaymentprodtvplantareauom PPMGAG_E_PRODTVPLANTAREAUOM Prod Plntng Area UoM
prepaymentownplantingareaqty PPMGAG_E_OWNPLANTINGAREA Own Planting Area
prepaymentownplantingareauom PPMGAG_E_OWNPLANTINGAREAUOM Planting Area UoM
prepaymentcredittotalareaqty PPMGAG_E_CREDITTOTALAREA Total Credit Area
prepaymentcredittotalareauom PPMGAG_E_CREDITTOTALAREAUOM Total Area UoM
prepaymentpledgedareaqty PPMGAG_E_PLEDGEDAREA Pledged Area
prepaymentpledgedareauom PPMGAG_E_PLEDGEDAREAUOM Pledged Area UoM
prepaymentpledgedprodtvareaqty PPMGAG_E_PLEDGEDPRODTVAREA Productive Area
prepaymentpledgedprodtvareauom PPMGAG_E_PLEDGEDPRODTVAREAUOM Productive Area UoM
prepaymentownpledgedareaqty PPMGAG_E_OWNPLEDGEDAREA Own Pledged Area
prepaymentownpledgedareauom PPMGAG_E_OWNPLEDGEDAREAUOM Own Pledged Area UoM
prepaymenttotalpledgedareaqty PPMGAG_E_TOTALPLEDGEDAREA Pledged Area
prepaymenttotalpledgedareauom PPMGAG_E_TOTALPLEDGEDAREAUOM Totl Pldged Area UoM
prepaymentcostperhectareamt PPMGAG_E_COSTPERHECTARE Cost Per Hectare
prepaymentcosthectarecurrency PPMGAG_E_COSTHECTARECURRENCY Cost/Hectare Currenc
prepaymentcostofpledgeamt PPMGAG_E_COSTOFPLEDGE Cost of Pledge
prepaymentcostofpledgecurrency PPMGAG_E_COSTOFPLEDGECURRENCY Cost of Pledge Curr.
prepaymentcredittotalcost PPMGAG_E_TOTALCOST Total Cost
prepaymenttotalcostcurrency PPMGAG_E_TOTALCOSTCURRENCY Total Cost Currency
prepaymentproductivityfctrqty PPMGAG_E_PRODUCTIVITYFCTR Productivity Factor
prepaymentproductivityfctruom PPMGAG_E_PRODUCTIVITYFCTRUOM Prodvty Factor UoM
prepaymentproductivefctrperuom PPMGAG_E_PRODPERUOM Prod. Factor UoM
prepaymentcreditregion PPMGAG_E_CREDITREGION Credit Region
prepaymentestimatedprodnqty PPMGAG_E_ESTIMATEDPRODN Estimated Production
prepaymentestimatedprodnuom PPMGAG_E_ESTIMATEDPRODNUOM Estimated Prod. UoM
prepaymentestimatedprodperuom PPMGAG_E_ESTPRODNPERUOM Est Prod Per UoM
prepaymentlimitcreditdate PPMGAG_E_LIMITDATEFORCREDIT Crdt Use Limit Date
prepaymentcmtmtpercent PPMGAG_E_PERCENTAGECMTMT % of Commitment
prepaymentpayoutpercent PPMGAG_E_PAYOUTPERCENTAGE Payout Percentage
prepaymentcreditcontractflag PPMGAG_E_CREDITCONTRACTFLAG Credit Contract
prepaymentstartintrstdatetype PPMGAG_E_STARTINTRSTDATETYPE Int. Start Date Type
prepaymentstartintrstdate PPMGAG_E_STARTINTRSTDATE Interest Start Date
prepaymentstopintrstdatetype PPMGAG_E_STOPINTRSTDATETYPE Int. Stop Date Type
prepaymentstopintrstdate PPMGAG_E_STOPINTRSTDATE Interest Stop Date
prepaymentrestrictionstxt PPMGAG_E_CREDITRESTRICTIONS Credit Restrictions
prepaymentcredithistorytxt PPMGAG_E_CREDITHISTORY Credit History
bptaxnumber BPTAXNUM Tax Number
addressnumber AD_ADDRNUM Address Number
prepaymentagrmtextcommenttext PPMGAG_E_INT_COMMENT Internal Comments
prepaymentagrmtintcommenttext PPMGAG_E_EXT_COMMENT External Comments
prepaymentapprovaldatetime PPMGAG_E_APP_DATETIME Prepmt Appr DateTime
countrycode LAND1 Country/Reg.
companyregion REGIO Region
customercitycode CITYC City Code
prepaymentagrmtrjcnreason PPMGAG_E_REJ_CODE Reason Code
prepaymentrejectiontext PPMGAG_E_REJ_COMMENT Rejection Comment
prepaymentagrmtsource PPMGAG_E_SOURCE PreAgmnt Source
prepaymentprincipalreduction PPMGAG_E_PRINCIPALREDUCTION Principal Reduction
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
ppmgag_dummy CFD_DUMMY Dummy
ppmgac_sur_dummy CFD_DUMMY Dummy
ppmgac_bp_dummy CFD_DUMMY Dummy
prepaymentrenegttnstopdate PPMGAG_E_REGSTOPINTRSTDATE Stop Interest Date
prepaymentisrenegotiated PPMGAG_E_RENEGAGMRENEGOTIATED PPA Renegotiated
prepaymentsuspendintrstfromdte PPMGAG_E_REGSUSPENDINTFROMDATE Susp. Interest From
prepaymentsuspendintrsttodte PPMGAG_E_REGSUSPENDINTTODATE Susp. Interest Until
prepaymentisrenegttnstopintrst PPMGAG_E_RENEGTTNSTOPINTRST Stop Interest Ind.
prepaymentagrmtsrceisrenegttn PPMGAG_E_RENEGAGMSOURCE Source Is Reneg.
prepaymentisrenegttncshsettlmt PPMGAG_E_RENEGCASHSETTLMTIND Reneg. Cash Stlmt
prepaymentagrmtisreopened PPMGAG_E_RENEGPPMTREOPENED PPA is Reopened

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.

-- Pepayment Agreement Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPMGAG_T_PPMT (
    MANDT,                           -- Client [MANDT]
    PREPAYMENTAGREEMENTUUID,         -- Key [/BOBF/UUID]
    PREPAYMENTAGREEMENT,             -- Prepayment Agreement [PPMGAC_E_AGMNT]
    PREPAYMENTAGREEMENTTYPE,         -- Prepay Agreemnt Type [PPMGAG_E_AGMNTYP]
    PREPAYMENTAGREEMENTCATEGORY,     -- Prepayment Category [PPMGAG_E_AGMNCAT]
    PREPAYMENTAGREEMENTSTATUS,       -- Pre Agreement Status [PPMGAG_E_AGMSTATUS]
    PREPAYMENTAGRMTLINKSTATUS,       -- Link Status [PPMGAG_E_LINKSTATUS]
    PREPAYMENTAGRMTPOSTINGSTATUS,    -- Pre Posting Status [PPMGAG_E_POSTSTATUS]
    PREPAYMENTPOSTINGPROFILE,        -- Settl Recvry Profile [PPMGAG_E_POST_PR]
    PREPAYMENTBARTERLINKSTATUS,      -- Prepmt Barter Status [PPMGAG_E_BRSTATUS]
    PREPAYMENTAGREEMENTDESCRIPTION,  -- Pre Agreement Desc. [PPMGAG_E_AGMDESCRIPTION]
    COUNTERPARTY,                    -- Counterparty [PPMGAG_E_COUNTERPARTY]
    PREPAYMENTAGRMTBPTYPE,           -- Counterparty Type [PPMGAG_E_COUNTERPARTYTYPE]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PREPAYMENTAGRMTCREDITAREA,       -- Credit Area [PPMGAG_E_CREDITAREA]
    PURCHASINGGROUP,                 -- Purch. Group [EKGRP]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [EKORG]
    SALESORGANIZATION,               -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [VTWEG]
    DIVISION,                        -- Division [SPART]
    PLANT,                           -- Plant [WERKS_D]
    PREPAYMENTAGRMTCROPSEASON,       -- Crop Season [PPMGAG_E_CROPSEASON]
    PREPAYMENTECONOMICGROUP,         -- Economic Group [PPMGAG_E_ECONOMICGROUP]
    PREPAYMENTAGREEMENTAMOUNT,       -- Pre Agrm Amount [PPMGAG_E_AGMAMT]
    PREPAYMENTAGREEMENTCURRENCY,     -- Currency [PPMGAG_E_AGMCUR]
    PREPAYMENTAGREEMENTCOMMODITY,    -- Commodity [TBA_STOEFFCHEN]
    ISARCHIVED,                      -- Archive Status [PPMGAG_E_ARCHIVE]
    PREPAYMENTAGRMTDUEDATE,          -- Credit Due Date [PPMGAG_E_DUEDATE]
    PREPAYMENTAGREEMENTRATING,       -- Credit Rating [PPMGAG_E_CREDITRATING]
    PREPAYMENTLEASEDPLANTAREAQTY,    -- Size-Leasd PlntgArea [PPMGAG_E_LEASEDPLANTINGAREA]
    PREPAYMENTPLANTINGAREAUOM,       -- Size of Leased Pl.Ar [PPMGAG_E_PLANTINGAREAUOM]
    PREPAYMENTPRODTVPLANTAREAQTY,    -- Prod Planting Area [PPMGAG_E_PROTVPLANTINGAREA]
    PREPAYMENTPRODTVPLANTAREAUOM,    -- Prod Plntng Area UoM [PPMGAG_E_PRODTVPLANTAREAUOM]
    PREPAYMENTOWNPLANTINGAREAQTY,    -- Own Planting Area [PPMGAG_E_OWNPLANTINGAREA]
    PREPAYMENTOWNPLANTINGAREAUOM,    -- Planting Area UoM [PPMGAG_E_OWNPLANTINGAREAUOM]
    PREPAYMENTCREDITTOTALAREAQTY,    -- Total Credit Area [PPMGAG_E_CREDITTOTALAREA]
    PREPAYMENTCREDITTOTALAREAUOM,    -- Total Area UoM [PPMGAG_E_CREDITTOTALAREAUOM]
    PREPAYMENTPLEDGEDAREAQTY,        -- Pledged Area [PPMGAG_E_PLEDGEDAREA]
    PREPAYMENTPLEDGEDAREAUOM,        -- Pledged Area UoM [PPMGAG_E_PLEDGEDAREAUOM]
    PREPAYMENTPLEDGEDPRODTVAREAQTY,  -- Productive Area [PPMGAG_E_PLEDGEDPRODTVAREA]
    PREPAYMENTPLEDGEDPRODTVAREAUOM,  -- Productive Area UoM [PPMGAG_E_PLEDGEDPRODTVAREAUOM]
    PREPAYMENTOWNPLEDGEDAREAQTY,     -- Own Pledged Area [PPMGAG_E_OWNPLEDGEDAREA]
    PREPAYMENTOWNPLEDGEDAREAUOM,     -- Own Pledged Area UoM [PPMGAG_E_OWNPLEDGEDAREAUOM]
    PREPAYMENTTOTALPLEDGEDAREAQTY,   -- Pledged Area [PPMGAG_E_TOTALPLEDGEDAREA]
    PREPAYMENTTOTALPLEDGEDAREAUOM,   -- Totl Pldged Area UoM [PPMGAG_E_TOTALPLEDGEDAREAUOM]
    PREPAYMENTCOSTPERHECTAREAMT,     -- Cost Per Hectare [PPMGAG_E_COSTPERHECTARE]
    PREPAYMENTCOSTHECTARECURRENCY,   -- Cost/Hectare Currenc [PPMGAG_E_COSTHECTARECURRENCY]
    PREPAYMENTCOSTOFPLEDGEAMT,       -- Cost of Pledge [PPMGAG_E_COSTOFPLEDGE]
    PREPAYMENTCOSTOFPLEDGECURRENCY,  -- Cost of Pledge Curr. [PPMGAG_E_COSTOFPLEDGECURRENCY]
    PREPAYMENTCREDITTOTALCOST,       -- Total Cost [PPMGAG_E_TOTALCOST]
    PREPAYMENTTOTALCOSTCURRENCY,     -- Total Cost Currency [PPMGAG_E_TOTALCOSTCURRENCY]
    PREPAYMENTPRODUCTIVITYFCTRQTY,   -- Productivity Factor [PPMGAG_E_PRODUCTIVITYFCTR]
    PREPAYMENTPRODUCTIVITYFCTRUOM,   -- Prodvty Factor UoM [PPMGAG_E_PRODUCTIVITYFCTRUOM]
    PREPAYMENTPRODUCTIVEFCTRPERUOM,  -- Prod. Factor UoM [PPMGAG_E_PRODPERUOM]
    PREPAYMENTCREDITREGION,          -- Credit Region [PPMGAG_E_CREDITREGION]
    PREPAYMENTESTIMATEDPRODNQTY,     -- Estimated Production [PPMGAG_E_ESTIMATEDPRODN]
    PREPAYMENTESTIMATEDPRODNUOM,     -- Estimated Prod. UoM [PPMGAG_E_ESTIMATEDPRODNUOM]
    PREPAYMENTESTIMATEDPRODPERUOM,   -- Est Prod Per UoM [PPMGAG_E_ESTPRODNPERUOM]
    PREPAYMENTLIMITCREDITDATE,       -- Crdt Use Limit Date [PPMGAG_E_LIMITDATEFORCREDIT]
    PREPAYMENTCMTMTPERCENT,          -- % of Commitment [PPMGAG_E_PERCENTAGECMTMT]
    PREPAYMENTPAYOUTPERCENT,         -- Payout Percentage [PPMGAG_E_PAYOUTPERCENTAGE]
    PREPAYMENTCREDITCONTRACTFLAG,    -- Credit Contract [PPMGAG_E_CREDITCONTRACTFLAG]
    PREPAYMENTSTARTINTRSTDATETYPE,   -- Int. Start Date Type [PPMGAG_E_STARTINTRSTDATETYPE]
    PREPAYMENTSTARTINTRSTDATE,       -- Interest Start Date [PPMGAG_E_STARTINTRSTDATE]
    PREPAYMENTSTOPINTRSTDATETYPE,    -- Int. Stop Date Type [PPMGAG_E_STOPINTRSTDATETYPE]
    PREPAYMENTSTOPINTRSTDATE,        -- Interest Stop Date [PPMGAG_E_STOPINTRSTDATE]
    PREPAYMENTRESTRICTIONSTXT,       -- Credit Restrictions [PPMGAG_E_CREDITRESTRICTIONS]
    PREPAYMENTCREDITHISTORYTXT,      -- Credit History [PPMGAG_E_CREDITHISTORY]
    BPTAXNUMBER,                     -- Tax Number [BPTAXNUM]
    ADDRESSNUMBER,                   -- Address Number [AD_ADDRNUM]
    PREPAYMENTAGRMTEXTCOMMENTTEXT,   -- Internal Comments [PPMGAG_E_INT_COMMENT]
    PREPAYMENTAGRMTINTCOMMENTTEXT,   -- External Comments [PPMGAG_E_EXT_COMMENT]
    PREPAYMENTAPPROVALDATETIME,      -- Prepmt Appr DateTime [PPMGAG_E_APP_DATETIME]
    COUNTRYCODE,                     -- Country/Reg. [LAND1]
    COMPANYREGION,                   -- Region [REGIO]
    CUSTOMERCITYCODE,                -- City Code [CITYC]
    PREPAYMENTAGRMTRJCNREASON,       -- Reason Code [PPMGAG_E_REJ_CODE]
    PREPAYMENTREJECTIONTEXT,         -- Rejection Comment [PPMGAG_E_REJ_COMMENT]
    PREPAYMENTAGRMTSOURCE,           -- PreAgmnt Source [PPMGAG_E_SOURCE]
    PREPAYMENTPRINCIPALREDUCTION,    -- Principal Reduction [PPMGAG_E_PRINCIPALREDUCTION]
    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]
    PPMGAG_DUMMY,                    -- Dummy [CFD_DUMMY]
    PPMGAC_SUR_DUMMY,                -- Dummy [CFD_DUMMY]
    PPMGAC_BP_DUMMY,                 -- Dummy [CFD_DUMMY]
    PREPAYMENTRENEGTTNSTOPDATE,      -- Stop Interest Date [PPMGAG_E_REGSTOPINTRSTDATE]
    PREPAYMENTISRENEGOTIATED,        -- PPA Renegotiated [PPMGAG_E_RENEGAGMRENEGOTIATED]
    PREPAYMENTSUSPENDINTRSTFROMDTE,  -- Susp. Interest From [PPMGAG_E_REGSUSPENDINTFROMDATE]
    PREPAYMENTSUSPENDINTRSTTODTE,    -- Susp. Interest Until [PPMGAG_E_REGSUSPENDINTTODATE]
    PREPAYMENTISRENEGTTNSTOPINTRST,  -- Stop Interest Ind. [PPMGAG_E_RENEGTTNSTOPINTRST]
    PREPAYMENTAGRMTSRCEISRENEGTTN,   -- Source Is Reneg. [PPMGAG_E_RENEGAGMSOURCE]
    PREPAYMENTISRENEGTTNCSHSETTLMT,  -- Reneg. Cash Stlmt [PPMGAG_E_RENEGCASHSETTLMTIND]
    PREPAYMENTAGRMTISREOPENED,       -- PPA is Reopened [PPMGAG_E_RENEGPPMTREOPENED]
    PRIMARY KEY (MANDT, PREPAYMENTAGREEMENTUUID)
);

Learn More