C_GLIncgSalesOrdPrdtvQuery

Incoming Sales Orders – Pred. Accounting | view: CFGLISOPRQUERY | Extraction: Not supported | Component: Process Simulation and Document Preparation
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
InvertedAmtInCoCodeCurrency Amount in Company Code Currency
RecognizedCOGSAmtInCCCrcy Recognized COS
RecognizedMarginAmtInCCCrcy Recognized Margin
RecognizedRevnAmtInCCCrcy Recognized Revenue
RevenueAmountInCompanyCodeCrcy Revenue Amount in Company Code Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
InvertedAmtInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
InvertedAmtInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
InvertedAmtInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
InvertedAmtInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
InvertedAmtInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
InvertedAmtInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
InvertedAmtInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
InvertedAmtInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
CostOfGoodsSoldAmtInGlobCrcy Cost of Goods Sold - Total
InvertedAmountInGlobalCurrency Amount in Global Currency
RecognizedRevnAmtInGlobCrcy Recognized Revenue
RevenueInGlobalCurrency Revenue Amount in Global Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
InvertedAmtInTransCrcy Amount in Transaction Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
FixedQuantity Fixed Quantity
Quantity Quantity
Column Name Description
ClearingDate Clearing Date
CreationDate Creation Date
DocumentDate Journal Entry Date
FiscalPeriodStartDate Start Date of Fiscal Period
PostingDate Posting Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
GLAccountType Type of a General Ledger Account Show values
JrnlEntrDerivedFiscalQuarter Journal Entry Derived Fiscal Quarter Show values
JrnlEntryItemObsoleteReason Reason Item is Obsolete Show values
Column Name Description Domain name
JrnlEntrDerivdFiscalYearPeriod Journal Entry Derived Fiscal Year Period NUMC07
SalesOrganization Sales Organization VKORG
AccountingDocCreatedByUser User that created the journal entry
AccountingDocument Journal Entry BELNR
AccountingDocumentItem Journal Entry Posting View Item BUZEI
AccountingDocumentType Journal Entry Type BLART
AssignmentReference Assignment Reference ZUONR
BillingDocumentType Billing Type FKART
BillToParty Bill-to Party KUNNR
BusinessArea Business Area GSBER
BusinessTransactionType Business Transaction Type FINS_CUSTBTTYPE
ChartOfAccounts Chart of Accounts KTOPL
ClearingAccountingDocument Clearing Journal Entry BELNR
CompanyCode Company Code BUKRS
ControllingArea Controlling Area CACCD
CostCenter Cost Center KOSTL
Customer Customer Number KUNNR
CustomerGroup Customer Group KDGRP
CustomerSupplierCountry Customer or Supplier Country/Region LAND1
CustomerSupplierIndustry Customer Supplier Industry BRSCH
DistributionChannel Distribution Channel VTWEG
FinancialTransactionType Financial Transaction Type RMVCT
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalYearVariant Fiscal Year Variant PERIV
GLAccount G/L Account SAKNR
GLAccountHierarchy Financial Statement Version DHRYID
JrnlEntrDerivedFiscalPeriod Journal Entry Derived Fiscal Period POPER
JrnlEntrDerivedFiscalYear Journal Entry Derived Fiscal Year GJAHR
Ledger Ledger in General Ledger Accounting FINS_LEDGER
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
MaterialGroup Product Sold Group MATKL
OperatingConcern Operating Concern ERKRS
Plant Plant WERKS
PostingKey Posting Key BSCHL
ProfitCenter Profit Center PRCTR
ReferenceDocumentType Reference Document Type AWTYP
SalesDistrict Sales District BZIRK
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item NUM06
Segment Segment for Segmental Reporting FB_SEGMENT
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
ShipToParty Ship-to Party KUNNR
SoldMaterial Product Sold MATNR
SourceLedger Source Ledger FINS_LEDGER
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocumentType Source Document Type AWTYP
SpecialGLCode Special G/L Indicator UMSKZ
TransactionTypeDetermination Transaction Key CHAR3
Master Data Relations Join Conditions
Division in order header
  • ?
  • ?
  • Division
  • Client
  • C_GLINCGSALESORDPRDTVQUERY.[column in domain "VKORG"] == TVTA.VKORG
  • C_GLINCGSALESORDPRDTVQUERY.[column in domain "VTWEG"] == TVTA.VTWEG
  • C_GLINCGSALESORDPRDTVQUERY.DIVISION == TVTA.SPART
  • C_GLINCGSALESORDPRDTVQUERY.MANDT == TVTA.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_GLINCGSALESORDPRDTVQUERY.ORDERTYPE == TVAK.AUART
  • C_GLINCGSALESORDPRDTVQUERY.MANDT == TVAK.MANDT