P_StRpSalesInvoiceItem

Private View for Sales Invoice List | view: PSALEINVLITEM | Extraction: Not supported | Component: Localization Financials
Column Name Description
CompanyCode FK Company Code
BillingDocument Billing Document
BillingDocumentItem Billing Item
FiscalYear Fiscal Year
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
Column Name Description
📏 Sales unit (BillingQuantityUnit):
Quantity Actual billed quantity
Column Name Description
BillingDocumentDate Billing Date
MeterReadingSystemDate null
Column Name Description
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
DocumentReferenceID Reference Document Number XBLNR1
ValidityStartDate null
CustomerName Name of Customer TEXT80
Master Data Relations Join Conditions
Sales unit
  • Client
  • Sales unit
  • P_STRPSALESINVOICEITEM.MANDT == T006.MANDT
  • P_STRPSALESINVOICEITEM.BILLINGQUANTITYUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
  • P_STRPSALESINVOICEITEM.COMPANYCODE == T001.BUKRS
  • P_STRPSALESINVOICEITEM.MANDT == T001.MANDT
Country key
  • Country/Region Key
  • Country/Region Key
  • Client
  • P_STRPSALESINVOICEITEM.CUSTOMERCOUNTRY == T005.LAND1
  • P_STRPSALESINVOICEITEM.COUNTRY == T005.LAND1
  • P_STRPSALESINVOICEITEM.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • P_STRPSALESINVOICEITEM.CUSTOMERCOUNTRY == T005.LAND1
  • P_STRPSALESINVOICEITEM.COUNTRY == T005.LAND1
  • P_STRPSALESINVOICEITEM.MANDT == T005.MANDT
Material Number
  • Client
  • Material Number
  • P_STRPSALESINVOICEITEM.MANDT == MARA.MANDT
  • P_STRPSALESINVOICEITEM.MATERIAL == MARA.MATNR
Payer
  • Payer
  • Client
  • P_STRPSALESINVOICEITEM.PAYERPARTY == KNA1.KUNNR
  • P_STRPSALESINVOICEITEM.MANDT == KNA1.MANDT
Plant
  • Client
  • Plant
  • P_STRPSALESINVOICEITEM.MANDT == T001W.MANDT
  • P_STRPSALESINVOICEITEM.PLANT == T001W.WERKS
Reporting Entity
  • Reporting Entity
  • Client
  • P_STRPSALESINVOICEITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • P_STRPSALESINVOICEITEM.MANDT == SRF_RPG_ENT.MANDT