C_PrepaymentContractLinked

List of linked Prepayment agreements | view: CPPMTCON | Extraction: Not supported | Component: SAP Agricultural Contract Management
Tables used: WBHK, PPMGAG_T_PPMT, PPMGAG_T_APPR, PPMGAG_T_ASS_DOC, WBHD, PPMGAG_C_AGMNTYP, PPMGAG_C_AGMNTYT, TJ02T
Column Name Description
PrepaymentAssignedDocumentUUID UUID serving as key (parent key, root key)
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
Column Name Description
PrepaymentAgrmtLinkStatus Prepayment Agreement Link Status Show values
PrepaymentBarterLinkStatus Prepayment Barter Link Status Show values
PrepaymentAgreementCategory Prepayment Agreement Category Show values
PrepaymentAgrmtIsPosted Prepayment Agreement Posted Show values
FinalSettlementIndicator Final Settlement Show values
Column Name Description Domain name
PrepaymentAgreementStatus Prepayment Agreement Status J_STATUS
PrepaymentAgrmtPostingStatus Prepayment Agreement Posting Status J_STATUS
ProcessingStatusDesc Object status TEXT30
LoanPaymentStatusText Object status TEXT30
AssignmentStatusText Short Text for Fixed Values DDTEXT
PrepaymentPayoutPercent Prepayment Agreement Payout Percentage PPMGAG_D_PERCENTAGE
PrepaymentAgreementCommodity Commodity TBA_STOEFFCHEN
TradingContract null
PrepaymentAgrmtRefDocItem Linking Document Number Item POSNR
PrepaymentAgrmtRefDocumentType Document Type CHAR4
PrepaymentAgreementText Prepayment Agreement Description PPMGAG_D_AGMDESCRIPTION
PrepaymentAgreementCatText Short Text for Fixed Values DDTEXT
PrepaymentAgrmtLinkStatusText Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PREPAYMENTCONTRACTLINKED.MANDT == T001.MANDT
  • C_PREPAYMENTCONTRACTLINKED.COMPANYCODE == T001.BUKRS
Counterparty
  • Counterparty
  • Client
  • C_PREPAYMENTCONTRACTLINKED.COUNTERPARTY == BUT000.PARTNER
  • C_PREPAYMENTCONTRACTLINKED.MANDT == BUT000.CLIENT
Check Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • C_PREPAYMENTCONTRACTLINKED.MANDT == TVKOV.MANDT
  • C_PREPAYMENTCONTRACTLINKED.SALESORGANIZATION == TVKOV.VKORG
  • C_PREPAYMENTCONTRACTLINKED.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Check Division
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_PREPAYMENTCONTRACTLINKED.MANDT == TVTA.MANDT
  • C_PREPAYMENTCONTRACTLINKED.DIVISION == TVTA.SPART
  • C_PREPAYMENTCONTRACTLINKED.SALESORGANIZATION == TVTA.VKORG
  • C_PREPAYMENTCONTRACTLINKED.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Prepayment Agreement Type
  • Client
  • Prepayment Agreement Category
  • Prepayment Agreement Type
  • C_PREPAYMENTCONTRACTLINKED.MANDT == PPMGAG_C_AGMNTYP.MANDT
  • C_PREPAYMENTCONTRACTLINKED.PREPAYMENTAGREEMENTCATEGORY == PPMGAG_C_AGMNTYP.PREPAYMENTAGREEMENTCATEGORY
  • C_PREPAYMENTCONTRACTLINKED.PREPAYMENTAGREEMENTTYPE == PPMGAG_C_AGMNTYP.PREPAYMENTAGREEMENTTYPE
Check Purchasing Group
  • Client
  • Purchasing Group
  • C_PREPAYMENTCONTRACTLINKED.MANDT == T024.MANDT
  • C_PREPAYMENTCONTRACTLINKED.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Client
  • Purchasing organization
  • C_PREPAYMENTCONTRACTLINKED.MANDT == T024E.MANDT
  • C_PREPAYMENTCONTRACTLINKED.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Organization
  • Client
  • Sales Organization
  • C_PREPAYMENTCONTRACTLINKED.MANDT == TVKO.MANDT
  • C_PREPAYMENTCONTRACTLINKED.SALESORGANIZATION == TVKO.VKORG
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • C_PREPAYMENTCONTRACTLINKED.MANDT == TB2BE.MANDT
  • C_PREPAYMENTCONTRACTLINKED.TRADINGCONTRACTTYPE == TB2BE.TCTYP