CRMS4_IU_C_CAP

Contract Account Partner | view: CRMS4IUVCCAP | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: FKKVKP, DFKKLOCKS, TFK001G, TFK002F, T001, TKA02, TFK002A, TFK002AT, FKKVK, FKKVKP, TFK000
Column Name Description
VKONT FK Contract Account
GPART FK Business Partner Number
Column Name Description
💲 Currency of Direct Debit Limit (DDLCU):
DDLAM Direct Debit Limit
Column Name Description
Column Name Description
ERDAT Creation Date
AEDATP Last Change Date
QSZDT Validity Date for Withholding Tax Exemption Certificate
INV_CYCLE_START Start Date of First Billing Period
BPL_FDATE Lock valid from
BPL_TDATE Lock valid to
Column Name Description
LOEVM Deletion Indicator Show values
DDLXG Rolling Calculation of Direct Debit Limit Show values
INV_CYCLE_DAY Day of Period End Show values
BPL_XPOCL Business Partner Lock for Postings/Clearing Show values
AUGRS_DEF Clearing Restriction Show values
XKTIN Account Holder Show values
APPLK Application Area Show values
Column Name Description Domain name
guid Business Agreement GUID SYSUUID
VKBEZ Description of Contract Account TEXT35
ERNAM Created By XUBNAME
AENAMP Name of Person Who Changed Object USNAM
VBUND Company ID of Trading Partner RCOMP
EXVKO Reference number for business partner CHAR25
FDZTG Additional Days for Cash Management NUM2
KOFIZ_SD Account Determination ID KOFIZ_KK
TXJCD Tax Jurisdiction TXJCD
STDBK Standard Company Code BUKRS
EZAWE Incoming Payment Method CHAR1
EBVTY Bank Details ID for Incoming Payments CHAR4
MNDID Unique Reference to Mandate for each Payee ID035
CCARD_ID Payment Card ID for Incoming Payments CHAR6
AZAWE Outgoing Payment Methods CHAR5
ABVTY Bank Details ID for Outgoing Payments CHAR4
CCARD_OUT Payment Card ID for Outgoing Payments CHAR6
QSZNR Withholding Tax Certificate CHAR10
CORR_MAHNV Correspondence Dunning Procedure MAHNV_KK
MAKEY Identification of Master Agreement MAKEY_KK
DDLNM Number of Months for Calculation of Direct Debit Limit NUM02
ADRRE Address Number for Alternative Payer AD_ADDRNUM
ADRRA Address Number for Alternative Payee AD_ADDRNUM
ADRMA Address number for alternative dunning notice recipient AD_ADDRNUM
ADRRH Address number for alternative bill recipient AD_ADDRNUM
ADRNB Address Number AD_ADDRNUM
ADRJDC Address Number for Jurisdiction Code Address AD_ADDRNUM
VKTYP_DESC Description of Contract Account Category TEXT50
LOCKR_DUNNING Lock Reason LOCKR_KK
LOCKR_INVOICING Lock Reason LOCKR_KK
LOCKR_CONVERGENT_INVOICING Lock Reason LOCKR_KK
LOCKR_POSTING Lock Reason LOCKR_KK
LOCKR_CALCULATE_INTEREST Lock Reason LOCKR_KK
LOCKR_INCOMING_PAYMENT Lock Reason LOCKR_KK
LOCKR_OUTGOING_PAYMENT Lock Reason LOCKR_KK
LOCKR_CORRESPONDENCE_DUNNING Lock Reason LOCKR_KK
Master Data Relations Join Conditions
Alternative Dunning Recipient
  • Client
  • Alternative Dunning Recipient
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
  • CRMS4_IU_C_CAP.ABWMA == BUT000.PARTNER
Alternative Payee
  • Alternative Payee
  • Client
  • CRMS4_IU_C_CAP.ABWRA == BUT000.PARTNER
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
Alternative Payer
  • Alternative Payer
  • Client
  • CRMS4_IU_C_CAP.ABWRE == BUT000.PARTNER
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
Alternative Invoice Recipient
  • Client
  • Alternative Invoice Recipient
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
  • CRMS4_IU_C_CAP.ABWRH == BUT000.PARTNER
Alternative Contract Account for Collective Bills
  • Client
  • Alternative Contract Account for Collective Bills
  • CRMS4_IU_C_CAP.MANDT == FKKVK.MANDT
  • CRMS4_IU_C_CAP.ABWVK == FKKVK.VKONT
Authorization Group
  • ?
  • Authorization Group
  • Client
  • CRMS4_IU_C_CAP.[column in domain "BGOBJ_KK"] == TFK_BEGRU.BGOBJ
  • CRMS4_IU_C_CAP.BEGRU == TFK_BEGRU.BEGRU
  • CRMS4_IU_C_CAP.MANDT == TFK_BEGRU.CLIENT
Business Place
  • ?
  • Business Place
  • Client
  • Standard Company Code
  • CRMS4_IU_C_CAP.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • CRMS4_IU_C_CAP.BUPLA == J_1BBRANCH.BRANCH
  • CRMS4_IU_C_CAP.MANDT == J_1BBRANCH.MANDT
  • CRMS4_IU_C_CAP.STDBK == J_1BBRANCH.BUKRS
Collection Management: Master Data Group
  • Collection Management: Master Data Group
  • Client
  • CRMS4_IU_C_CAP.CMGRP == TFK041B.CMGRP
  • CRMS4_IU_C_CAP.MANDT == TFK041B.MANDT
Correspondence Variant
  • Client
  • Correspondence Variant
  • CRMS4_IU_C_CAP.MANDT == TFK070B.MANDT
  • CRMS4_IU_C_CAP.COPRC == TFK070B.COPRC
County Code
  • ?
  • County Code
  • Client
  • Region (State, Province, County)
  • CRMS4_IU_C_CAP.[column in domain "LAND1"] == T005E.LAND1
  • CRMS4_IU_C_CAP.COUNTY == T005E.COUNC
  • CRMS4_IU_C_CAP.MANDT == T005E.MANDT
  • CRMS4_IU_C_CAP.PROVINCE == T005E.REGIO
Collections Contact Person
  • Collections Contact Person
  • Client
  • CRMS4_IU_C_CAP.CPERS == BUT000.PARTNER
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
Currency of Direct Debit Limit
  • Client
  • Currency of Direct Debit Limit
  • CRMS4_IU_C_CAP.MANDT == TCURC.MANDT
  • CRMS4_IU_C_CAP.DDLCU == TCURC.WAERS
Alternative Correspondence Recipient for Standard Case
  • Alternative Correspondence Recipient for Standard Case
  • Client
  • CRMS4_IU_C_CAP.DEF_REC == BUT000.PARTNER
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
FI-CA correspondence - activity key
  • Client
  • FI-CA correspondence - activity key
  • CRMS4_IU_C_CAP.MANDT == TFK070L.MANDT
  • CRMS4_IU_C_CAP.DEF_REC_IND == TFK070L.CORR_ACKEY
Planning Group
  • Planning Group
  • Client
  • CRMS4_IU_C_CAP.FDGRP == T035.GRUPP
  • CRMS4_IU_C_CAP.MANDT == T035.MANDT
Tax type
  • Tax type
  • Client
Business Partner Number
  • Business Partner Number
  • Client
  • CRMS4_IU_C_CAP.GPART == BUT000.PARTNER
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
Business Partner for Posting of the Invoice
  • Business Partner for Posting of the Invoice
  • Client
  • CRMS4_IU_C_CAP.GPART_INV == BUT000.PARTNER
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
Recipient of Invoicing List
  • Client
  • Recipient of Invoicing List
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
  • CRMS4_IU_C_CAP.GPART_INVLIST == BUT000.PARTNER
BP Acting as Payer/Payee in Payment Transactions
  • Client
  • BP Acting as Payer/Payee in Payment Transactions
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
  • CRMS4_IU_C_CAP.GPARV == BUT000.PARTNER
Business Area
  • Client
  • Business Area
  • CRMS4_IU_C_CAP.MANDT == TGSB.MANDT
  • CRMS4_IU_C_CAP.GSBER == TGSB.GSBER
Interest Key
  • Interest Key
  • Client
  • CRMS4_IU_C_CAP.IKEY == TFK056A.IKEY
  • CRMS4_IU_C_CAP.MANDT == TFK056A.MANDT
Invoicing Category
  • Client
  • Invoicing Category
  • CRMS4_IU_C_CAP.MANDT == TFK2604.MANDT
  • CRMS4_IU_C_CAP.INV_CATEGORY == TFK2604.INV_CATEGORY
Target Currency of Invoicing
  • Client
  • Target Currency of Invoicing
  • CRMS4_IU_C_CAP.MANDT == TCURC.MANDT
  • CRMS4_IU_C_CAP.INV_CURR == TCURC.WAERS
Billing Cycle
  • Billing Cycle
  • Client
  • CRMS4_IU_C_CAP.INV_CYCLE == TFK2607.CYCLE
  • CRMS4_IU_C_CAP.MANDT == TFK2607.MANDT
Determination Characteristic for Alternative Invoice Form
  • Determination Characteristic for Alternative Invoice Form
  • Client
  • CRMS4_IU_C_CAP.INV_FORM_DET_KEY == TFK2681.FORM_DET_KEY
  • CRMS4_IU_C_CAP.MANDT == TFK2681.MANDT
Selection Characteristic for Scheduling
  • Client
  • Selection Characteristic for Scheduling
  • CRMS4_IU_C_CAP.MANDT == TFK2606.MANDT
  • CRMS4_IU_C_CAP.INV_SCHEDULE == TFK2606.INV_SCHEDULE
Country/Region Key
  • Country/Region Key
  • Client
  • CRMS4_IU_C_CAP.LAND1 == T005.LAND1
  • CRMS4_IU_C_CAP.MANDT == T005.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • CRMS4_IU_C_CAP.LANDL == T005.LAND1
  • CRMS4_IU_C_CAP.MANDT == T005.MANDT
Dunning Procedure
  • Dunning Procedure
  • Client
  • CRMS4_IU_C_CAP.MAHNV == TFK047A.MAHNV
  • CRMS4_IU_C_CAP.MANDT == TFK047A.MANDT
Grouping fur Dunning Notices
  • Client
  • Grouping fur Dunning Notices
  • CRMS4_IU_C_CAP.MANDT == TFK047F.MANDT
  • CRMS4_IU_C_CAP.MGRUP == TFK047F.MGRUP
Company Code Group
  • Client
  • Company Code Group
  • CRMS4_IU_C_CAP.MANDT == TFK001G.MANDT
  • CRMS4_IU_C_CAP.OPBUK == TFK001G.OPBUK
Clerk Responsible
  • Client
  • Clerk Responsible
  • CRMS4_IU_C_CAP.MANDT == BUT000.CLIENT
  • CRMS4_IU_C_CAP.PERSR == BUT000.PARTNER
Region (State, Province, County)
  • ?
  • Client
  • Region (State, Province, County)
  • CRMS4_IU_C_CAP.[column in domain "LAND1"] == T005S.LAND1
  • CRMS4_IU_C_CAP.MANDT == T005S.MANDT
  • CRMS4_IU_C_CAP.PROVINCE == T005S.BLAND
Partner Settlement Rule
  • Client
  • Partner Settlement Rule
Company Code for Automatic Payment Transactions
  • Client
  • Company Code for Automatic Payment Transactions
  • CRMS4_IU_C_CAP.MANDT == T001.MANDT
  • CRMS4_IU_C_CAP.PYBUK == T001.BUKRS
Witholding Tax Code For Outgoing Payments
  • ?
  • Client
  • Witholding Tax Code For Outgoing Payments
  • CRMS4_IU_C_CAP.[column in domain "LAND1"] == T059Q.LAND1
  • CRMS4_IU_C_CAP.MANDT == T059Q.MANDT
  • CRMS4_IU_C_CAP.QSSKZ_A == T059Q.QSSKZ
Withholding Tax Code For Incoming Payments
  • ?
  • Withholding Tax Code For Incoming Payments
  • Client
  • CRMS4_IU_C_CAP.[column in domain "LAND1"] == T059Q.LAND1
  • CRMS4_IU_C_CAP.QSSKZ_E == T059Q.QSSKZ
  • CRMS4_IU_C_CAP.MANDT == T059Q.MANDT
Collection Strategy
  • Client
  • Collection Strategy
  • CRMS4_IU_C_CAP.MANDT == TFK047X.MANDT
  • CRMS4_IU_C_CAP.STRAT == TFK047X.STRAT
Tolerance group for contract account
  • Client
  • Tolerance group for contract account
  • CRMS4_IU_C_CAP.MANDT == TFK043.MANDT
  • CRMS4_IU_C_CAP.TOGRU == TFK043.TOGRU
Clearing Category For Clearing Postings
  • Clearing Category For Clearing Postings
  • Client
  • CRMS4_IU_C_CAP.VERTYP == TFK111.VERTYP
  • CRMS4_IU_C_CAP.MANDT == TFK111.MANDT
Contract Account
  • Client
  • Contract Account
  • CRMS4_IU_C_CAP.MANDT == FKKVK.MANDT
  • CRMS4_IU_C_CAP.VKONT == FKKVK.VKONT
Contract Account of Invoice Recipient
  • Client
  • Contract Account of Invoice Recipient
  • CRMS4_IU_C_CAP.MANDT == FKKVK.MANDT
  • CRMS4_IU_C_CAP.VKONT_INV == FKKVK.VKONT
Contract Account of Recipient of Invoicing List
  • Contract Account of Recipient of Invoicing List
  • Client
  • CRMS4_IU_C_CAP.VKONT_INVLIST == FKKVK.VKONT
  • CRMS4_IU_C_CAP.MANDT == FKKVK.MANDT
Contract account used for payment transactions
  • Client
  • Contract account used for payment transactions
  • CRMS4_IU_C_CAP.MANDT == FKKVK.MANDT
  • CRMS4_IU_C_CAP.VKONV == FKKVK.VKONT
Business partner account relationship
  • Client
  • Relationship of Business Partner to Contract Account
  • CRMS4_IU_C_CAP.MANDT == TFK002F.MANDT
  • CRMS4_IU_C_CAP.VKPBZ == TFK002F.VKPBZ
Check table
  • Contract Account Category
  • Client
  • Application Area
  • CRMS4_IU_C_CAP.VKTYP == TFK002A.VKTYP
  • CRMS4_IU_C_CAP.MANDT == TFK002A.MANDT
  • CRMS4_IU_C_CAP.APPLK == TFK002A.APPLK
Payment Condition
  • Payment Condition
  • Client
  • CRMS4_IU_C_CAP.ZAHLKOND == TE052.ZAHLKOND
  • CRMS4_IU_C_CAP.MANDT == TE052.MANDT