I_PubSecContractPartner

PubSec Contract for BP & Acct Cat | view: IPSCONTRACTBPACC | Extraction: Not supported | Component: Public Sector Contract Accounts Receivable and Payable
Tables used: DPSOB_BP_ACC
Column Name Description
PublicSectorContract FK Identification Key for Contract Object
ContractPartner FK Business Partner Number
ContractAccountCategory FK Contract Account Category
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangedDate Last Changed On
Column Name Description
ContractAccountIsObsolete Indicator for Obsolete Contract Account Data Show values
IsMarkedForArchiving Partial Archiving Preselection Show values
PubSecContrPaytParamIsActv Payment Parameters Active for Contract Object Show values
ContrCorrespncParamIsActive Correspondence Parameters Active for Contract Object Show values
SeparateInvoiceIsCreated Separate Invoice Show values
CACorrespondenceRecurrence Correspondence Interval Show values
PostponementDays Postponement of a Period (Number of Days) Show values
PostponementMonths Postponement of a Period (Months) Show values
InbCorrespncParamIsUsd Overwrite Customizing Settings Show values
ReminderIsSent Send Reminder Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
CAHouseBankReference Own Bank Details EIGBV_KK
AddressID Address Number AD_ADDRNUM
CAAddressIDOfAlternativePayer Address Number for Alternative Payer AD_ADDRNUM
CAPaymentMethodForIncgPayment Incoming Payment Method CHAR1
CABankIDForIncomingPayments Bank Details ID for Incoming Payments CHAR4
CAPaymentCardIDForIncomingPayt Payment Card ID for Incoming Payments CHAR6
CAAddressIDOfAlternativePayee Address Number for Alternative Payee AD_ADDRNUM
CAPaymentMethodForOutgPayment Outgoing Payment Methods CHAR5
CABankIDForOutgoingPayments Bank Details ID for Outgoing Payments CHAR4
CAPaymentCardIDForOutgoingPayt Payment Card ID for Outgoing Payments CHAR6
CACollectionStrategy Collection Strategy STRAT_CM_KK
CACollectionsContactPerson Collections Contact Person BU_PARTNER
SEPAMandate Unique Reference to Mandate for each Payee ID035
PubSecContractInvoiceType Invoice Type INVTP_PS
CAAddrIDOfAltvCorrespncRcpnt Standard Address No. of Alternative Correspondence Recipient AD_ADDRNUM
CACorrespondenceDunningProced Correspondence Dunning Procedure MAHNV_KK
InboundCorrespncStartPeriod First Valid Period for Generating Inbound Correspondence COPNR_KK
InboundCorrespncStartYear Year of first valid period GJAHR
InboundCorrespncEndPeriod Last Valid Period for Generating Inbound Correspondence COPNR_KK
InboundCorrespncEndYear Year of Final Valid Period GJAHR
Master Data Relations Join Conditions
Account Determination ID for Contract Objects
  • Account Determination ID for Contract Objects
  • Client
  • I_PUBSECCONTRACTPARTNER.CAACCOUNTDETERMINATIONCODE == TFMCA007.KOFIZ
  • I_PUBSECCONTRACTPARTNER.MANDT == TFMCA007.MANDT
Business Partner
  • Alternative Correspondence Recipient for Standard Case
  • Client
  • I_PUBSECCONTRACTPARTNER.CAALTERNATIVECORRESPNCRCPNT == BUT000.PARTNER
  • I_PUBSECCONTRACTPARTNER.MANDT == BUT000.CLIENT
Business Partner
  • Alternative Payee
  • Client
  • I_PUBSECCONTRACTPARTNER.CAALTERNATIVEPAYEE == BUT000.PARTNER
  • I_PUBSECCONTRACTPARTNER.MANDT == BUT000.CLIENT
Business Partner
  • Client
  • Alternative Payer
  • I_PUBSECCONTRACTPARTNER.MANDT == BUT000.CLIENT
  • I_PUBSECCONTRACTPARTNER.CAALTERNATIVEPAYER == BUT000.PARTNER
Collection Management: Master Data Group
  • Client
  • Collection Management: Master Data Group
  • I_PUBSECCONTRACTPARTNER.MANDT == TFK041B.MANDT
  • I_PUBSECCONTRACTPARTNER.CACOLLECTIONSMASTERDATAGROUP == TFK041B.CMGRP
Correspondence Activities
  • Client
  • FI-CA correspondence - activity key
  • I_PUBSECCONTRACTPARTNER.MANDT == TFK070L.MANDT
  • I_PUBSECCONTRACTPARTNER.CACORRESPONDENCEACTIVITYCODE == TFK070L.CORR_ACKEY
Correspondence Variant
  • Correspondence Variant
  • Client
  • I_PUBSECCONTRACTPARTNER.CACORRESPONDENCEVARIANT == TFK070B.COPRC
  • I_PUBSECCONTRACTPARTNER.MANDT == TFK070B.MANDT
Contract Accounts
  • Contract Account Number
  • Client
  • I_PUBSECCONTRACTPARTNER.CONTRACTACCOUNT == FKKVK.VKONT
  • I_PUBSECCONTRACTPARTNER.MANDT == FKKVK.MANDT
Contract Account Categories
  • ?
  • Client
  • Contract Account Category
  • I_PUBSECCONTRACTPARTNER.[column in domain "APPLK_KK"] == TFK002A.APPLK
  • I_PUBSECCONTRACTPARTNER.MANDT == TFK002A.MANDT
  • I_PUBSECCONTRACTPARTNER.CONTRACTACCOUNTCATEGORY == TFK002A.VKTYP
Contract Partner
  • Business Partner Number
  • Contract Account Number
  • Client
  • I_PUBSECCONTRACTPARTNER.CONTRACTPARTNER == FKKVKP.GPART
  • I_PUBSECCONTRACTPARTNER.CONTRACTACCOUNT == FKKVKP.VKONT
  • I_PUBSECCONTRACTPARTNER.MANDT == FKKVKP.MANDT
Status for Generation of Inbound Correspondence
  • Status for Generation of Inbound Correspondence
  • Client
  • I_PUBSECCONTRACTPARTNER.INBCORRESPNCCREATIONSTATUS == TFMCA001.FILSTAT
  • I_PUBSECCONTRACTPARTNER.MANDT == TFMCA001.MANDT
Contract Object
  • Client
  • Identification Key for Contract Object
  • I_PUBSECCONTRACTPARTNER.MANDT == DPSOB.CLIENT
  • I_PUBSECCONTRACTPARTNER.PUBLICSECTORCONTRACT == DPSOB.PSOBKEY