C_VE_StRpPurAndWhldgTxItmC

Venezuela Purchase VAT and Withholding Tax Items Cube | view: CVEPURTAXITEMC | TRAN | Extraction: Not supported | Component: Financials Venezuela
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TransactionTypeDetermination Transaction Key
TaxCode FK Tax on sales/purchases code
AccountingDocumentItem null
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TaxRate Tax Rate
ForeignWhldgTaxAmount null
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
TotalAmountInDisplayCrcy null
BaseAmtWithoutTxInCCCrcy null
WhldgTaxAmtInCoCodeCrcy Withholding Tax Amount in Local Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
Column Name Description
FinancialAccountType Account Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
Column Name Description Domain name
VATRegistration VAT Registration Number STCEG
IPITaxRate Field of length 16 CHAR16
Supplier null
TaxNumber1 null
BusinessPartnerName Name 1 TEXT40
CustomerOrSupplierType null
PurchaseImportForm null
ImportCustomsDeclnDocNmbr null
TaxInvoiceNumber null
DebitMemo null
CreditMemo null
WithholdingTaxCertificate Withholding Tax Certificate Number CHAR10
LinkedDocumentNumber null
BusinessPartnerIsForeign null
BusinessTransactionType null
NFInvoiceNumber Reference Document Number XBLNR
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceReferenceFiscalYear Fiscal Year GJAHR
DocumentReferenceID Document Reference ID XBLNR1
AccountingDocumentHeaderText Document Header Text TEXT25
AmendmentTaxInvoiceNumber Reference Document Number XBLNR
IsDebitBalanceRelevant null
IsCreditBalanceRelevant null
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
ReversalReferenceDocumentCntxt Reversal: Reference Organizations of Document to Be Reversed AWORG
ReversalReferenceDocument Reversal: Reference Document No. of Document to Be Reversed AWREF
ReverseDocument Reverse Document Number BELNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • C_VE_STRPPURANDWHLDGTXITMC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMC.CADOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMC.MANDT == T003.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_VE_STRPPURANDWHLDGTXITMC.MANDT == T005.MANDT
  • C_VE_STRPPURANDWHLDGTXITMC.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMC.COUNTRY == T005.LAND1
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • C_VE_STRPPURANDWHLDGTXITMC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMC.CADOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMC.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • C_VE_STRPPURANDWHLDGTXITMC.MANDT == T001.MANDT
  • C_VE_STRPPURANDWHLDGTXITMC.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_VE_STRPPURANDWHLDGTXITMC.MANDT == TCURC.MANDT
  • C_VE_STRPPURANDWHLDGTXITMC.COMPANYCODECURRENCY == TCURC.WAERS
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_VE_STRPPURANDWHLDGTXITMC.MANDT == T005.MANDT
  • C_VE_STRPPURANDWHLDGTXITMC.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMC.COUNTRY == T005.LAND1
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • C_VE_STRPPURANDWHLDGTXITMC.MANDT == T007A.MANDT
  • C_VE_STRPPURANDWHLDGTXITMC.TAXCODE == T007A.MWSKZ
  • C_VE_STRPPURANDWHLDGTXITMC.[column in domain "KALSM_D"] == T007A.KALSM