C_VE_StRpPurAndWhldgTxItmLogC

Venezuela Pur and Whldg Tax Items with Rptd Item log Cube | view: CVEPURTAXITEMLGC | 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 Number of Tax Line Item
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
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 Document Header Text TEXT25
ImportCustomsDeclnDocNmbr Document Header Text TEXT25
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
SenderLogicalSystem Sender Logical System LOGSYS
SenderCompanyCode Company Code in Sender System CHAR4
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • C_VE_STRPPURANDWHLDGTXITMLOGC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMLOGC.CADOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMLOGC.MANDT == T003.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_VE_STRPPURANDWHLDGTXITMLOGC.COUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMLOGC.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMLOGC.MANDT == T005.MANDT
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • C_VE_STRPPURANDWHLDGTXITMLOGC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMLOGC.CADOCUMENTTYPE == T003.BLART
  • C_VE_STRPPURANDWHLDGTXITMLOGC.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • C_VE_STRPPURANDWHLDGTXITMLOGC.COMPANYCODE == T001.BUKRS
  • C_VE_STRPPURANDWHLDGTXITMLOGC.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_VE_STRPPURANDWHLDGTXITMLOGC.COMPANYCODECURRENCY == TCURC.WAERS
  • C_VE_STRPPURANDWHLDGTXITMLOGC.MANDT == TCURC.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_VE_STRPPURANDWHLDGTXITMLOGC.COUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMLOGC.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_VE_STRPPURANDWHLDGTXITMLOGC.MANDT == T005.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • C_VE_STRPPURANDWHLDGTXITMLOGC.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_VE_STRPPURANDWHLDGTXITMLOGC.MANDT == SRF_RPG_ENT.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • C_VE_STRPPURANDWHLDGTXITMLOGC.[column in domain "KALSM_D"] == T007A.KALSM
  • C_VE_STRPPURANDWHLDGTXITMLOGC.TAXCODE == T007A.MWSKZ
  • C_VE_STRPPURANDWHLDGTXITMLOGC.MANDT == T007A.MANDT