CRMS4_IU_I_CAP

Contract Account Partner | view: CRMS4IUVICAP | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: FKKVKP, DFKKLOCKS, TFK001G, T001, TKA02, FKKVKP
Column Name Description
ContractAccount FK Contract Account
BusinessPartner FK Business Partner Number
Column Name Description
💲 Currency of Direct Debit Limit (CACurrencyForDirectDebitLimit):
CADirectDebitLimit Direct Debit Limit
Column Name Description
Column Name Description
CreationDate Creation Date
LastChangeDate Last Change Date
ValdtyDateForWhldgTaxExmpCert Validity Date for Withholding Tax Exemption Certificate
CAStartDateForBillingPeriod Start Date of First Billing Period
CABusinessPartnerLockStartDate Lock valid from
CABusinessPartnerLockEndDate Lock valid to
Column Name Description
IsMarkedForDeletion Deletion Indicator Show values
CADirectDebitLimitCalcMode Rolling Calculation of Direct Debit Limit Show values
CALastDayOfBillingPeriod Day of Period End Show values
CAClearingRestriction Clearing Restriction Show values
CABusinessPartnerLock Business Partner Lock for Postings/Clearing Show values
Column Name Description Domain name
guid Business Agreement GUID SYSUUID
ContractAccountName Description of Contract Account TEXT35
CreatedByUser Created By XUBNAME
LastChangedByUser Name of Person Who Changed Object USNAM
PartnerCompany Company ID of Trading Partner RCOMP
CABPReferenceNumber Reference number for business partner CHAR25
CAAdditionalDaysForCashMgmt Additional Days for Cash Management NUM2
CAAccountDeterminationCode Account Determination ID KOFIZ_KK
TaxJurisdiction Tax Jurisdiction TXJCD
CAStandardCompanyCode Standard Company Code BUKRS
CAPaymentMethodForIncgPayment Incoming Payment Method CHAR1
CABankIDForIncomingPayments Bank Details ID for Incoming Payments CHAR4
SEPAMandate Unique Reference to Mandate for each Payee ID035
CAPaymentCardIDForIncomingPayt Payment Card ID for Incoming Payments CHAR6
CAPaymentMethodForOutgPayment Outgoing Payment Methods CHAR5
CABankIDForOutgoingPayments Bank Details ID for Outgoing Payments CHAR4
CAPaymentCardIDForOutgoingPayt Payment Card ID for Outgoing Payments CHAR6
WithholdingTaxCertificate Withholding Tax Certificate CHAR10
CACorrespondenceDunningProced Correspondence Dunning Procedure MAHNV_KK
CAMasterAgreement Identification of Master Agreement MAKEY_KK
CAAddressIDOfAlternativePayer Address Number for Alternative Payer AD_ADDRNUM
CAAddressIDOfAlternativePayee Address Number for Alternative Payee AD_ADDRNUM
CAAddressIDOfAltvDunRecipient Address number for alternative dunning notice recipient AD_ADDRNUM
CAAddressIDOfAltvInvoiceRcpnt Address number for alternative bill recipient AD_ADDRNUM
AddressID Address Number AD_ADDRNUM
CAAddressIDOfJurisdictionCode Address Number for Jurisdiction Code Address AD_ADDRNUM
CANmbrMnthsForDirectDebitLimit Number of Months for Calculation of Direct Debit Limit NUM02
DunningLockReason Lock Reason LOCKR_KK
InvoicingLockReason Lock Reason LOCKR_KK
ConvergentInvoicingLockReason Lock Reason LOCKR_KK
PostingLockReason Lock Reason LOCKR_KK
CalculateInterestLockReason Lock Reason LOCKR_KK
IncomingPaymentLockReason Lock Reason LOCKR_KK
OutgoingPaymentLockReason Lock Reason LOCKR_KK
CorrDunningLockReason Lock Reason LOCKR_KK
Master Data Relations Join Conditions
Alternative Contract Account for Collective Bills
  • Alternative Contract Account for Collective Bills
  • Client
  • CRMS4_IU_I_CAP.ALTVCONTRACTACCTFORCOLLVBILLS == FKKVK.VKONT
  • CRMS4_IU_I_CAP.MANDT == FKKVK.MANDT
Business Area
  • Business Area
  • Client
  • CRMS4_IU_I_CAP.BUSINESSAREA == TGSB.GSBER
  • CRMS4_IU_I_CAP.MANDT == TGSB.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • CRMS4_IU_I_CAP.BUSINESSPARTNER == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
Business Place
  • Standard Company Code
  • ?
  • Client
  • Business Place
  • CRMS4_IU_I_CAP.CASTANDARDCOMPANYCODE == J_1BBRANCH.BUKRS
  • CRMS4_IU_I_CAP.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • CRMS4_IU_I_CAP.MANDT == J_1BBRANCH.MANDT
  • CRMS4_IU_I_CAP.BUSINESSPLACE == J_1BBRANCH.BRANCH
Alternative Correspondence Recipient for Standard Case
  • Client
  • Alternative Correspondence Recipient for Standard Case
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
  • CRMS4_IU_I_CAP.CAALTERNATIVECORRESPNCRCPNT == BUT000.PARTNER
Alternative Dunning Recipient
  • Alternative Dunning Recipient
  • Client
  • CRMS4_IU_I_CAP.CAALTERNATIVEDUNNINGRECIPIENT == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
Alternative Invoice Recipient
  • Alternative Invoice Recipient
  • Client
  • CRMS4_IU_I_CAP.CAALTERNATIVEINVOICERECIPIENT == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
Alternative Payee
  • Alternative Payee
  • Client
  • CRMS4_IU_I_CAP.CAALTERNATIVEPAYEE == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
Alternative Payer
  • Alternative Payer
  • Client
  • CRMS4_IU_I_CAP.CAALTERNATIVEPAYER == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
Authorization Group
  • Authorization Group
  • ?
  • Client
  • CRMS4_IU_I_CAP.CAAUTHORIZATIONGROUP == TFK_BEGRU.BEGRU
  • CRMS4_IU_I_CAP.[column in domain "BGOBJ_KK"] == TFK_BEGRU.BGOBJ
  • CRMS4_IU_I_CAP.MANDT == TFK_BEGRU.CLIENT
Billing Cycle
  • Client
  • Billing Cycle
  • CRMS4_IU_I_CAP.MANDT == TFK2607.MANDT
  • CRMS4_IU_I_CAP.CABILLGCYCLE == TFK2607.CYCLE
Recipient of Invoicing List
  • Recipient of Invoicing List
  • Client
  • CRMS4_IU_I_CAP.CABUSINESSPARTNERFORINVCGLIST == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
BP Acting as Payer/Payee in Payment Transactions
  • Client
  • BP Acting as Payer/Payee in Payment Transactions
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
  • CRMS4_IU_I_CAP.CABUSINESSPARTNERFORPAYMENT == BUT000.PARTNER
Business Partner for Posting of the Invoice
  • Business Partner for Posting of the Invoice
  • Client
  • CRMS4_IU_I_CAP.CABUSINESSPARTNERFORPOSTING == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
Clearing Category For Clearing Postings
  • Clearing Category For Clearing Postings
  • Client
  • CRMS4_IU_I_CAP.CACLEARINGCATEGORY == TFK111.VERTYP
  • CRMS4_IU_I_CAP.MANDT == TFK111.MANDT
Clerk Responsible
  • Clerk Responsible
  • Client
  • CRMS4_IU_I_CAP.CACOLLECTIONSCLERK == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
Collections Contact Person
  • Collections Contact Person
  • Client
  • CRMS4_IU_I_CAP.CACOLLECTIONSCONTACTPERSON == BUT000.PARTNER
  • CRMS4_IU_I_CAP.MANDT == BUT000.CLIENT
Collection Management: Master Data Group
  • Client
  • Collection Management: Master Data Group
  • CRMS4_IU_I_CAP.MANDT == TFK041B.MANDT
  • CRMS4_IU_I_CAP.CACOLLECTIONSMASTERDATAGROUP == TFK041B.CMGRP
Collection Strategy
  • Client
  • Collection Strategy
  • CRMS4_IU_I_CAP.MANDT == TFK047X.MANDT
  • CRMS4_IU_I_CAP.CACOLLECTIONSTRATEGY == TFK047X.STRAT
Company Code Group
  • Client
  • Company Code Group
  • CRMS4_IU_I_CAP.MANDT == TFK001G.MANDT
  • CRMS4_IU_I_CAP.CACOMPANYCODEGROUP == TFK001G.OPBUK
FI-CA correspondence - activity key
  • FI-CA correspondence - activity key
  • Client
  • CRMS4_IU_I_CAP.CACORRESPONDENCEACTIVITYCODE == TFK070L.CORR_ACKEY
  • CRMS4_IU_I_CAP.MANDT == TFK070L.MANDT
Correspondence Variant
  • Correspondence Variant
  • Client
  • CRMS4_IU_I_CAP.CACORRESPONDENCEVARIANT == TFK070B.COPRC
  • CRMS4_IU_I_CAP.MANDT == TFK070B.MANDT
Currency of Direct Debit Limit
  • Currency of Direct Debit Limit
  • Client
  • CRMS4_IU_I_CAP.CACURRENCYFORDIRECTDEBITLIMIT == TCURC.WAERS
  • CRMS4_IU_I_CAP.MANDT == TCURC.MANDT
Determination Characteristic for Alternative Invoice Form
  • Determination Characteristic for Alternative Invoice Form
  • Client
  • CRMS4_IU_I_CAP.CADETNCODEFORALTVINVOICEFORM == TFK2681.FORM_DET_KEY
  • CRMS4_IU_I_CAP.MANDT == TFK2681.MANDT
Grouping fur Dunning Notices
  • Client
  • Grouping fur Dunning Notices
  • CRMS4_IU_I_CAP.MANDT == TFK047F.MANDT
  • CRMS4_IU_I_CAP.CADUNNINGNOTICEGROUP == TFK047F.MGRUP
Dunning Procedure
  • Client
  • Dunning Procedure
  • CRMS4_IU_I_CAP.MANDT == TFK047A.MANDT
  • CRMS4_IU_I_CAP.CADUNNINGPROCEDURE == TFK047A.MAHNV
Interest Key
  • Interest Key
  • Client
  • CRMS4_IU_I_CAP.CAINTERESTCODE == TFK056A.IKEY
  • CRMS4_IU_I_CAP.MANDT == TFK056A.MANDT
Invoicing Category
  • Client
  • Invoicing Category
  • CRMS4_IU_I_CAP.MANDT == TFK2604.MANDT
  • CRMS4_IU_I_CAP.CAINVCGCATEGORY == TFK2604.INV_CATEGORY
Selection Characteristic for Scheduling
  • Selection Characteristic for Scheduling
  • Client
  • CRMS4_IU_I_CAP.CAINVCGSCHEDULE == TFK2606.INV_SCHEDULE
  • CRMS4_IU_I_CAP.MANDT == TFK2606.MANDT
Partner Settlement Rule
  • Partner Settlement Rule
  • Client
  • CRMS4_IU_I_CAP.CAPARTNERSETTLEMENTRULE == TFKPS_RULE.PTSRL
  • CRMS4_IU_I_CAP.MANDT == TFKPS_RULE.MANDT
Company Code for Automatic Payment Transactions
  • Client
  • Company Code for Automatic Payment Transactions
  • CRMS4_IU_I_CAP.MANDT == T001.MANDT
  • CRMS4_IU_I_CAP.CAPAYMENTCOMPANYCODE == T001.BUKRS
Business partner account relationship
  • Client
  • Relationship of Business Partner to Contract Account
  • CRMS4_IU_I_CAP.MANDT == TFK002F.MANDT
  • CRMS4_IU_I_CAP.CARELATIONSHIPOFBPTOCONTRACCT == TFK002F.VKPBZ
Planning Group
  • Planning Group
  • Client
  • CRMS4_IU_I_CAP.CASHPLANNINGGROUP == T035.GRUPP
  • CRMS4_IU_I_CAP.MANDT == T035.MANDT
Target Currency of Invoicing
  • Target Currency of Invoicing
  • Client
  • CRMS4_IU_I_CAP.CATARGETCURRENCYFORINVOICING == TCURC.WAERS
  • CRMS4_IU_I_CAP.MANDT == TCURC.MANDT
Tolerance group for contract account
  • Tolerance group for contract account
  • Client
  • CRMS4_IU_I_CAP.CATOLERANCEGROUP == TFK043.TOGRU
  • CRMS4_IU_I_CAP.MANDT == TFK043.MANDT
Withholding Tax Code For Incoming Payments
  • ?
  • Withholding Tax Code For Incoming Payments
  • Client
  • CRMS4_IU_I_CAP.[column in domain "LAND1"] == T059Q.LAND1
  • CRMS4_IU_I_CAP.CAWHLDGTAXCODEINCOMINGPAYT == T059Q.QSSKZ
  • CRMS4_IU_I_CAP.MANDT == T059Q.MANDT
Witholding Tax Code For Outgoing Payments
  • ?
  • Witholding Tax Code For Outgoing Payments
  • Client
  • CRMS4_IU_I_CAP.[column in domain "LAND1"] == T059Q.LAND1
  • CRMS4_IU_I_CAP.CAWHLDGTAXCODEOUTGOINGPAYT == T059Q.QSSKZ
  • CRMS4_IU_I_CAP.MANDT == T059Q.MANDT
Contract Account
  • Client
  • Contract Account
  • CRMS4_IU_I_CAP.MANDT == FKKVK.MANDT
  • CRMS4_IU_I_CAP.CONTRACTACCOUNT == FKKVK.VKONT
Contract Account of Recipient of Invoicing List
  • Client
  • Contract Account of Recipient of Invoicing List
  • CRMS4_IU_I_CAP.MANDT == FKKVK.MANDT
  • CRMS4_IU_I_CAP.CONTRACTACCOUNTFORINVCGLIST == FKKVK.VKONT
Contract account used for payment transactions
  • Contract account used for payment transactions
  • Client
  • CRMS4_IU_I_CAP.CONTRACTACCOUNTFORPAYMENT == FKKVK.VKONT
  • CRMS4_IU_I_CAP.MANDT == FKKVK.MANDT
Contract Account of Invoice Recipient
  • Contract Account of Invoice Recipient
  • Client
  • CRMS4_IU_I_CAP.CONTRACTACCOUNTFORPOSTING == FKKVK.VKONT
  • CRMS4_IU_I_CAP.MANDT == FKKVK.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • CRMS4_IU_I_CAP.COUNTRY == T005.LAND1
  • CRMS4_IU_I_CAP.MANDT == T005.MANDT
County Code
  • ?
  • Region (State, Province, County)
  • Client
  • County Code
  • CRMS4_IU_I_CAP.[column in domain "LAND1"] == T005E.LAND1
  • CRMS4_IU_I_CAP.PROVINCE == T005E.REGIO
  • CRMS4_IU_I_CAP.MANDT == T005E.MANDT
  • CRMS4_IU_I_CAP.COUNTY == T005E.COUNC
Tax type
  • Tax type
  • Client
Payment Condition
  • Client
  • Payment Condition
  • CRMS4_IU_I_CAP.MANDT == TE052.MANDT
  • CRMS4_IU_I_CAP.PAYMENTCONDITION == TE052.ZAHLKOND
Region (State, Province, County)
  • ?
  • Region (State, Province, County)
  • Client
  • CRMS4_IU_I_CAP.[column in domain "LAND1"] == T005S.LAND1
  • CRMS4_IU_I_CAP.PROVINCE == T005S.BLAND
  • CRMS4_IU_I_CAP.MANDT == T005S.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • CRMS4_IU_I_CAP.SUPPLYINGCOUNTRY == T005.LAND1
  • CRMS4_IU_I_CAP.MANDT == T005.MANDT