PPMGAG_T_COLLTRL

Prepayment Agreement Collateral Information | #transactional | Component: Prepayment agreements
Column Name Description
MANDT FK Client
PREPAYMENTAGRMTCOLLTRLUUID UUID serving as key (parent key, root key)
Column Name Description
💲 Prepayment Collateral Plant Area Currency (PREPAYMENTCOLLTRLPLNTAREACRCY):
PREPAYMENTCOLLTRLPLNTAREAAMT Prepayment Collateral Plant Area Amount
💲 Prepayment Collateral Cattle Currency (PREPAYMENTCOLLTRLCATTLECRCY):
PREPAYMENTCOLLTRLCATTLEAREAAMT Prepayment Collateral Cattle Area Amount
💲 Prepayment Collateral Closed Area Currency (PREPAYMENTCOLLTRLCLSDAREACRCY):
PREPAYMENTCOLLTRLCLSDAREAAMT Prepayment Collateral Closed Area Amount
💲 Prepayment Collateral Environmental Reserve Area Currency (PREPAYMENTCOLLTRLENVRMTCRCY):
PREPAYMENTCOLLTRLENVRMTAREAAMT Prepayment Collateral Environmental Reserve Area Amount
💲 Prepayment Collateral Investment Amount Currency (PREPAYMENTCOLLTRLINVMTAMTCRCY):
PREPAYMENTCOLLTRLINVMTAMT Prepayment Collateral Investment Amount
💲 Prepayment Collateral Rotate Amount Currency (PREPAYMENTCOLLTRLROTATEAMTCRCY):
PREPAYMENTCOLLTRLROTATEAREAAMT Prepayment Collateral Rotate Area Amount
💲 Prepayment Collateral Total Amount Currency (PREPAYMENTCOLLTRLTOTAMTCRCY):
PREPAYMENTCOLLTRLTOTAMT Prepayment Collateral Total Amount
💲 Prepayment Collateral Venal Value Currency (PREPAYMENTCOLLTRLVENALVALCRCY):
PREPAYMENTCOLLTRLVENALVALAMT Prepayment Collateral Venal Value
💲 Prepayment Mortgage Committed Amount Currency (PREPAYMENTMORTGAGECMTDAMTCRCY):
PREPAYMENTMORTGAGECMTDAMT Prepayment Mortgage Committed Amount
Column Name Description
📏 Prepayment Collateral Land Area Unit of Measure (PREPAYMENTCOLLTRLLANDAREAUOM):
PREPAYMENTCOLLTRLLANDAREAQTY Prepayment Collateral Land Area
📏 Prepayment Collateral Total Property Unit of Measure (PREPAYMENTCOLLTRLTOTPRPTYUOM):
PREPAYMENTCOLLTRLTOTPRPTYQTY Prepayment Collateral Total Property Size
📏 Prepayment Collateral Area Unit of Measure (PREPAYMENTCOLLTRLAREAUOM):
PREPAYMENTCOLLTRLAREAQTY Prepayment Collateral Area Size
📏 Prepayment Collateral Productive Size Unit of Measure (PREPAYMENTCOLLTRLPRODTVAREAUOM):
PREPAYMENTCOLLTRLPRODTVQTY Prepayment Collateral Pawned Area Productive Size
📏 Prepayment Collateral Plant Area Unit of Measure (PREPAYMENTCOLLTRLPLNTAREAUOM):
PREPAYMENTCOLLTRLPLNTAREAQTY Prepayment Collateral Plant Area Size
📏 Prepayment Collateral Cattle Area Unit of Measure (PREPAYMENTCOLLTRLCATTLEAREAUOM):
PREPAYMENTCOLLTRLCATTLEAREAQTY Prepayment Collateral Cattle Area
📏 Prepayment Collateral Closed Area Unit of Measure (PREPAYMENTCOLLTRLCLSDAREAUOM):
PREPAYMENTCOLLTRLCLSDAREAQTY Prepayment Collateral Closed Area Size
📏 Prepayment Collateral Environmental Reserve Area UoM (PREPAYMENTCOLLTRLENVRMTAREAUOM):
PREPAYMENTCOLLTRLENVRMTAREAQTY Prepayment Collateral Environmental Reserve Area
📏 Prepayment Collateral Avg Production of Pawned Area - UoM (PREPAYMENTCOLLTRLAVGPRODNUOM):
PREPAYMENTCOLLTRLAVGPRODNQTY Prepayment Collateral Average Production of Pawned Area
📏 Prepayment Collateral Committed Quantity Unit of Measure (PREPAYMENTCOLLTRLCMTDQTYUOM):
PREPAYMENTCOLLTRLCMTDQTY Prepayment Collateral Committed Quantity
Column Name Description
PREPAYMENTCOLLTRLROTATEDUDTE Prepayment Collateral Rotate Due Date
PREPAYMENTCOLLTRLAPPRAISALDTE Prepayment Collateral Appraisal Date
PREPAYMENTCOLLTRLDUDTE Prepayment Collateral Due Date
Column Name Description
PREPAYMENTCOLLTRLISRCVD Prepayment Collateral Received Show values
PREPAYMENTCOLLTRLISSETTLMTRQD Prepayment Collateral Required for Settlement Show values
Column Name Description Domain name
PREPAYMENTAGREEMENTUUID UUID serving as key (parent key, root key) SYSUUID
PREPAYMENTCOLLTRLSUBTYPE Prepayment Collateral Sub Types PPMGAG_D_COLL_SUBTYPE
PREPAYMENTCOLLTRLCODE Prepayment Collateral Code - Obsolete PPMGAG_D_COLLTRLCODE
PREPAYMENTCOLLTRLINVMTTEXT Prepayment Collateral Investment TEXT100
PREPAYMENTCOLLTRLCITYCODE City Code CITYC
PREPAYMENTCOLLTRLBNFCYNAME Prepayment Collateral Beneficiary TEXT100
PREPAYMENTCOLLTRLSITN Prepayment Collateral Situation PPMGAG_D_COLLTRLSITN
PREPAYMENTCOLLTRLDEGTEXT Prepayment Collateral Degree TEXT100
PREPAYMENTCOLLTRLREGNMBRTEXT Prepayment Collateral Register Number TEXT100
PREPAYMENTCOLLTRLTXCODEJX Prepayment Collateral Tax Code Jurisdiction TXJCD
PREPAYMENTCOLLTRLRESPNAME Prepayment Collateral Appraisal Responsible TEXT100
PREPAYMENTCOLLTRLSTMNTTEXT Prepayment Collateral Trader Statement TEXT255
PREPAYMENTCOLLTRLDESC Prepayment Collateral Description TEXT255
PREPAYMENTCOLLTRLOBSVNTEXT Prepayment Collateral Observations TEXT255
CREATEDBYUSER Created By USNAM
CREATIONDATETIME Timestamp of Record Creation TZNTSTMPS
LASTCHANGEDBYUSER Last Changed By (User ID) USNAM
LASTCHANGEDATETIME Timestamp of Last Change TZNTSTMPS
PPMGAG_DUMMY Custom Fields: Dummy for Use in Extension Includes
PPMGAC_SUR_DUMMY Custom Fields: Dummy for Use in Extension Includes
PPMGAC_BP_DUMMY Custom Fields: Dummy for Use in Extension Includes
PPMGAG_COLLTRL_DUMMY Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • PPMGAG_T_COLLTRL.MANDT == T005S.MANDT
  • PPMGAG_T_COLLTRL.COUNTRYCODE == T005S.LAND1
  • PPMGAG_T_COLLTRL.COMPANYREGION == T005S.BLAND
Country/Region Key
  • Country/Region Key
  • Client
  • PPMGAG_T_COLLTRL.COUNTRYCODE == T005.LAND1
  • PPMGAG_T_COLLTRL.MANDT == T005.MANDT
Client PPMGAG_T_COLLTRL.MANDT == T000.MANDT
Prepayment Collateral Area Unit of Measure
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLAREAUOM == T006.MSEHI
Prepayment Collateral Avg Production of Pawned Area - UoM
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLAVGPRODNUOM == T006.MSEHI
Prepayment Collateral Cattle Area Unit of Measure
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLCATTLEAREAUOM == T006.MSEHI
Prepayment Collateral Closed Area Unit of Measure
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLCLSDAREAUOM == T006.MSEHI
Prepayment Collateral Environmental Reserve Area UoM
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLENVRMTAREAUOM == T006.MSEHI
Prepayment Collateral Land Area Unit of Measure
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLLANDAREAUOM == T006.MSEHI
Prepayment Collateral Plant Area Currency
  • PPMGAG_T_COLLTRL.MANDT == TCURC.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLPLNTAREACRCY == TCURC.WAERS
Prepayment Collateral Plant Area Unit of Measure
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLPLNTAREAUOM == T006.MSEHI
Prepayment Collateral Productive Size Unit of Measure
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLPRODTVAREAUOM == T006.MSEHI
Prepayment Collateral Total Property Unit of Measure
  • PPMGAG_T_COLLTRL.MANDT == T006.MANDT
  • PPMGAG_T_COLLTRL.PREPAYMENTCOLLTRLTOTPRPTYUOM == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Collateral Types
  • Collateral Types
  • ?