C_SalesOrderQ2301

Sales Orders Actuals | view: CFISALESORDQ2301 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, ACDOCA, BKPF, /CPD/D_PFP_PS, /CPD/D_WORK_ITEM, MARA, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, T001W, MARA, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, /CPD/FC_WORKITEM, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
PostingDate Posting Date
Column Name Description
IsStatisticalSalesDocument Sales Document is statistical Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
Column Name Description Domain name
SalesOrderItem Sales Order Item POSNR
GLAccountName G/L Account Short Text TEXT20
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
CalendarYear Calendar Year NUM4
CompanyCodeName Name of Company Code or Company TEXT25
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
FunctionalAreaName Name of the Functional Area TEXT25
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
LedgerFiscalYear Ledger Fiscal Year GJAHR
PartnerProject Partner Project FIS_PROJECT
PartnerWBSElement Partner WBS Element FIS_WBS
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ProfitCenterName Description of Profit Center TEXT20
SegmentName Segment Name TEXT50
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
WorkItemName Work Item Name /CPD/PFP_WORKITEM_NAME
CalendarYearMonth Year Month NUM6
CalendarYearQuarter Year Quarter NUM5
CalendarYearWeek Year Week NUM6
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_SALESORDERQ2301.MANDT == T006.MANDT
  • C_SALESORDERQ2301.BASEUNIT == T006.MSEHI
Business Transaction Type
  • Client
  • Business Transaction Type
Company Code
  • Client
  • Company Code
  • C_SALESORDERQ2301.MANDT == T001.MANDT
  • C_SALESORDERQ2301.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_SALESORDERQ2301.MANDT == TCURC.MANDT
  • C_SALESORDERQ2301.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • C_SALESORDERQ2301.MANDT == KNA1.MANDT
  • C_SALESORDERQ2301.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • C_SALESORDERQ2301.MANDT == T151.MANDT
  • C_SALESORDERQ2301.CUSTOMERGROUP == T151.KDGRP
Functional Area
  • Client
  • Functional Area
  • C_SALESORDERQ2301.MANDT == TFKB.MANDT
  • C_SALESORDERQ2301.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_SALESORDERQ2301.MANDT == SKB1.MANDT
  • C_SALESORDERQ2301.GLACCOUNT == SKB1.SAKNR
  • C_SALESORDERQ2301.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_SALESORDERQ2301.MANDT == TCURC.MANDT
  • C_SALESORDERQ2301.GLOBALCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Product Number
  • Material Number
  • C_SALESORDERQ2301.MANDT == MARA.MANDT
  • C_SALESORDERQ2301.PRODUCT == MARA.MATNR
  • C_SALESORDERQ2301.MATERIAL == MARA.MATNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_SALESORDERQ2301.MANDT == T880.MANDT
  • C_SALESORDERQ2301.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Client
  • Partner Cost Center
  • ?
  • ?
  • C_SALESORDERQ2301.MANDT == CSKS.MANDT
  • C_SALESORDERQ2301.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_SALESORDERQ2301.[column in domain "DATBI"] == CSKS.DATBI
  • C_SALESORDERQ2301.[column in domain "KOKRS"] == CSKS.KOKRS
Partner Cost Center Activity Type
  • Client
  • ?
  • ?
  • Partner Cost Center Activity Type
  • C_SALESORDERQ2301.MANDT == CSLA.MANDT
  • C_SALESORDERQ2301.[column in domain "DATBI"] == CSLA.DATBI
  • C_SALESORDERQ2301.[column in domain "KOKRS"] == CSLA.KOKRS
  • C_SALESORDERQ2301.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Partner Functional Area
  • Client
  • Partner Functional Area
  • C_SALESORDERQ2301.MANDT == TFKB.MANDT
  • C_SALESORDERQ2301.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Client
  • Partner Order
  • C_SALESORDERQ2301.MANDT == AUFK.MANDT
  • C_SALESORDERQ2301.PARTNERORDER == AUFK.AUFNR
Partner Profit Center
  • Client
  • Partner Profit Center
  • ?
  • ?
  • C_SALESORDERQ2301.MANDT == CEPC.MANDT
  • C_SALESORDERQ2301.PARTNERPROFITCENTER == CEPC.PRCTR
  • C_SALESORDERQ2301.[column in domain "DATBI"] == CEPC.DATBI
  • C_SALESORDERQ2301.[column in domain "KOKRS"] == CEPC.KOKRS
Product Number
  • Client
  • Product Number
  • Material Number
  • C_SALESORDERQ2301.MANDT == MARA.MANDT
  • C_SALESORDERQ2301.PRODUCT == MARA.MATNR
  • C_SALESORDERQ2301.MATERIAL == MARA.MATNR
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • C_SALESORDERQ2301.MANDT == CEPC.MANDT
  • C_SALESORDERQ2301.[column in domain "DATBI"] == CEPC.DATBI
  • C_SALESORDERQ2301.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_SALESORDERQ2301.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_SALESORDERQ2301.MANDT == FAGL_SEGM.MANDT
  • C_SALESORDERQ2301.SEGMENT == FAGL_SEGM.SEGMENT
Sold Material
  • Client
  • Sold Material
  • Product Sold
  • C_SALESORDERQ2301.MANDT == MARA.MANDT
  • C_SALESORDERQ2301.SOLDMATERIAL == MARA.MATNR
  • C_SALESORDERQ2301.SOLDPRODUCT == MARA.MATNR
Product Sold
  • Client
  • Sold Material
  • Product Sold
  • C_SALESORDERQ2301.MANDT == MARA.MANDT
  • C_SALESORDERQ2301.SOLDMATERIAL == MARA.MATNR
  • C_SALESORDERQ2301.SOLDPRODUCT == MARA.MATNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_SALESORDERQ2301.MANDT == TCURC.MANDT
  • C_SALESORDERQ2301.TRANSACTIONCURRENCY == TCURC.WAERS