I_PrepaymentAgreement

Prepayment Agreement Interface View | view: IPPMGAGREEMENT | TRAN | Extraction: Not supported | Component: Prepayment agreements
Tables used: PPMGAG_T_PPMT
Column Name Description
PrepaymentAgreementUUID UUID serving as key (parent key, root key)
Column Name Description
💲 Prepayment Agreement Currency (PrepaymentAgreementCurrency):
PrepaymentAgreementAmount Prepayment Agreement Amount
💲 Prepayment Agreement Cost Per Hectare Currency (PrepaymentCostHectareCurrency):
PrepaymentCostPerHectareAmt Prepayment Agreement Cost Per Hectare
💲 Prepayment Agreement Cost of Pledge Currency (PrepaymentCostOfPledgeCurrency):
PrepaymentCostOfPledgeAmt Prepayment Agreement Cost of Pledge
💲 Prepayment Credit Total Cost Currency (PrepaymentTotalCostCurrency):
PrepaymentCreditTotalCost Prepayment Agreement Total Cost
Column Name Description
📏 Prepayment Agreement Size of Leased Planting Area UoM (PrepaymentPlantingAreaUoM):
PrepaymentLeasedPlantAreaQty Prepayment Agreement Size of Leased Planting Area
📏 Prepayment Agreement Productive Planting Area UoM (PrepaymentProdtvPlantAreaUoM):
PrepaymentProdtvPlantAreaQty Prepayment Agreement Size of Productive Planting Area
📏 Prepayment Agreement Own Planting Area UoM (PrepaymentOwnPlantingAreaUoM):
PrepaymentOwnPlantingAreaQty Prepayment Agreement Size of Own Planting Area
📏 Prepayment Agreement Total Area Unit of Measure (PrepaymentCreditTotalAreaUoM):
PrepaymentCreditTotalAreaQty Prepayment Agreement Total Credit Area
📏 Prepayment Agreement Size of Pledged Area UoM (PrepaymentPledgedAreaUoM):
PrepaymentPledgedAreaQty Prepayment Agreement Size of Pledged Area
📏 Prepayment Agreement Size of Pledged Productive Area UoM (PrepaymentPledgedProdtvAreaUoM):
PrepaymentPledgedProdtvAreaQty Prepayment Agreement Size of Pledged Productive Area
📏 Prepayment Agreement Size of Own Pledged Area UOM (PrepaymentOwnPledgedAreaUoM):
PrepaymentOwnPledgedAreaQty Prepayment Agreement Size of Own Pledged Area
📏 Prepayment Agreement Total Pledged Area UoM (PrepaymentTotalPledgedAreaUoM):
PrepaymentTotalPledgedAreaQty Prepayment Agreement Total Pledged Area
📏 Prepayment Agreement Productivity Factor UoM (PrepaymentProductivityFctrUoM):
PrepaymentProductivityFctrQty Prepayment Agreement Productivity Factor
📏 Prepayment Agreement Estimated Production UoM (PrepaymentEstimatedProdnUoM):
PrepaymentEstimatedProdnQty Prepayment Agreement Estimated Production
Column Name Description
PrepaymentAgrmtDueDate Prepayment Agreement Credit Due Date ( Obsolete )
PrepaymentLimitCreditDate Prepayment Agreement Limit Date for Use of Credit
PrepaymentStartIntrstDate Prepayment Agreement Interest Start Date
PrepaymentStopIntrstDate Prepayment Agreement Interest Stop Date
Column Name Description
PrepaymentAgreementCategory Prepayment Agreement Category Show values
PrepaymentAgrmtBPType Counterparty Type Show values
PrepaymentPrincipalReduction Principal Reduction Method Show values
PrepaymentCreditContractFlag Prepayment Agreement Credit Contract Flag Show values
PrepaymentStartIntrstDateType Prepayment Agreement Interest Start Date Type Show values
PrepaymentStopIntrstDateType Prepayment Agreement Interest Stop Date Type Show values
PrepaymentAgrmtLinkStatus Prepayment Agreement Link Status Show values
PrepaymentBarterLinkStatus Prepayment Barter Link Status Show values
PrepaymentAgrmtSource Prepayment Agreement Data Source Show values
Column Name Description Domain name
PrepaymentAgreement Prepayment Agreement PPMGAC_D_AGMNT
PrepaymentAgreementDescription Prepayment Agreement Description PPMGAG_D_AGMDESCRIPTION
PrepaymentAgreementStatus Prepayment Agreement Status J_STATUS
PrepaymentAgreementCommodity Commodity TBA_STOEFFCHEN
PrepaymentEconomicGroup Prepayment Agreement Economic Group PPMGAG_D_ECONOMICGROUP
PrepaymentAgrmtExtCommentText Prepayment Internal Comments - Obsolete PPMGAG_D_COMMENT
PrepaymentAgrmtIntCommentText Prepayment External Comments - Obsolete PPMGAG_D_COMMENT
Plant Plant WERKS
PrepaymentAgrmtCropSeason Prepayment Agreement Crop Season PPMGAG_D_CROPSEASON
PrepaymentAgreementRating Prepayment Agreement Credit Rating PPMGAG_D_CREDITRATING
PrepaymentCreditRegion Prepayment Agreement Credit Region/Province CHAR40
PrepaymentCmtmtPercent Prepayment Agreement Percentage of Commitment PPMGAG_D_PERCENTAGE
PrepaymentPayoutPercent Prepayment Agreement Payout Percentage PPMGAG_D_PERCENTAGE
PrepaymentRestrictionsTxt Prepayment Agreement Credit Restrictions PPMGAG_D_CREDITRESTRICTIONS
PrepaymentCreditHistoryTxt Prepayment Agreement Credit History PPMGAG_D_CREDITHISTORY
BPTaxNumber Business Partner Tax Number BPTAXNUM
AddressNumber Address Number AD_ADDRNUM
PrepaymentAgrmtPostingStatus Prepayment Agreement Posting Status J_STATUS
PrepaymentApprovalDateTime Prepayment Approval Date and Time TZNTSTMPS
PrepaymentAgrmtRjcnReason Reason Code for Rejection WFGRU
PrepaymentRejectionText Prepayment Agreement Rejection Comment PPMGAG_D_REJ_COMMENT
CreatedByUser Created By USNAM
CreationDateTime Timestamp of Record Creation TZNTSTMPS
LastChangedByUser Last Changed By (User ID) USNAM
LastChangeDateTime Timestamp of Last Change TZNTSTMPS
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_PREPAYMENTAGREEMENT.COMPANYCODE == T001.BUKRS
  • I_PREPAYMENTAGREEMENT.MANDT == T001.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_PREPAYMENTAGREEMENT.COUNTRYCODE == T005S.LAND1
  • I_PREPAYMENTAGREEMENT.MANDT == T005S.MANDT
  • I_PREPAYMENTAGREEMENT.COMPANYREGION == T005S.BLAND
Counterparty
  • Counterparty
  • Client
  • I_PREPAYMENTAGREEMENT.COUNTERPARTY == BUT000.PARTNER
  • I_PREPAYMENTAGREEMENT.MANDT == BUT000.CLIENT
Country/Region Key
  • Country/Region Key
  • Client
  • I_PREPAYMENTAGREEMENT.COUNTRYCODE == T005.LAND1
  • I_PREPAYMENTAGREEMENT.MANDT == T005.MANDT
City Code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • City Code
  • I_PREPAYMENTAGREEMENT.COUNTRYCODE == T005G.LAND1
  • I_PREPAYMENTAGREEMENT.MANDT == T005G.MANDT
  • I_PREPAYMENTAGREEMENT.COMPANYREGION == T005G.REGIO
  • I_PREPAYMENTAGREEMENT.CUSTOMERCITYCODE == T005G.CITYC
Distribution Channel
  • Client
  • Distribution Channel
  • I_PREPAYMENTAGREEMENT.MANDT == TVTW.MANDT
  • I_PREPAYMENTAGREEMENT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_PREPAYMENTAGREEMENT.MANDT == TSPA.MANDT
  • I_PREPAYMENTAGREEMENT.DIVISION == TSPA.SPART
Prepayment Agreement Type
  • Client
  • Prepayment Agreement Category
  • Prepayment Agreement Type
  • I_PREPAYMENTAGREEMENT.MANDT == PPMGAG_C_AGMNTYP.MANDT
  • I_PREPAYMENTAGREEMENT.PREPAYMENTAGREEMENTCATEGORY == PPMGAG_C_AGMNTYP.PREPAYMENTAGREEMENTCATEGORY
  • I_PREPAYMENTAGREEMENT.PREPAYMENTAGREEMENTTYPE == PPMGAG_C_AGMNTYP.PREPAYMENTAGREEMENTTYPE
Estimated Production Per Unit of Measure ( Obsolete )
  • Client
  • Estimated Production Per Unit of Measure ( Obsolete )
  • I_PREPAYMENTAGREEMENT.MANDT == T006.MANDT
  • I_PREPAYMENTAGREEMENT.PREPAYMENTESTIMATEDPRODPERUOM == T006.MSEHI
Purchasing Group
  • Client
  • Purchasing Group
  • I_PREPAYMENTAGREEMENT.MANDT == T024.MANDT
  • I_PREPAYMENTAGREEMENT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • I_PREPAYMENTAGREEMENT.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PREPAYMENTAGREEMENT.MANDT == T024E.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_PREPAYMENTAGREEMENT.MANDT == TVKO.MANDT
  • I_PREPAYMENTAGREEMENT.SALESORGANIZATION == TVKO.VKORG