P_StRpSupplierInvoiceItem

Supplier Invoice Item with Tax for Statutory Reporting | view: PSRSUPLRINVITM | Extraction: Not supported | Component: Financials Arabic Emirates
Tables used: RBKPRBKPBBKPFRBDRSEGRSEGRBKPRBTXBUT000T001TKA02LFA1CVI_VEND_LINK
Column Name Description
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year
SupplierInvoiceItem Document Item in Invoice Document
Column Name Description
💲 Currency Key (DocumentCurrency):
SupplierInvoiceItemAmount Amount in Document Currency
TaxBaseAmountInTransCrcy Tax Base Amount in Document Currency
TaxAmountInTransCrcy Tax Amount in Document Currency with +/- Sign
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
TaxReportingDate Tax Reporting Date
PostingDate Posting Date
ReportingDate Reporting Date
Column Name Description
Column Name Description Domain name
OriginalReferenceDocument null
SupplierName Name of Supplier TEXT80
TaxNumber1 Tax Number 1 STCD1
VATRegistration VAT Registration Number STCEG
AuthorizationGroup Authorization Group BRGRU
DocumentHeaderText Document Header Text TEXT25
OrganizationBPName4 Name 4 of organization BU_NAME
AccountingDocument Journal Entry BELNR
ReferenceDocumentType Reference Document Type AWTYP
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_STRPSUPPLIERINVOICEITEM.MANDT == T001.MANDT
  • P_STRPSUPPLIERINVOICEITEM.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_STRPSUPPLIERINVOICEITEM.MANDT == TCURC.MANDT
  • P_STRPSUPPLIERINVOICEITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • P_STRPSUPPLIERINVOICEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • P_STRPSUPPLIERINVOICEITEM.COUNTRY == T005.LAND1
  • P_STRPSUPPLIERINVOICEITEM.MANDT == T005.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_STRPSUPPLIERINVOICEITEM.MANDT == TCURC.MANDT
  • P_STRPSUPPLIERINVOICEITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • P_STRPSUPPLIERINVOICEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_STRPSUPPLIERINVOICEITEM.MANDT == MARA.MANDT
  • P_STRPSUPPLIERINVOICEITEM.MATERIAL == MARA.MATNR
Tax on sales/purchases code
  • Client
  • ?
  • Tax on sales/purchases code
  • P_STRPSUPPLIERINVOICEITEM.MANDT == T007A.MANDT
  • P_STRPSUPPLIERINVOICEITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_STRPSUPPLIERINVOICEITEM.TAXCODE == T007A.MWSKZ