C_VE_StRpSlsAndWhldgTxItmC

Venezuela Sales VAT and Withholding Tax Items Cube | view: CVESLSTAXITEMC | 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
TaxItem Number of Tax Line Item
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TaxRate Tax Rate
DomesticNonTaxableSalesAmt null
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
WhldgTaxAmtInCoCodeCrcy Withholding Tax Amount in Local Currency
TotalAmountInDisplayCrcy null
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
Column Name Description
TargetSalesDocumentType SD Document Category Show values
PrecedingDocumentCategory Document Category of Preceding SD Document Show values
DefaultDebitCreditCode Debit/Credit Code Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentItem null
IPITaxRate Field of length 16 CHAR16
TaxNumber1 null
BusinessPartnerName Name 1 TEXT40
SalesExportForm null
BusinessPartnerIsForeign null
TaxInvoiceNumber null
ExportControlClassfctnNmbr null
CreditMemo null
DebitMemo null
LinkedDocumentNumber null
BusinessTransactionType null
Supplier null
Customer null
OriginalReferenceDocument Object key AWKEY
DocumentReferenceID Document Reference ID XBLNR1
DocumentType null
TransactionTypeCategory null
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocumentNumber Document No. of the Invoice to Which the Transaction Belongs BELNR
PrecedingDocument Preceding sales and distribution document VBELN
AmendmentTaxInvoiceNumber Reference Document Number XBLNR
NFOverviewInvoiceNumber Object key AWKEY
NFInvoiceNumber Reference Document Number XBLNR
AccountingDocumentHeaderText Document Header Text TEXT25
ReverseDocument Reverse Document Number BELNR
ReversedDocument Reverse Document BELNR
ReferenceAcctgDocumentType Reference Document Type AWTYP
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
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
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • C_VE_STRPSLSANDWHLDGTXITMC.CADOCUMENTTYPE == T003.BLART
  • C_VE_STRPSLSANDWHLDGTXITMC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == T003.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_VE_STRPSLSANDWHLDGTXITMC.COUNTRY == T005.LAND1
  • C_VE_STRPSLSANDWHLDGTXITMC.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == T005.MANDT
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • C_VE_STRPSLSANDWHLDGTXITMC.CADOCUMENTTYPE == T003.BLART
  • C_VE_STRPSLSANDWHLDGTXITMC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • C_VE_STRPSLSANDWHLDGTXITMC.COMPANYCODE == T001.BUKRS
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == TCURC.MANDT
  • C_VE_STRPSLSANDWHLDGTXITMC.COMPANYCODECURRENCY == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_VE_STRPSLSANDWHLDGTXITMC.COUNTRY == T005.LAND1
  • C_VE_STRPSLSANDWHLDGTXITMC.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == T005.MANDT
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • Reason for Reversal or Inverse Posting
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == T041C.MANDT
  • C_VE_STRPSLSANDWHLDGTXITMC.UTILSINVCGDOCREVERSALRSN == T041C.STGRD
  • C_VE_STRPSLSANDWHLDGTXITMC.REVERSALREASON == T041C.STGRD
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • ?
  • C_VE_STRPSLSANDWHLDGTXITMC.TAXCODE == T007A.MWSKZ
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == T007A.MANDT
  • C_VE_STRPSLSANDWHLDGTXITMC.[column in domain "KALSM_D"] == T007A.KALSM
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • Reason for Reversal or Inverse Posting
  • C_VE_STRPSLSANDWHLDGTXITMC.MANDT == T041C.MANDT
  • C_VE_STRPSLSANDWHLDGTXITMC.UTILSINVCGDOCREVERSALRSN == T041C.STGRD
  • C_VE_STRPSLSANDWHLDGTXITMC.REVERSALREASON == T041C.STGRD