C_MY_SupplierInvoiceItemQuery

Supplier Invoice Item Query for MY GAF | view: CMYSUPLRINVCQRY | Extraction: Not supported | Component: Financials Malaysia
Tables used: BKPF, VBRK, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, EKKO, EKPO, RBKP, RBKPB, BKPF, BSEG, RBDRSEG, RSEG, VBPA, 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, T001, T014, T007B, VGTBS, T007L_LU, T007K_LU, FIMY_IDTY_INDCD, T007L_MY, T007K_MY, T007L, T007K, VGTAXGR, VGTGTB
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
SupplierInvoice Document Number of an Accounting Document
OriginalReferenceDocument null
SupplierInvoiceItem Document Item in Invoice Document
TaxCode FK Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
DebitCreditCode Debit/Credit Indicator Show values
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
Column Name Description
💲 Reporting Currency (ReportingCurrency):
PaytAmountInCoCodeCurrency Purchase Amount for Philippine
TaxAmountInCountryCrcy Purchase Value GST Amount
💲 Foreign Currency (TransactionCurrency):
InvoiceAmountInFrgnCurrency Purchase Foreign Currency Amount
TaxAmount Purchase Foreign Currency GST Amount
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
PostingDate Posting Date in the Document
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
MY_IndustryCode Industry Code for Malaysia CHAR10
OrganizationBPName4 Supplier BRN BU_NAME
VATRegistration VAT Registration Number STCEG
ReportingCountry Reporting Country/Region LAND1
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
SupplierName Name of Supplier TEXT80
CustomerSupplierAddress Business Partner Address
PurchasingDocumentItemText Purchasing Document Item Text TEXT40
AccountingDocumentHeaderText Document Header Text TEXT25
Master Data Relations Join Conditions
Business Partner Country/Region
  • Business Partner Country/Region
  • Client
  • C_MY_SUPPLIERINVOICEITEMQUERY.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_MY_SUPPLIERINVOICEITEMQUERY.MANDT == T005.MANDT
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • C_MY_SUPPLIERINVOICEITEMQUERY.MANDT == T007A.MANDT
  • C_MY_SUPPLIERINVOICEITEMQUERY.TAXCODE == T007A.MWSKZ
  • C_MY_SUPPLIERINVOICEITEMQUERY.[column in domain "KALSM_D"] == T007A.KALSM