I_MY_SupplierInvoiceItemCube

Supplier Invoice Item Cube for MY GAF | view: IMYSUPLRINVCCUBE | TRAN | Extraction: Full only | Component: Financials Malaysia
Tables used: BKPF, VBRK, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, EKKO, EKPO, RBKP, RBKPB, BSEG, RBDRSEG, RSEG, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, T001, TKA02, T005, KNA1, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, VGTAXBOX, VGTAXBOXT, VGTBS, VGTBST, T007A, T014, T007B, T007L_LU, T007K_LU, FIMY_IDTY_INDCD, T007L_MY, T007K_MY, T007L, T007K, VGTAXGR, VGTGTB
Column Name Description
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year
SupplierInvoiceItem Document Item in Invoice Document
TaxCode FK Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
DebitCreditCode Debit/Credit Indicator Show values
CompanyCode Company Code
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
Column Name Description
💲 Reporting Currency (ReportingCurrency):
PaytAmountInCoCodeCurrency null
TaxAmountInCountryCrcy null
💲 Foreign Currency (TransactionCurrency):
InvoiceAmountInFrgnCurrency Amount in Document Currency
TaxAmount null
TaxBaseAmountInTransCrcy Tax Amount in Document Currency
💲 Currency Key (CompanyCodeCurrency):
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Document Currency
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
ReportingDate Reporting Date
TaxReportingDate Tax Reporting Date
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
OrganizationBPName4 Supplier BRN BU_NAME
AuthorizationGroup Authorization Group BRGRU
MY_IndustryCode Industry Code for Malaysia CHAR10
OriginalReferenceDocument null
VATRegistration VAT Registration Number STCEG
ReportingCountry Reporting Country/Region LAND1
SupplierName Name of Supplier TEXT80
CustomerSupplierAddress Business Partner Address
DocumentHeaderText Document Header Text TEXT25
PurchasingDocumentItemText Purchasing Document Item Text TEXT40
AccountingDocumentHeaderText Document Header Text TEXT25
Master Data Relations Join Conditions
Business Partner Country/Region
  • Client
  • Business Partner Country/Region
  • I_MY_SUPPLIERINVOICEITEMCUBE.MANDT == T005.MANDT
  • I_MY_SUPPLIERINVOICEITEMCUBE.BUSINESSPARTNERCOUNTRY == T005.LAND1
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_MY_SUPPLIERINVOICEITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MY_SUPPLIERINVOICEITEMCUBE.DOCUMENTCURRENCY == TCURC.WAERS
  • I_MY_SUPPLIERINVOICEITEMCUBE.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_MY_SUPPLIERINVOICEITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MY_SUPPLIERINVOICEITEMCUBE.DOCUMENTCURRENCY == TCURC.WAERS
  • I_MY_SUPPLIERINVOICEITEMCUBE.MANDT == TCURC.MANDT
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • I_MY_SUPPLIERINVOICEITEMCUBE.[column in domain "KALSM_D"] == T007A.KALSM
  • I_MY_SUPPLIERINVOICEITEMCUBE.MANDT == T007A.MANDT
  • I_MY_SUPPLIERINVOICEITEMCUBE.TAXCODE == T007A.MWSKZ