C_VE_StRpPurAndWhldgTxItmQ

Analytical Query for VE Purchase Tax Item | view: CVEPURTAXITEMQ | Extraction: Not supported | Component: Financials Venezuela
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TransactionTypeDetermination Transaction Key
TaxCode Tax on sales/purchases code
AccountingDocumentItem null
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TaxRate Tax Rate
ForeignWhldgTaxAmount null
BaseAmtWithoutTxInCCCrcy null
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
TotalAmountInDisplayCrcy 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
Supplier null
VATRegistration VAT Registration Number STCEG
TaxNumber1 null
BusinessPartnerName Name 1 TEXT40
CustomerOrSupplierType null
PurchaseImportForm null
IPITaxRate Field of length 16 CHAR16
ImportCustomsDeclnDocNmbr null
TaxInvoiceNumber null
BusinessPartnerIsForeign null
DebitMemo null
CreditMemo null
WithholdingTaxCertificate Withholding Tax Certificate Number CHAR10
LinkedDocumentNumber null
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
BusinessTransactionType null
InvoiceReferenceFiscalYear Fiscal Year GJAHR
NFInvoiceNumber Reference Document Number XBLNR
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_STRPPURANDWHLDGTXITMQ.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMQ.CADOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMQ.MANDT == T003.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_VE_STRPPURANDWHLDGTXITMQ.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMQ.COUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMQ.MANDT == T005.MANDT
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • C_VE_STRPPURANDWHLDGTXITMQ.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMQ.CADOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMQ.MANDT == T003.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_VE_STRPPURANDWHLDGTXITMQ.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMQ.COUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMQ.MANDT == T005.MANDT