C_RevenueFromInvoiceQry

Sales Volume Flexible Analysis - Query | view: CSDREVNFRMINVCQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRP, VBRK, SCAL_TT_DATE, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, BUT000, T001, TKA02, TKA01, KNA1, T042Z, T042ZT, T001W, KONA, TVKO, T000, T001L, USR21
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Document Item
Column Name Description
💲 Display Currency (DisplayCurrency):
NetAmountInDisplayCurrency Net Value in Display Currency
SlsVolumeNetAmtInDspCrcy Net Value of Invoiced Sales
CancldSlsVolumeNetAmtInDspCrcy Canceled Sales Volume Net Amount In Display Currency
SlsProfitMargNetAmtInDspCrcy Profit Margin Amount in Display Currency
CustCrdtMemoNetAmtInDspCrcy Net Value of Credit Memos
CustCrdtMemoPrftMargNetAmtInDC Credit Memo Profit Margin Net Value in Display Currency
NetSlsVolumeNetAmtInDC Net Sales Volume in Display Currency
NetSlsProfitMargNetAmtInDC Net Profit Margin Net Value in Display Currency
NetSalesCostAmountInDC Net Sales Cost Amount in Display Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
SalesVolumeQuantity Sales Volume Quantity
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
PricingDate Date for Pricing and Exchange Rate
Column Name Description
SDDocumentCategory SD Document Category Show values
BillingDocumentCategory Billing Category Show values
SalesDocumentItemType Sales Document Item Type Show values
ReturnItemProcessingType Processing Type of Return Item Show values
ItemIsRelevantForCredit Item Relevant for Credit Check Show values
BillingDocumentIsCancelled Billing Document Is Canceled Show values
AccountingExchangeRateIsSet Exchange Rate Setting Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SalesSDDocumentCategory Sales SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallBillingStatus Overall Billing Status Show values
AccountingPostingStatus Posting Status of Billing Document Show values
AccountingTransferStatus Status for Transfer to Accounting Show values
BillingIssueType Billing Document Issue Type Show values
InvoiceListStatus Invoice list status of billing document Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
Column Name Description Domain name
BillingDocumentType Billing Type FKART
SalesDocumentItemCategory Sales Document Item Category PSTYV
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateYear Year of Creation NUM4
CreationDateYearQuarter Year/Quarter of Creation NUM5
CreationDateYearMonth Year/Month of Creation NUM6
BillingDocumentDateYear Year of Billing NUM4
BillingDocDateYearQuarter Quarter/Year of Billing NUM5
BillingDocDateYearMonth Month/Year of Billing NUM6
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
SoldToParty Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
SalesEmployee Sales Employee PERNR
ResponsibleEmployee Employee Responsible PERNR
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerRebateAgreement Customer Rebate Agreement KNUMA
SalesDistrict Sales District BZIRK
BillingDocumentItemText Short Text for Billing Document Item TEXT40
BillingPlanItem Item for Billing Plan/Invoice Plan/Payment Cards FPLTR
AccountingDocument Journal Entry Number BELNR
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
DocumentReferenceID Document Reference ID XBLNR1
AssignmentReference Assignment Number ZUONR
AdditionalValueDays Additional Value Days TAGE2
CustomerProject Commercial Project ID /CPD/MP_ID
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
CustomerGroup Customer Group KDGRP
CustomerPriceGroup Customer Price Group KONDA
CustomerPaymentTerms Terms of payment key ZTERM
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
TaxDepartureCountry Tax Departure Country/Region LAND1
VATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
CustomerTaxClassification1 Tax Classification 1 for Customer TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • C_REVENUEFROMINVOICEQRY.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_REVENUEFROMINVOICEQRY.MANDT == TVV1.MANDT
Customer Group 2
  • Client
  • Customer Group 2
  • C_REVENUEFROMINVOICEQRY.MANDT == TVV2.MANDT
  • C_REVENUEFROMINVOICEQRY.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • C_REVENUEFROMINVOICEQRY.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_REVENUEFROMINVOICEQRY.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • C_REVENUEFROMINVOICEQRY.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_REVENUEFROMINVOICEQRY.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • C_REVENUEFROMINVOICEQRY.MANDT == TVV5.MANDT
  • C_REVENUEFROMINVOICEQRY.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Material Group 1
  • Client
  • Material Group 1
  • C_REVENUEFROMINVOICEQRY.MANDT == TVM1.MANDT
  • C_REVENUEFROMINVOICEQRY.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Material Group 2
  • Client
  • C_REVENUEFROMINVOICEQRY.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • C_REVENUEFROMINVOICEQRY.MANDT == TVM2.MANDT
Material Group 3
  • Client
  • Material Group 3
  • C_REVENUEFROMINVOICEQRY.MANDT == TVM3.MANDT
  • C_REVENUEFROMINVOICEQRY.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • C_REVENUEFROMINVOICEQRY.MANDT == TVM4.MANDT
  • C_REVENUEFROMINVOICEQRY.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • C_REVENUEFROMINVOICEQRY.MANDT == TVM5.MANDT
  • C_REVENUEFROMINVOICEQRY.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_REVENUEFROMINVOICEQRY.MANDT == T006.MANDT
  • C_REVENUEFROMINVOICEQRY.BASEUNIT == T006.MSEHI
Batch Number
  • Material Number
  • Product Number
  • Batch Number
  • Client
  • Plant
  • C_REVENUEFROMINVOICEQRY.MATERIAL == MCHA.MATNR
  • C_REVENUEFROMINVOICEQRY.PRODUCT == MCHA.MATNR
  • C_REVENUEFROMINVOICEQRY.BATCH == MCHA.CHARG
  • C_REVENUEFROMINVOICEQRY.MANDT == MCHA.MANDT
  • C_REVENUEFROMINVOICEQRY.PLANT == MCHA.WERKS
Sales unit
  • Sales unit
  • Client
  • C_REVENUEFROMINVOICEQRY.BILLINGQUANTITYUNIT == T006.MSEHI
  • C_REVENUEFROMINVOICEQRY.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • C_REVENUEFROMINVOICEQRY.BUSINESSAREA == TGSB.GSBER
  • C_REVENUEFROMINVOICEQRY.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • C_REVENUEFROMINVOICEQRY.MANDT == T001.MANDT
  • C_REVENUEFROMINVOICEQRY.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • C_REVENUEFROMINVOICEQRY.CONTROLLINGAREA == TKA01.KOKRS
  • C_REVENUEFROMINVOICEQRY.MANDT == TKA01.MANDT
Destination Country/Region
  • Client
  • Destination Country/Region
  • C_REVENUEFROMINVOICEQRY.MANDT == T005.MANDT
  • C_REVENUEFROMINVOICEQRY.COUNTRY == T005.LAND1
Credit control area
  • Client
  • Credit control area
  • C_REVENUEFROMINVOICEQRY.MANDT == T014.MANDT
  • C_REVENUEFROMINVOICEQRY.CREDITCONTROLAREA == T014.KKBER
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • C_REVENUEFROMINVOICEQRY.MANDT == TVKT.MANDT
  • C_REVENUEFROMINVOICEQRY.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Division
  • Client
  • Division
  • C_REVENUEFROMINVOICEQRY.MANDT == TSPA.MANDT
  • C_REVENUEFROMINVOICEQRY.DIVISION == TSPA.SPART
Dunning Area
  • Dunning Area
  • Client
  • Company Code
  • C_REVENUEFROMINVOICEQRY.DUNNINGAREA == T047M.MABER
  • C_REVENUEFROMINVOICEQRY.MANDT == T047M.MANDT
  • C_REVENUEFROMINVOICEQRY.COMPANYCODE == T047M.BUKRS
Dunning Block
  • Client
  • Dunning Block
  • C_REVENUEFROMINVOICEQRY.MANDT == T040S.MANDT
  • C_REVENUEFROMINVOICEQRY.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Dunning Key
  • Client
  • C_REVENUEFROMINVOICEQRY.DUNNINGKEY == T040.MSCHL
  • C_REVENUEFROMINVOICEQRY.MANDT == T040.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_REVENUEFROMINVOICEQRY.MANDT == TINC.MANDT
  • C_REVENUEFROMINVOICEQRY.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • C_REVENUEFROMINVOICEQRY.INCOTERMSVERSION == TINCV.INCOV
  • C_REVENUEFROMINVOICEQRY.MANDT == TINCV.MANDT
Material Number
  • Material Number
  • Product Number
  • Client
  • C_REVENUEFROMINVOICEQRY.MATERIAL == MARA.MATNR
  • C_REVENUEFROMINVOICEQRY.PRODUCT == MARA.MATNR
  • C_REVENUEFROMINVOICEQRY.MANDT == MARA.MANDT
Commission Group
  • Client
  • Commission Group
  • C_REVENUEFROMINVOICEQRY.MANDT == TVPR.MANDT
  • C_REVENUEFROMINVOICEQRY.MATERIALCOMMISSIONGROUP == TVPR.PROVG
Material Group
  • Client
  • Material Group
  • Product Group
  • C_REVENUEFROMINVOICEQRY.MANDT == T023.MANDT
  • C_REVENUEFROMINVOICEQRY.MATERIALGROUP == T023.MATKL
  • C_REVENUEFROMINVOICEQRY.PRODUCTGROUP == T023.MATKL
Order Number
  • Client
  • Order Number
  • C_REVENUEFROMINVOICEQRY.MANDT == AUFK.MANDT
  • C_REVENUEFROMINVOICEQRY.ORDERID == AUFK.AUFNR
Organization Division
  • Client
  • Organization Division
  • C_REVENUEFROMINVOICEQRY.MANDT == TSPA.MANDT
  • C_REVENUEFROMINVOICEQRY.ORGANIZATIONDIVISION == TSPA.SPART
Payment Method
  • Payment Method
  • Client
  • Destination Country/Region
  • C_REVENUEFROMINVOICEQRY.PAYMENTMETHOD == T042Z.ZLSCH
  • C_REVENUEFROMINVOICEQRY.MANDT == T042Z.MANDT
  • C_REVENUEFROMINVOICEQRY.COUNTRY == T042Z.LAND1
Plant
  • Client
  • Plant
  • C_REVENUEFROMINVOICEQRY.MANDT == T001W.MANDT
  • C_REVENUEFROMINVOICEQRY.PLANT == T001W.WERKS
Price List Type
  • Price List Type
  • Client
  • C_REVENUEFROMINVOICEQRY.PRICELISTTYPE == T189.PLTYP
  • C_REVENUEFROMINVOICEQRY.MANDT == T189.MANDT
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • C_REVENUEFROMINVOICEQRY.PRICINGREFERENCEMATERIAL == MARA.MATNR
  • C_REVENUEFROMINVOICEQRY.MANDT == MARA.MANDT
Product Number
  • Material Number
  • Product Number
  • Client
  • C_REVENUEFROMINVOICEQRY.MATERIAL == MARA.MATNR
  • C_REVENUEFROMINVOICEQRY.PRODUCT == MARA.MATNR
  • C_REVENUEFROMINVOICEQRY.MANDT == MARA.MANDT
Product Group
  • Client
  • Material Group
  • Product Group
  • C_REVENUEFROMINVOICEQRY.MANDT == T023.MANDT
  • C_REVENUEFROMINVOICEQRY.MATERIALGROUP == T023.MATKL
  • C_REVENUEFROMINVOICEQRY.PRODUCTGROUP == T023.MATKL
Product hierarchy
  • Product hierarchy
  • Client
  • C_REVENUEFROMINVOICEQRY.PRODUCTHIERARCHYNODE == T179.PRODH
  • C_REVENUEFROMINVOICEQRY.MANDT == T179.MANDT
Region (State, Province, County)
  • Client
  • Destination Country/Region
  • Region (State, Province, County)
  • C_REVENUEFROMINVOICEQRY.MANDT == T005S.MANDT
  • C_REVENUEFROMINVOICEQRY.COUNTRY == T005S.LAND1
  • C_REVENUEFROMINVOICEQRY.REGION == T005S.BLAND
Retail Promotion
  • Retail Promotion
  • Client
  • C_REVENUEFROMINVOICEQRY.RETAILPROMOTION == WAKH.AKTNR
  • C_REVENUEFROMINVOICEQRY.MANDT == WAKH.MANDT
Sales Deal
  • Sales Deal
  • Client
  • C_REVENUEFROMINVOICEQRY.SALESDEAL == KONA.KNUMA
  • C_REVENUEFROMINVOICEQRY.MANDT == KONA.MANDT
Sales group
  • Client
  • Sales group
  • C_REVENUEFROMINVOICEQRY.MANDT == TVKGR.MANDT
  • C_REVENUEFROMINVOICEQRY.SALESGROUP == TVKGR.VKGRP
Sales office
  • Client
  • Sales office
  • C_REVENUEFROMINVOICEQRY.MANDT == TVBUR.MANDT
  • C_REVENUEFROMINVOICEQRY.SALESOFFICE == TVBUR.VKBUR
Sales Promotion
  • Sales Promotion
  • Client
  • C_REVENUEFROMINVOICEQRY.SALESPROMOTION == KONA.KNUMA
  • C_REVENUEFROMINVOICEQRY.MANDT == KONA.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_REVENUEFROMINVOICEQRY.SDDOCUMENTREASON == TVAU.AUGRU
  • C_REVENUEFROMINVOICEQRY.MANDT == TVAU.MANDT
Pricing Procedure in Pricing
  • Client
  • Pricing Procedure in Pricing
  • ?
  • ?
  • C_REVENUEFROMINVOICEQRY.MANDT == T683.MANDT
  • C_REVENUEFROMINVOICEQRY.SDPRICINGPROCEDURE == T683.KALSM
  • C_REVENUEFROMINVOICEQRY.[column in domain "KAPPL"] == T683.KAPPL
  • C_REVENUEFROMINVOICEQRY.[column in domain "KVEWE"] == T683.KVEWE
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_REVENUEFROMINVOICEQRY.MANDT == TVSB.MANDT
  • C_REVENUEFROMINVOICEQRY.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_REVENUEFROMINVOICEQRY.MANDT == TVST.MANDT
  • C_REVENUEFROMINVOICEQRY.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Plant
  • Storage location
  • C_REVENUEFROMINVOICEQRY.MANDT == T001L.MANDT
  • C_REVENUEFROMINVOICEQRY.PLANT == T001L.WERKS
  • C_REVENUEFROMINVOICEQRY.STORAGELOCATION == T001L.LGORT
Volume rebate group
  • Client
  • Volume rebate group
  • C_REVENUEFROMINVOICEQRY.MANDT == TVBO.MANDT
  • C_REVENUEFROMINVOICEQRY.VOLUMEREBATEGROUP == TVBO.BONUS