I_PrepaymentAgreementDetails

prepaymeny Agreement Details | view: IPPMGAGREEMENTD | TRAN | Extraction: Not supported | Component: Prepayment agreements
Tables used: PPMGAG_T_PPMT
Column Name Description
PrepaymentAgreementUUID UUID serving as key (parent key, root key)
PrepaymentAgreement Prepayment Agreement
Column Name Description
💲 Prepayment Agreement Currency (PrepaymentAgreementCurrency):
PrepaymentAgreementAmount Prepayment Agreement Amount
Column Name Description
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
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
Column Name Description Domain name
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
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
PrepaymentAgrmtPostingStatus Prepayment Agreement Posting Status J_STATUS
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
  • Client
  • Company Code
  • I_PREPAYMENTAGREEMENTDETAILS.MANDT == T001.MANDT
  • I_PREPAYMENTAGREEMENTDETAILS.COMPANYCODE == T001.BUKRS
Counterparty
  • Client
  • Counterparty
  • I_PREPAYMENTAGREEMENTDETAILS.MANDT == BUT000.CLIENT
  • I_PREPAYMENTAGREEMENTDETAILS.COUNTERPARTY == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • I_PREPAYMENTAGREEMENTDETAILS.MANDT == TVTW.MANDT
  • I_PREPAYMENTAGREEMENTDETAILS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_PREPAYMENTAGREEMENTDETAILS.MANDT == TSPA.MANDT
  • I_PREPAYMENTAGREEMENTDETAILS.DIVISION == TSPA.SPART
Prepayment Agreement Type
  • Client
  • Prepayment Agreement Category
  • Prepayment Agreement Type
  • I_PREPAYMENTAGREEMENTDETAILS.MANDT == PPMGAG_C_AGMNTYP.MANDT
  • I_PREPAYMENTAGREEMENTDETAILS.PREPAYMENTAGREEMENTCATEGORY == PPMGAG_C_AGMNTYP.PREPAYMENTAGREEMENTCATEGORY
  • I_PREPAYMENTAGREEMENTDETAILS.PREPAYMENTAGREEMENTTYPE == PPMGAG_C_AGMNTYP.PREPAYMENTAGREEMENTTYPE
Purchasing Group
  • Client
  • Purchasing Group
  • I_PREPAYMENTAGREEMENTDETAILS.MANDT == T024.MANDT
  • I_PREPAYMENTAGREEMENTDETAILS.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • I_PREPAYMENTAGREEMENTDETAILS.MANDT == T024E.MANDT
  • I_PREPAYMENTAGREEMENTDETAILS.PURCHASINGORGANIZATION == T024E.EKORG
Sales Organization
  • Client
  • Sales Organization
  • I_PREPAYMENTAGREEMENTDETAILS.MANDT == TVKO.MANDT
  • I_PREPAYMENTAGREEMENTDETAILS.SALESORGANIZATION == TVKO.VKORG