I_ID_PricingElementsGroupCube

ID Pricing Element - Cube | view: IIDPRICEGCUBE | TRAN | Extraction: Not supported | Component: Financials Indonesia
Tables used: BKPF, VBRK, VBRP, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, PRCD_ELEMENTS, BKPF, BSEG, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, T005, KNA1, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, T007A, T001, T014, T007B
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
TaxCode Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
TaxBox Tax Box (Adv. Tax Return)
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
UnifiedTaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
TaxGroup Tax Group
BillingDocument Billing Document
BillingDocumentItem Billing Item
Material FK Material Number
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
EligibleAmountForCashDiscount null
NetAmount Net Value of Billing item in Document Currency
TaxBaseAmountInCoCodeCrcy Net Value of Billing item in Document Currency
LuxuryTaxAmt null
TaxAmountInCoCodeCrcy null
Column Name Description
BillingQuantity Actual billed quantity
Column Name Description
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
TaxBoxStrucValidityEndDate Valid To Date for Tax Box Structure
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
TaxReportingDate Tax Reporting Date
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
Column Name Description Domain name
TaxRate TaxRate (Percentage)
Ledger Ledger FINS_LEDGER
BusinessPlace Business Place J_1BBRANCH
Customer Customer Number KUNNR
BillingDocumentItemText Short text for sales order item TEXT40
TaxInvoiceItemNetUnitPrice null
LuxuryTaxRate TaxRate (Percentage)
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • I_ID_PRICINGELEMENTSGROUPCUBE.MANDT == TVFK.MANDT
  • I_ID_PRICINGELEMENTSGROUPCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
Material Number
  • Client
  • Material Number
  • I_ID_PRICINGELEMENTSGROUPCUBE.MANDT == MARA.MANDT
  • I_ID_PRICINGELEMENTSGROUPCUBE.MATERIAL == MARA.MATNR
Sales Organization
  • Client
  • Sales Organization
  • I_ID_PRICINGELEMENTSGROUPCUBE.MANDT == TVKO.MANDT
  • I_ID_PRICINGELEMENTSGROUPCUBE.SALESORGANIZATION == TVKO.VKORG