PPMGAG_T_COLLTRL
Prepayment Agreement Collateral Information
PPMGAG_T_COLLTRL is an SAP database table in S/4HANA. Prepayment Agreement Collateral Information. It contains 71 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PrepaymentAgrmtCollateral | view | from | EXTENSION | Extension View for Collateral |
| I_PrepaymentAgrmtCollateral | view | from | BASIC | Prepayment Aggrement Collateral |
Fields (71)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | prepaymentagrmtcolltrluuid | /BOBF/UUID | Key | |||
| prepaymentagreementuuid | /BOBF/UUID | Key | ||||
| prepaymentcolltrltype | PPMGAG_E_COLL_TYPE | Collateral Types | ||||
| prepaymentcolltrlsubtype | PPMGAG_E_COLL_SUBTYPE | Collateral Sub Types | ||||
| prepaymentcolltrlcode | PPMGAG_E_COLLTRLCODE | Collateral Code | ||||
| prepaymentcolltrlisrcvd | PPMGAG_E_COLLTRLRCVD | Collateral Received | ||||
| prepaymentcolltrlissettlmtrqd | PPMGAG_E_COLLTRLRQDFORSETTLMT | Coll Rqd For Settlmt | ||||
| prepaymentcolltrllandareaqty | PPMGAG_E_COLLTRLLANDAREA | Collateral Land Area | ||||
| prepaymentcolltrllandareauom | PPMGAG_E_COLLTRLLANDAREAUOM | Land Area UoM | ||||
| prepaymentcolltrltotprptyqty | PPMGAG_E_COLLTRLTOTPRPTYSIZE | Tot Prpty Size | ||||
| prepaymentcolltrltotprptyuom | PPMGAG_E_COLLTRLTOTPRPTYUOM | Tot Prpty UoM | ||||
| prepaymentcolltrlareaqty | PPMGAG_E_COLLTRLAREASIZE | Colltrl Area Size | ||||
| prepaymentcolltrlareauom | PPMGAG_E_COLLTRLAREAUOM | Colltrl Area UoM | ||||
| prepaymentcolltrlprodtvqty | PPMGAG_E_COLLTRLPRODTVSIZE | Colltrl Prodtv Size | ||||
| prepaymentcolltrlprodtvareauom | PPMGAG_E_COLLTRLPRODTVSIZEUOM | Prodtv Size UoM | ||||
| prepaymentcolltrlplntareaqty | PPMGAG_E_COLLTRLPLNTAREASIZE | Plant Area Size | ||||
| prepaymentcolltrlplntareauom | PPMGAG_E_COLLTRLPLNTAREAUOM | Plant Area UoM | ||||
| prepaymentcolltrlplntareaamt | PPMGAG_E_COLLTRLPLNTAREAAMT | Plnt Area Amt | ||||
| prepaymentcolltrlplntareacrcy | PPMGAG_E_COLLTRLPLNTAREACRCY | Plnt Area Curr. | ||||
| prepaymentcolltrlcattleareaqty | PPMGAG_E_COLLTRLCATTLEAREA | Cattle Area | ||||
| prepaymentcolltrlcattleareauom | PPMGAG_E_COLLTRLCATTLEAREAUOM | Cattle Area UoM | ||||
| prepaymentcolltrlcattleareaamt | PPMGAG_E_COLLTRLCATTLEAREAAMT | Cattle Area Amt | ||||
| prepaymentcolltrlcattlecrcy | PPMGAG_E_COLLTRLCATTLECRCY | Coll. Cattle Curr. | ||||
| prepaymentcolltrlclsdareaqty | PPMGAG_E_COLLTRLCLSDAREASIZE | Clsd Area Size | ||||
| prepaymentcolltrlclsdareauom | PPMGAG_E_COLLTRLCLSDAREAUOM | Clsd Area UoM | ||||
| prepaymentcolltrlclsdareaamt | PPMGAG_E_COLLTRLCLSDAREAAMT | Clsd Area Amt | ||||
| prepaymentcolltrlclsdareacrcy | PPMGAG_E_COLLTRLCLSDAREACRCY | Clsd Area Curr. | ||||
| prepaymentcolltrlenvrmtareaqty | PPMGAG_E_COLLTRLENVRMTAREA | Envrmt Area | ||||
| prepaymentcolltrlenvrmtareauom | PPMGAG_E_COLLTRLENVRMTAREAUOM | Envrmt Area UoM | ||||
| prepaymentcolltrlenvrmtareaamt | PPMGAG_E_COLLTRLENVRMTAREAAMT | Envrmt Area Amt | ||||
| prepaymentcolltrlenvrmtcrcy | PPMGAG_E_COLLTRLENVRMTCRCY | Colltrl Envrmt Curr. | ||||
| prepaymentcolltrlinvmttext | PPMGAG_E_COLLTRLINVMT | Collateral Investmnt | ||||
| prepaymentcolltrlinvmtamt | PPMGAG_E_COLLTRLINVMTAMT | Investment Amount | ||||
| prepaymentcolltrlinvmtamtcrcy | PPMGAG_E_COLLTRLINVMTAMTCRCY | Invmt Amt Crcy | ||||
| prepaymentcolltrlrotateareaamt | PPMGAG_E_COLLTRLROTATEAREAAMT | Rotate Area Amt | ||||
| prepaymentcolltrlrotateamtcrcy | PPMGAG_E_COLLTRLROTATEAMTCRCY | Rotate Amt Curr. | ||||
| prepaymentcolltrlrotatedudte | PPMGAG_E_COLLTRLROTATEDUDTE | Rotate Due Date | ||||
| prepaymentcolltrltotamt | PPMGAG_E_COLLTRLTOTAMT | Coll Total Amount | ||||
| prepaymentcolltrltotamtcrcy | PPMGAG_E_COLLTRLTOTAMTCRCY | Tot Amt Curr. | ||||
| prepaymentcolltrlcitycode | CITYC | City Code | ||||
| prepaymentcolltrlbnfcyname | PPMGAG_E_COLLTRLBNFCY | Colltrl Beneficiary | ||||
| prepaymentcolltrlsitn | PPMGAG_E_COLLTRLSITN | Collateral Situation | ||||
| prepaymentcolltrldegtext | PPMGAG_E_COLLTRLDEG | Collateral Degree | ||||
| prepaymentcolltrlavgprodnqty | PPMGAG_E_COLLTRLAVGPRODN | Avg Prodn Pawned Are | ||||
| prepaymentcolltrlprodnwgtuom | PPMGAG_E_COLLTRLAVGPRODNUOM | Avg Prodn UoM | ||||
| prepaymentcolltrlavgprodnuom | PPMGAG_E_COLLTRLAVGPRODNUOM | Avg Prodn UoM | ||||
| prepaymentcolltrlcmtdqty | PPMGAG_E_COLLTRLCMTDQTY | Committed Quantity | ||||
| prepaymentcolltrlcmtdqtyuom | PPMGAG_E_COLLTRLCMTDQTYUOM | Cmtd Qty UoM | ||||
| prepaymentcolltrlregnmbrtext | PPMGAG_E_COLLTRLREGNMBR | Register Number | ||||
| prepaymentcolltrltxcodejx | PPMGAG_E_COLLTRLTXCODEJX | TaxCode Jurisdiction | ||||
| prepaymentcolltrlrespname | PPMGAG_E_COLLTRLAPPRAISALRESP | Appraisal Respnsble | ||||
| prepaymentcolltrlappraisaldte | PPMGAG_E_COLLTRLAPPRAISALDTE | Coll. Apprsl Date | ||||
| prepaymentcolltrldudte | PPMGAG_E_COLLTRLDUDTE | Collateral Due Date | ||||
| prepaymentcolltrlvenalvalamt | PPMGAG_E_COLLTRLVENALVAL | Coll Venal Value | ||||
| prepaymentcolltrlvenalvalcrcy | PPMGAG_E_COLLTRLVENALVALCRCY | Venal Val Curr. | ||||
| prepaymentcolltrlstmnttext | PPMGAG_E_COLLTRLTRADERSTMNT | Coll Trader Statmnt | ||||
| prepaymentcolltrldesc | PPMGAG_E_COLLTRLDESC | Collateral Desc. | ||||
| prepaymentmortgagecmtdamt | PPMGAG_E_MORTGAGECMTDAMT | Mortgage Commitd Amt | ||||
| prepaymentmortgagecmtdamtcrcy | PPMGAG_E_MORTGAGECMTDAMTCRCY | Mortg Comm Amt Curr | ||||
| prepaymentcolltrlobsvntext | PPMGAG_E_COLLTRLOBSERVATIONS | Colltrl Observations | ||||
| countrycode | LAND1 | Country/Reg. | ||||
| companyregion | REGIO | Region | ||||
| 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 | ||||
| ppmgag_colltrl_dummy | CFD_DUMMY | Dummy |
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 Agreement Collateral Information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPMGAG_T_COLLTRL (
MANDT, -- Client [MANDT]
PREPAYMENTAGRMTCOLLTRLUUID, -- Key [/BOBF/UUID]
PREPAYMENTAGREEMENTUUID, -- Key [/BOBF/UUID]
PREPAYMENTCOLLTRLTYPE, -- Collateral Types [PPMGAG_E_COLL_TYPE]
PREPAYMENTCOLLTRLSUBTYPE, -- Collateral Sub Types [PPMGAG_E_COLL_SUBTYPE]
PREPAYMENTCOLLTRLCODE, -- Collateral Code [PPMGAG_E_COLLTRLCODE]
PREPAYMENTCOLLTRLISRCVD, -- Collateral Received [PPMGAG_E_COLLTRLRCVD]
PREPAYMENTCOLLTRLISSETTLMTRQD, -- Coll Rqd For Settlmt [PPMGAG_E_COLLTRLRQDFORSETTLMT]
PREPAYMENTCOLLTRLLANDAREAQTY, -- Collateral Land Area [PPMGAG_E_COLLTRLLANDAREA]
PREPAYMENTCOLLTRLLANDAREAUOM, -- Land Area UoM [PPMGAG_E_COLLTRLLANDAREAUOM]
PREPAYMENTCOLLTRLTOTPRPTYQTY, -- Tot Prpty Size [PPMGAG_E_COLLTRLTOTPRPTYSIZE]
PREPAYMENTCOLLTRLTOTPRPTYUOM, -- Tot Prpty UoM [PPMGAG_E_COLLTRLTOTPRPTYUOM]
PREPAYMENTCOLLTRLAREAQTY, -- Colltrl Area Size [PPMGAG_E_COLLTRLAREASIZE]
PREPAYMENTCOLLTRLAREAUOM, -- Colltrl Area UoM [PPMGAG_E_COLLTRLAREAUOM]
PREPAYMENTCOLLTRLPRODTVQTY, -- Colltrl Prodtv Size [PPMGAG_E_COLLTRLPRODTVSIZE]
PREPAYMENTCOLLTRLPRODTVAREAUOM, -- Prodtv Size UoM [PPMGAG_E_COLLTRLPRODTVSIZEUOM]
PREPAYMENTCOLLTRLPLNTAREAQTY, -- Plant Area Size [PPMGAG_E_COLLTRLPLNTAREASIZE]
PREPAYMENTCOLLTRLPLNTAREAUOM, -- Plant Area UoM [PPMGAG_E_COLLTRLPLNTAREAUOM]
PREPAYMENTCOLLTRLPLNTAREAAMT, -- Plnt Area Amt [PPMGAG_E_COLLTRLPLNTAREAAMT]
PREPAYMENTCOLLTRLPLNTAREACRCY, -- Plnt Area Curr. [PPMGAG_E_COLLTRLPLNTAREACRCY]
PREPAYMENTCOLLTRLCATTLEAREAQTY, -- Cattle Area [PPMGAG_E_COLLTRLCATTLEAREA]
PREPAYMENTCOLLTRLCATTLEAREAUOM, -- Cattle Area UoM [PPMGAG_E_COLLTRLCATTLEAREAUOM]
PREPAYMENTCOLLTRLCATTLEAREAAMT, -- Cattle Area Amt [PPMGAG_E_COLLTRLCATTLEAREAAMT]
PREPAYMENTCOLLTRLCATTLECRCY, -- Coll. Cattle Curr. [PPMGAG_E_COLLTRLCATTLECRCY]
PREPAYMENTCOLLTRLCLSDAREAQTY, -- Clsd Area Size [PPMGAG_E_COLLTRLCLSDAREASIZE]
PREPAYMENTCOLLTRLCLSDAREAUOM, -- Clsd Area UoM [PPMGAG_E_COLLTRLCLSDAREAUOM]
PREPAYMENTCOLLTRLCLSDAREAAMT, -- Clsd Area Amt [PPMGAG_E_COLLTRLCLSDAREAAMT]
PREPAYMENTCOLLTRLCLSDAREACRCY, -- Clsd Area Curr. [PPMGAG_E_COLLTRLCLSDAREACRCY]
PREPAYMENTCOLLTRLENVRMTAREAQTY, -- Envrmt Area [PPMGAG_E_COLLTRLENVRMTAREA]
PREPAYMENTCOLLTRLENVRMTAREAUOM, -- Envrmt Area UoM [PPMGAG_E_COLLTRLENVRMTAREAUOM]
PREPAYMENTCOLLTRLENVRMTAREAAMT, -- Envrmt Area Amt [PPMGAG_E_COLLTRLENVRMTAREAAMT]
PREPAYMENTCOLLTRLENVRMTCRCY, -- Colltrl Envrmt Curr. [PPMGAG_E_COLLTRLENVRMTCRCY]
PREPAYMENTCOLLTRLINVMTTEXT, -- Collateral Investmnt [PPMGAG_E_COLLTRLINVMT]
PREPAYMENTCOLLTRLINVMTAMT, -- Investment Amount [PPMGAG_E_COLLTRLINVMTAMT]
PREPAYMENTCOLLTRLINVMTAMTCRCY, -- Invmt Amt Crcy [PPMGAG_E_COLLTRLINVMTAMTCRCY]
PREPAYMENTCOLLTRLROTATEAREAAMT, -- Rotate Area Amt [PPMGAG_E_COLLTRLROTATEAREAAMT]
PREPAYMENTCOLLTRLROTATEAMTCRCY, -- Rotate Amt Curr. [PPMGAG_E_COLLTRLROTATEAMTCRCY]
PREPAYMENTCOLLTRLROTATEDUDTE, -- Rotate Due Date [PPMGAG_E_COLLTRLROTATEDUDTE]
PREPAYMENTCOLLTRLTOTAMT, -- Coll Total Amount [PPMGAG_E_COLLTRLTOTAMT]
PREPAYMENTCOLLTRLTOTAMTCRCY, -- Tot Amt Curr. [PPMGAG_E_COLLTRLTOTAMTCRCY]
PREPAYMENTCOLLTRLCITYCODE, -- City Code [CITYC]
PREPAYMENTCOLLTRLBNFCYNAME, -- Colltrl Beneficiary [PPMGAG_E_COLLTRLBNFCY]
PREPAYMENTCOLLTRLSITN, -- Collateral Situation [PPMGAG_E_COLLTRLSITN]
PREPAYMENTCOLLTRLDEGTEXT, -- Collateral Degree [PPMGAG_E_COLLTRLDEG]
PREPAYMENTCOLLTRLAVGPRODNQTY, -- Avg Prodn Pawned Are [PPMGAG_E_COLLTRLAVGPRODN]
PREPAYMENTCOLLTRLPRODNWGTUOM, -- Avg Prodn UoM [PPMGAG_E_COLLTRLAVGPRODNUOM]
PREPAYMENTCOLLTRLAVGPRODNUOM, -- Avg Prodn UoM [PPMGAG_E_COLLTRLAVGPRODNUOM]
PREPAYMENTCOLLTRLCMTDQTY, -- Committed Quantity [PPMGAG_E_COLLTRLCMTDQTY]
PREPAYMENTCOLLTRLCMTDQTYUOM, -- Cmtd Qty UoM [PPMGAG_E_COLLTRLCMTDQTYUOM]
PREPAYMENTCOLLTRLREGNMBRTEXT, -- Register Number [PPMGAG_E_COLLTRLREGNMBR]
PREPAYMENTCOLLTRLTXCODEJX, -- TaxCode Jurisdiction [PPMGAG_E_COLLTRLTXCODEJX]
PREPAYMENTCOLLTRLRESPNAME, -- Appraisal Respnsble [PPMGAG_E_COLLTRLAPPRAISALRESP]
PREPAYMENTCOLLTRLAPPRAISALDTE, -- Coll. Apprsl Date [PPMGAG_E_COLLTRLAPPRAISALDTE]
PREPAYMENTCOLLTRLDUDTE, -- Collateral Due Date [PPMGAG_E_COLLTRLDUDTE]
PREPAYMENTCOLLTRLVENALVALAMT, -- Coll Venal Value [PPMGAG_E_COLLTRLVENALVAL]
PREPAYMENTCOLLTRLVENALVALCRCY, -- Venal Val Curr. [PPMGAG_E_COLLTRLVENALVALCRCY]
PREPAYMENTCOLLTRLSTMNTTEXT, -- Coll Trader Statmnt [PPMGAG_E_COLLTRLTRADERSTMNT]
PREPAYMENTCOLLTRLDESC, -- Collateral Desc. [PPMGAG_E_COLLTRLDESC]
PREPAYMENTMORTGAGECMTDAMT, -- Mortgage Commitd Amt [PPMGAG_E_MORTGAGECMTDAMT]
PREPAYMENTMORTGAGECMTDAMTCRCY, -- Mortg Comm Amt Curr [PPMGAG_E_MORTGAGECMTDAMTCRCY]
PREPAYMENTCOLLTRLOBSVNTEXT, -- Colltrl Observations [PPMGAG_E_COLLTRLOBSERVATIONS]
COUNTRYCODE, -- Country/Reg. [LAND1]
COMPANYREGION, -- Region [REGIO]
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]
PPMGAG_COLLTRL_DUMMY, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, PREPAYMENTAGRMTCOLLTRLUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA