C_CAInvcgDocItem

Invoicing Document Item | view: CCAINVDOC_I | TRAN | Extraction: Not supported | Component: Convergent Invoicing
Tables used: DFKKINVDOC_H, DFKKINVDOC_I, TGSB, TGSBT, TFK8117, TFK8117T, TFK2715, TFK2715T, TFK2608, TFK2608T, TFK2608C, TFK2608CT, TFK2601, TFK2601T, TFK2605, TFK2605T, TFK2605C, TFK2605CT, TFKHVO, TFKHVOT, TFK007F, TFK007FT, TFK_RA_SERVTYP, TFK_RA_SERVTYP_T, TFKTVO, TFKTVOT, T001, TKA02, T685, T685T, T005, T005T, TSPA, TSPAT, T007A, T007S, TTXJ, TTXJT, T006, T006A, TFK000, TFK000P
Column Name Description
CAInvoicingDocument Number of Invoicing Document
CAInvcgDocItem Sequential Number of Document Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
CATaxBaseAmount Amount Subject to Tax in Transaction Currency (Tax Base Amt)
CATaxAmountInTransCurrency Tax Amount in Transaction Currency with +/- Sign
CATaxPortionInTransCurrency Tax Amount as Statistical Information in Document Currency
CAClearingAmountInTransCrcy Clearing Amount in Transaction Currency (With +/- Sign)
💲 Currency of Source Document (CACurrencySourceDocument):
CAInvcgSourceDocumentAmount Amount in Source Document Currency
Column Name Description
📏 Base Unit of Measure (UnitOfMeasure):
Quantity Quantity
Column Name Description
CANetDueDate Due date for net payment
CATaxDate Decisive Date for Calculating Taxes
CACashDiscountDueDate Due Date for Cash Discount
CAItemPeriodStartDate Start of Period of Line Item
CAItemPeriodEndDate End of Period of Line Item
Column Name Description
CAIsDocItemSimulated Line Item Is Simulated Show values
CAInvcgIsItemPostingRelevant Posting-Relevant Line Item Show values
CAInvcgIsItemPrintingRelevant Line Item Is Relevant for Printing Show values
CAInvcgIsInFinalAmt Consider Items In Invoice Final Amount Show values
CATaxIsIncluded Tax Included in Amount Show values
CASubApplication Subapplication in Contract Accounts Receivable and Payable Show values
CAInvcgDocItmAltvMDCat Category of Alternative Master Data for Invoicing Item Show values
CAInvcgDocItemIsReversal Reversal Item Show values
CAInvcgIsNotBPRelevant Not Relevant for Business Partner Items Show values
CATaxDetnType Type of Tax Calculation Show values
CATransactionKeyAccountDetn Transaction key for account determination Show values
CAIsDownPaymentRequest Item is a Down Payment/Down Payment Request Show values
CAStatisticalItemCode Type of statistical item Show values
CAInvcgDfrrdRevenueStatus Status of Processing of Deferred Revenues Show values
CAIsRevenueAccountingRelevant Relevant for Revenue Accounting Show values
CAIsPrepaid Prepaid Show values
CAInvcgDocItemDefStatus Item Deferred until Due Date for Invoice Show values
CAInvcgDocItemCrtnMethod Creation Method of Invoicing Document Item Show values
CAInvcgDocItemSourceItmCat Category of Source Document Item Invoiced Show values
CAApplicationArea Application Area Show values
CAInvcgCorrectionCategory Category of Invoice Correction Show values
Column Name Description Domain name
CAContract Reference Specifications from Contract VTREF_KK
CAContractSemanticObject Semantic Object for Contract TEXT30
CAInvcgTaxGroupingKey Grouping Key for Tax Display
CATaxRateInPercent Tax Percentage TAX_PERC_KK
TaxCountry Tax Reporting Country/Region LAND1
CAProviderContractItemNumber Contract: Item Number VTPOS_KK
CAInvcgItmAltvBusinessPartner Alternative Business Partner of Invoicing Item BU_PARTNER
CAInvcgItmAltvContractAccount Alternative Contract Account of Invoicing item VKONT_KK
CAInvcgSubstituteGroupPrinting Substitute Group for Invoice Printing
CAGroupingCurrencyTranslation Grouping for Currency Translation
CAAccountDeterminationCode Account Determination ID KOFIZ_KK
BusinessPlace Business Place J_1BBRANCH
TaxJurisdiction Tax Jurisdiction TXJCD
CAConditionType Condition Type KSCHL
WithholdingTaxCode Withholding Tax Code QSSKZ
CAInvcgOffsettingGroup Grouping of Offsetting Items
CAInvcgRevenueGrouping Revenue Grouping of Invoicing
CARevenueAccountingServiceType Service Type for Revenue Accounting RAI_SERVICE_TYPE_KK
CAInvcgAccrualPostingType Type of Accrual/Deferral Posting - Individual Procedure BILLAC_TYPE_KK
CACashDiscountRate Cash Discount Percentage Rate PRZ23
CADocumentNumber Document OPBEL_KK
CAGroupingKeyDocumentItems Grouping Key for Document Items CHAR4
CAInvcgGroupingKey Grouping Key for Invoicing CHAR4
CAClearingDocumentNumber Clearing Document or Printed Document AUGBL_KK
CAInvcgSourceDocumentNumber Number of Source Document to Be Invoiced SRCDOCNO_KK
CAInvcgSourceDocumentSemObj Semantic Object TEXT30
CAInvcgSourceDocumentItem Item of Invoiced Source Document SRCDOCITEM_KK
CABllbleItmDiscountVersion Version Number of Disccount on Billable Items
TaxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
CompanyCodeName Name of Company Code or Company TEXT25
CAMainTransactionName Name of Main Transaction TEXT30
CASubTransactionName Name of Subtransaction TEXT30
CAInvcgDocItemTypeText Name of Invoicing Item Type TEXT50
CASubApplicationText Description (250 Characters)
DivisionName Division Description TEXT20
CAInvcgDocItmAltvMDCatText Description (250 Characters)
BusinessAreaName Business Area Description TEXT30
TaxCountryName Country/Region Name TEXT50
CATaxDetnTypeText Description (250 Characters)
CAOtherTaxCodeName Free Tax Code (Text) TXT50
TaxCodeName Tax Code Name TEXT50
TaxJurisdictionName Description TEXT50
ConditionTypeName Description TEXT30
CATransactionKeyAcctDetnText Description (250 Characters)
CADeferredRevenueStatusText Description (250 Characters)
CAInvcgDocItmDefStatusText Description (250 Characters)
CARevnAcctgServiceTypeText Name of Service Types for Revenue Accounting Item TEXT50_KK
CAInvcgAccrualPostingTypeTxt Description of Accrual/Deferral Posting Type TEXT50
CAInvcgRefPostgDocTypeTxt Name of Reference Document Type of Posting Document TEXT50
CAInvcgDocItmCrtnMethodText Description (250 Characters)
CAInvcgFunctionText Name of Invoicing Function TEXT60
CAInvcgSourceDocCatText Text Field TEXT50
CAInvcgDocItmSrceItmCatText Description (250 Characters)
CABllbleItmDiscountKeyText Name of Discount/Charge Key DISC_DESCR_KK
UnitOfMeasureName Unit of Measurement Text (Maximum 10 Characters) TEXT10
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • C_CAINVCGDOCITEM.MANDT == TGSB.MANDT
  • C_CAINVCGDOCITEM.BUSINESSAREA == TGSB.GSBER
Discount/Charge Key
  • Client
  • Discount/Charge Key
  • C_CAINVCGDOCITEM.MANDT == TFK8117.MANDT
  • C_CAINVCGDOCITEM.CABLLBLEITMDISCOUNTKEY == TFK8117.DISCKEY
Type of Invoicing Item
  • Type of Invoicing Item
  • Client
  • C_CAINVCGDOCITEM.CAINVCGDOCUMENTITEMTYPE == TFK2608.ITEMTYPE
  • C_CAINVCGDOCITEM.MANDT == TFK2608.MANDT
Invoicing Function C_CAINVCGDOCITEM.CAINVCGFUNCTION == TFK2601.INV_FUNCTION
Reference Document Type of Posting Document for Invoicing C_CAINVCGDOCITEM.CAINVCGREFPOSTINGDOCTYPE == TFK2605.CADOCTYPE
Category of Source Document To Be Invoiced C_CAINVCGDOCITEM.CAINVCGSOURCEDOCUMENTCAT == TFK2605C.SRCDOCCAT
Main Transaction for Line Item
  • ?
  • Main Transaction for Line Item
  • Client
  • C_CAINVCGDOCITEM.[column in domain "APPLK_KK"] == TFKHVO.APPLK
  • C_CAINVCGDOCITEM.CAMAINTRANSACTION == TFKHVO.HVORG
  • C_CAINVCGDOCITEM.MANDT == TFKHVO.MANDT
Tax Code for Other Taxes
  • ?
  • Client
  • Tax Code for Other Taxes
  • C_CAINVCGDOCITEM.[column in domain "LAND"] == TFK007F.LAND
  • C_CAINVCGDOCITEM.MANDT == TFK007F.MANDT
  • C_CAINVCGDOCITEM.CAOTHERTAXCODE == TFK007F.STRKZ
Subtransaction for Document Item
  • ?
  • Main Transaction for Line Item
  • Client
  • Subtransaction for Document Item
  • C_CAINVCGDOCITEM.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • C_CAINVCGDOCITEM.CAMAINTRANSACTION == TFKTVO.HVORG
  • C_CAINVCGDOCITEM.MANDT == TFKTVO.MANDT
  • C_CAINVCGDOCITEM.CASUBTRANSACTION == TFKTVO.TVORG
Company Code
  • Company Code
  • Client
  • C_CAINVCGDOCITEM.COMPANYCODE == T001.BUKRS
  • C_CAINVCGDOCITEM.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_CAINVCGDOCITEM.COMPANYCODECOUNTRY == T005.LAND1
  • C_CAINVCGDOCITEM.MANDT == T005.MANDT
Division
  • Client
  • Division
  • C_CAINVCGDOCITEM.MANDT == TSPA.MANDT
  • C_CAINVCGDOCITEM.DIVISION == TSPA.SPART
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • C_CAINVCGDOCITEM.TAXCODE == T007A.MWSKZ
  • C_CAINVCGDOCITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • C_CAINVCGDOCITEM.MANDT == T007A.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • C_CAINVCGDOCITEM.MANDT == TCURC.MANDT
  • C_CAINVCGDOCITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Indicator: Tax Determination Code
  • ?
  • ?
  • Client
  • Indicator: Tax Determination Code
  • C_CAINVCGDOCITEM.[column in domain "ABZEITSCH"] == TE011.AB
  • C_CAINVCGDOCITEM.[column in domain "LAND1"] == TE011.LAND1
  • C_CAINVCGDOCITEM.MANDT == TE011.MANDT
  • C_CAINVCGDOCITEM.CATAXDETERMINATIONCODE == TE011.ERMWSKZ