C_StRpSalesInvoiceCube

Consumption view for TR Sales list | view: CSALEINVLCUBE | TRAN | 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
Column Name Description
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
DocumentReferenceID Reference Document Number XBLNR1
CommodityCode Commodity Code /SAPSLL/CCNGN
CustomerName Name of Customer TEXT80
ValidityStartDate null
UnitOfMeasureLongName Unit of Measurement Text (Maximum 30 Characters) TEXT30
Master Data Relations Join Conditions
Sales unit
  • Client
  • Sales unit
  • C_STRPSALESINVOICECUBE.MANDT == T006.MANDT
  • C_STRPSALESINVOICECUBE.BILLINGQUANTITYUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
  • C_STRPSALESINVOICECUBE.COMPANYCODE == T001.BUKRS
  • C_STRPSALESINVOICECUBE.MANDT == T001.MANDT
Country key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_STRPSALESINVOICECUBE.COUNTRY == T005.LAND1
  • C_STRPSALESINVOICECUBE.CUSTOMERCOUNTRY == T005.LAND1
  • C_STRPSALESINVOICECUBE.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_STRPSALESINVOICECUBE.COUNTRY == T005.LAND1
  • C_STRPSALESINVOICECUBE.CUSTOMERCOUNTRY == T005.LAND1
  • C_STRPSALESINVOICECUBE.MANDT == T005.MANDT
Material Number
  • Material Number
  • Client
  • C_STRPSALESINVOICECUBE.MATERIAL == MARA.MATNR
  • C_STRPSALESINVOICECUBE.MANDT == MARA.MANDT
Payer
  • Payer
  • Client
  • C_STRPSALESINVOICECUBE.PAYERPARTY == KNA1.KUNNR
  • C_STRPSALESINVOICECUBE.MANDT == KNA1.MANDT
Plant
  • Plant
  • Client
  • C_STRPSALESINVOICECUBE.PLANT == T001W.WERKS
  • C_STRPSALESINVOICECUBE.MANDT == T001W.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • C_STRPSALESINVOICECUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_STRPSALESINVOICECUBE.MANDT == SRF_RPG_ENT.MANDT