I_CADocumentBPItemPhysical

BP Document Item: Physical View | view: ICADOCBPITEMPHYS | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKOPT001TKA02T005
Column Name Description
CADocumentNumber Number of a FI-CA Document
CARepetitionItemNumber Repetition Item in FI-CA Document
CABPItemNumber Item Number in FI-CA Document
CASubItemNumber Subitem for a Partial Clearing in Document
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
CAAmountInLocalCurrency Amount In Local Currency With +/- Signs
CAAmountInSecondCurrency Amount in Second Parallel Currency with +/- Sign
CAAmountInThirdCurrency Amount in Third Parallel Currency with +/- Sign
CATaxAmountInLocalCurrency Tax Amount in Local Currency With +/- Sign
CATaxAmountInSecondCurrency Tax Amount in Second Parallel Currency
CATaxAmountInThirdCurrency Tax Amount in Third Parallel Currency
CATaxPortionInLocalCurrency Tax Portion in FI-CA Local Currency
💲 Transaction Currency (TransactionCurrency):
CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
CAEligibleAmountForCshDiscount Amount Eligible for Cash Discount in Document Currency
CATaxAmountInTransCurrency Tax Amount in Transaction Currency with +/- Sign
CABaseAmountForWithholdingTax Tax Base Amount
CAWithholdingTaxAmount Withholding Tax Amount (in Document Currency)
CATaxPortionInTransCurrency Tax Amount as Statistical Information in Document Currency
PlannedAmtInTransactionCrcy Planned Amount in Transaction Currency
💲 Clearing Currency (CAClearingCurrency):
CAClearingAmountInClearingCrcy Clearing amount in clearing currency
CATaxAmountInClearingCrcy Tax Amount in Clearing Currency
CACashDiscAmountInClearingCrcy Cash Discount Granted/Surcharge Levied in Clearing Currency
💲 Update Currency for General Ledger Transaction Figures (CAGLPostingCurrency):
CAGLPostingAmount Amount for Updating in General Ledger
CAGLPostingTaxAmount Tax Amount for Update in General Ledger
Column Name Description
Column Name Description
CAStartDateOfBillingPeriod Lower Limit of Billing Period
CAEndDateOfBillingPeriod Upper Limit of the Billing Period
DocumentDate Journal Entry Date
CAPostingDate Posting Date in the Document
CANetDueDate Due date for net payment
CADeferralDate Deferral to
CACashDiscountDueDate Due Date for Cash Discount
CATaxDate Decisive Date for Calculating Taxes
CAClearingDate Clearing Date
CAPostingDateOfClearingDoc Clearing Document Posting Date
CAValueDateForClearing Value date for clearing
CASEPAPreNotifExecutionDate SEPA: Date of Execution of Direct Debit Pre-Notifcation
Column Name Description
CASubApplication Subapplication in Contract Accounts Receivable and Payable Show values
CAApplicationArea Application Area Show values
CADoubtfulOrValueAdjmtCode Doubtful Item Entry/Individual Value Adjustment Show values
CAIsDownPaymentRequest Item is a Down Payment/Down Payment Request Show values
CAItemIsOnlyForSettlement Item Can Only Be Cleared Show values
CAStatisticalItemCode Type of statistical item Show values
CAChangeIsForbidden Printing - No Changes Possible Show values
CARoundingItemCode Type of Rounding Item Show values
CAInternalPostingReasonCode Reason for Automatic Creation of Posting Show values
CAWorkflowCheckProcess Editing Process To Be Confirmed Show values
CANegativePostingControlCode Control Field for Negative Posting Show values
CAPartnerSettlementStatus Status of Partner Settlement Using Billable Items Show values
CAIsPartOfJointLiability Item Is Part of a Collaborative Liability Show values
CASubstituteDocumentCategory Category of Substitute Document in FI-CA Show values
CAStatisticalCodeOfOriginItem Statistical Key of the Initiating Item Show values
ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation Show values
CAWithholdingTaxCategory Line Item Category From Withholding Tax View Show values
CATaxIsCalculatedExternally Tax on Sales/Purchases Was Calculated by Document Show values
CATaxAmountIsSetFromExternal Internal Tax Characteristic for Tax Handling Show values
CAPaymentSpecificationCategory Category of Payment Specification Show values
CAClearingStatus Clearing Status Show values
CAClearingRestrictionCode Clearing restriction Show values
CAClearingPostingIsReset Clearing posting reversed Show values
CAItemIsWithdrawn Item Canceled Show values
CAItemIsExcludedFromDunning Exclude Item from Dunning Run Show values
CAIsIncludedInCollectionCase Item Is Included in Collection Case Show values
CAIsSeparateLineItemInGL Create Line Item in General Ledger Show values
CAIsCashFlowItem Document Contains Assignments from Cash Flows Show values
CAPaymentPreNotificationCode Item Included in a Payment Order Show values
CASEPAPreNotifOriginCode SEPA: Origin of Direct Debit Pre-Notification Show values
CASEPAPreNotificationRqmtCode SEPA: Requirement for a Pre-Notification Show values
CARevenueDistrCurrentStatus Current Distribution Status Show values
CARevenueDistrLastStatus Last Distribution Status Reported Show values
CACurrentFactoringStatusOfRbl Factoring: Current Status of Receivable Show values
CAFactoringCheckStsForClrgInfo Factoring: Check Status for Clearing Information Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
BusinessArea Business Area GSBER
Segment Segment for Segmental Reporting FB_SEGMENT
ProfitCenter Profit Center PRCTR
Division Division SPART
PersonnelNumber Personnel Number PERNR
PartnerCompany Company ID of Trading Partner RCOMP
BusinessPartner Business Partner Number BU_PARTNER
CAContract Reference Specifications from Contract VTREF_KK
CAProviderContractItemNumber Contract: Item Number VTPOS_KK
CAAdditionalContract Additional Reference Information VTREF_KK
ContractAccount Contract Account VKONT_KK
AltvContractAcctForCollvBills Alternative Contract Account for Collective Bills VKONT_KK
CAReconciliationAccount General ledger account SAKNR
CAMainTransaction Main Transaction for Line Item HVORG_KK
CASubTransaction Subtransaction for Document Item TVORG_KK
CAAccountDeterminationCode Account Determination ID KOFIZ_KK
CAAccountAssignmentCategory Account Assignment Category KONTT_KK
CAAccountAssignment Acct assnmnt string for industry-specific account assngments CHAR50
CADocumentType Document Type BLART_KK
CABPItemText Item text TEXT50
CANumberOfRepetitionItems Number of repetition items NUM03
CAGroupingCodeForBPItems Grouping Key for Displaying Open Items CHAR3
CAPeriodCode Key for Period Assignment PERSL_KK
CAInterestCode Interest Key IKEY_KK
CAReceivingCountry Destination Country/Region (for Tax Reports) LAND1
CAWorkflowCheckReason Check Reason for Workflows Acc. to Dual Control Principle C4EYE_KK
CADocumentOriginCode Document Origin Key HERKF_KK
CASubstituteDocumentNumber Number of the Substitute FI-CA Document ABWBL_KK
CADocumentNumberOfOriginItem Number of Triggering Document OPBEL_KK
CAReferenceDocument Reference document number XBLNR_KK
CAExchangeRate Absolute Exchange Rate FIS_UKURS
CACashDiscountRate Cash Discount Percentage Rate PRZ23
TaxCode Tax on Sales/Purchases Code MWSKZ
CASupplementaryTaxCode Supplementary Tax MWSKZ
CADownPaymentTaxAccount Account for posting taxes for down payments SAKNR
CADownPaymentOffsetTaxAccount Account for offsetting tax posting in down payments SAKNR
TaxJurisdiction Tax Jurisdiction TXJCD
WithholdingTaxCode Withholding Tax Code QSSKZ
CAWithholdingTaxSupplement Withholding Tax Supplement QSSEW_KK
CAWithholdingTaxPercentage Withholding Tax Percentage STPRZ_KK
WithholdingTaxCertificate Withholding Tax Certificate CHAR10
CAOtherTaxCode Tax Code for Other Taxes STRKZ_KK
CAGroupingCodeForTaxItems Grouping Key for Tax Items CHAR6
CAPaymentMethod Payment Method PYMET_KK
CAGroupingForPayment Grouping field for automatic payments CHAR10
CAClearingDocumentNumber Clearing Document or Printed Document AUGBL_KK
CAClearingReason Clearing Reason AUGRD_KK
CADunningProcedure Dunning Procedure MAHNV_KK
CAGrpgCodeForTransfToCollAgcy Collection Item NUM03
CashPlanningGroup Planning Group FDGRP
PlanningLevel Planning Level FDLEV
CAAdditionalDaysForCashMgmt Additional Days for Cash Management NUM2
CAAltvBPForPayment Alternative Business Partner for Payments BU_PARTNER
CABankOfAltvBPForPayment Bank Details ID of Payee CHAR4
CAAddressOfAltvBPForPayment Address Number AD_ADDRNUM
CACardOfAltvBPForPayment Alternative Payment Card ID in Document CHAR6
CACashFlowAccount Originating Account in Cash Flow Anlaysis SAKNR
CACashFlowCompanyCode Partner Company Code for Cash Flow Analysis BUKRS
CASEPAPreNotificationNumber SEPA: Number of Direct Debit Pre-Notification PNNUM_KK
CARevenueDistrFinalRecipient Contract Account of Final Recipient VKONT_KK
CAFactoringItem Subitems in Factoring OPUPZ_KK
SEPAMandateCAInternalID SEPA Mandate Identifier NUM06
Master Data Relations Join Conditions
Business Place
  • Company Code
  • Business Place
  • ?
  • Client
  • I_CADOCUMENTBPITEMPHYSICAL.COMPANYCODE == J_1BBRANCH.BUKRS
  • I_CADOCUMENTBPITEMPHYSICAL.BUSINESSPLACE == J_1BBRANCH.BRANCH
  • I_CADOCUMENTBPITEMPHYSICAL.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • I_CADOCUMENTBPITEMPHYSICAL.MANDT == J_1BBRANCH.MANDT
Company Code for Automatic Payment Transactions
  • Client
  • Company Code for Automatic Payment Transactions
  • I_CADOCUMENTBPITEMPHYSICAL.MANDT == T001.MANDT
  • I_CADOCUMENTBPITEMPHYSICAL.CAPAYMENTCOMPANYCODE == T001.BUKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_CADOCUMENTBPITEMPHYSICAL.CHARTOFACCOUNTS == T004.KTOPL
  • I_CADOCUMENTBPITEMPHYSICAL.MANDT == T004.MANDT
Company Code Currency
  • Company Code Currency
  • Transaction Currency
  • Client
  • I_CADOCUMENTBPITEMPHYSICAL.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CADOCUMENTBPITEMPHYSICAL.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CADOCUMENTBPITEMPHYSICAL.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_CADOCUMENTBPITEMPHYSICAL.CONTROLLINGAREA == TKA01.KOKRS
  • I_CADOCUMENTBPITEMPHYSICAL.MANDT == TKA01.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_CADOCUMENTBPITEMPHYSICAL.MANDT == T005.MANDT
  • I_CADOCUMENTBPITEMPHYSICAL.COUNTRY == T005.LAND1
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • I_CADOCUMENTBPITEMPHYSICAL.[column in domain "KVEWE"] == T683.KVEWE
  • I_CADOCUMENTBPITEMPHYSICAL.[column in domain "KAPPL"] == T683.KAPPL
  • I_CADOCUMENTBPITEMPHYSICAL.MANDT == T683.MANDT
  • I_CADOCUMENTBPITEMPHYSICAL.TAXCALCULATIONPROCEDURE == T683.KALSM