P_MY_SupplierInvoicewithTax

Supplier Invoice with Tax for MY | view: PMYSUPLRINVCTAX | 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
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
💲 Currency Key (DocumentCurrency):
InvoiceAmountInFrgnCurrency Amount in Document Currency
SupplierInvoiceItemAmount Amount in Document Currency
TaxAmount null
💲 Reporting Currency (TransactionCurrency):
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Document Currency
TaxBaseAmountInTransCrcy Tax Amount in Document Currency
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
SystemDate null
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
OrganizationBPName4 Name 4 of organization BU_NAME
AuthorizationGroup Authorization Group BRGRU
MY_IndustryCode Industry Code for Malaysia CHAR10
OriginalReferenceDocument null
VATRegistration VAT Registration Number STCEG
SupplierName Name of Supplier TEXT80
CustomerSupplierAddress Business Partner Address
DocumentHeaderText Document Header Text TEXT25
PurchasingDocumentItemText Short Text TEXT40
ReportingCountry Reporting Country/Region LAND1
ExchangeRate Exchange Rate UKURS
AccountingDocumentHeaderText Document Header Text TEXT25
SystemClient Client MANDT
Master Data Relations Join Conditions
Business Partner Country/Region
  • Client
  • Business Partner Country/Region
  • P_MY_SUPPLIERINVOICEWITHTAX.MANDT == T005.MANDT
  • P_MY_SUPPLIERINVOICEWITHTAX.BUSINESSPARTNERCOUNTRY == T005.LAND1
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_MY_SUPPLIERINVOICEWITHTAX.MANDT == TCURC.MANDT
  • P_MY_SUPPLIERINVOICEWITHTAX.DOCUMENTCURRENCY == TCURC.WAERS
  • P_MY_SUPPLIERINVOICEWITHTAX.COMPANYCODECURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_MY_SUPPLIERINVOICEWITHTAX.MANDT == TCURC.MANDT
  • P_MY_SUPPLIERINVOICEWITHTAX.DOCUMENTCURRENCY == TCURC.WAERS
  • P_MY_SUPPLIERINVOICEWITHTAX.COMPANYCODECURRENCY == TCURC.WAERS
Tax on sales/purchases code
  • Client
  • ?
  • Tax on sales/purchases code
  • P_MY_SUPPLIERINVOICEWITHTAX.MANDT == T007A.MANDT
  • P_MY_SUPPLIERINVOICEWITHTAX.[column in domain "KALSM_D"] == T007A.KALSM
  • P_MY_SUPPLIERINVOICEWITHTAX.TAXCODE == T007A.MWSKZ