What is C_GLIncgSalesOrdPrdtvQuery in SAP S/4HANA?

C_GLIncgSalesOrdPrdtvQuery is a consumption CDS view in SAP S/4HANA. Incoming Sales Orders – Pred. Accounting It contains 114 fields.

Which tables does C_GLIncgSalesOrdPrdtvQuery read from?

C_GLIncgSalesOrdPrdtvQuery reads data from: I_GLIncgSalesOrdPrdtvCube.

What VDM layer is C_GLIncgSalesOrdPrdtvQuery?

C_GLIncgSalesOrdPrdtvQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_GLIncgSalesOrdPrdtvQuery

DDL: C_GLINCGSALESORDPRDTVQUERY SQL: CFGLISOPRQUERY Type: view CONSUMPTION

114 Fields 1 Data Sources

Incoming Sales Orders – Pred. Accounting

C_GLIncgSalesOrdPrdtvQuery (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

C_GLIncgSalesOrdPrdtvQuery is a Consumption CDS View that provides data about "Incoming Sales Orders – Pred. Accounting" in SAP S/4HANA. It reads from 1 data source (I_GLIncgSalesOrdPrdtvCube) and exposes 114 fields.

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-PRA-PRA
Capabilities	Analytical Query
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_GLIncgSalesOrdPrdtvCube	I_GLIncgSalesOrdPrdtvCube	from

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	CFGLISOPRQUERY	view
AbapCatalog.compiler.compareFilter	true	view
Analytics.query	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Incoming Sales Orders – Pred. Accounting	view
Analytics.settings.maxProcessingEffort	#HIGH	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view

Fields (114)

Field	Source Field	Description
JrnlEntrDerivdFiscalYearPeriod	JrnlEntrDerivdFiscalYearPeriod	Journal Entry Derived Fiscal Year Period
SalesOrganization	SalesOrganization	Sales Organization
AccountingDocCreatedByUser	AccountingDocCreatedByUser	User which created overhead document
AccountingDocument	AccountingDocument	Journal Entry
AccountingDocumentCategory	AccountingDocumentCategory	Journal Entry Category
AccountingDocumentItem	AccountingDocumentItem	Journal Entry Posting View Item
AccountingDocumentType	AccountingDocumentType	Journal Entry Type
AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Amount in Company Code Currency
AmountInFreeDefinedCurrency1	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
AmountInGlobalCurrency	AmountInGlobalCurrency	Amount in Global Currency
AmountInTransactionCurrency	AmountInTransactionCurrency	Amount in Transaction Currency
AssignmentReference	AssignmentReference	Assignment Reference
BaseUnit	BaseUnit	Base Unit of Measure
BillingDocumentType	BillingDocumentType	Billing Type
BillToParty	BillToParty	Inv. Recipient
BusinessArea	BusinessArea	Business Area
BusinessTransactionType	BusinessTransactionType	Business Transaction Type
ChartOfAccounts	ChartOfAccounts	Chart of Accounts
ClearingAccountingDocument	ClearingAccountingDocument	Clearing Journal Entry (Deprecated)
ClearingDate	ClearingDate	Clearing Date
CompanyCode	CompanyCode	Receiver Company Code
CompanyCodeCurrency	CompanyCodeCurrency	Company Code Currency
ControllingArea	ControllingArea	Controlling Area
ControllingDebitCreditCode	ControllingDebitCreditCode	CO Debit/Credit Indicator
CostCenter	CostCenter	Cost Center
CostOfGoodsSoldAmtInGlobCrcy	CostOfGoodsSoldAmtInGlobCrcy	Cost of Goods Sold - Total
CreationDate	CreationDate	Creation Date
Customer	Customer	Customer Number
CustomerGroup	CustomerGroup	Customer Group
CustomerSupplierCountry	CustomerSupplierCountry	Customer or Supplier Country/Region
CustomerSupplierIndustry	CustomerSupplierIndustry	Customer Supplier Industry
DebitCreditCode	DebitCreditCode	Single-Character Flag
DistributionChannel	DistributionChannel	Distribution Channel
Division	Division	Internal Division ID
DocumentDate	DocumentDate	Journal Entry Date
FinancialAccountType	FinancialAccountType	Fin. Account Type
FinancialTransactionType	FinancialTransactionType	Financial Transaction Type
FiscalPeriod	FiscalPeriod	Fiscal Period
FiscalPeriodStartDate	FiscalPeriodStartDate	Start Date of Fiscal Period
FiscalQuarter	FiscalQuarter	Fiscal Quarter
FiscalYear	FiscalYear	G/L Fiscal Year
FiscalYearPeriod	FiscalYearPeriod	Fiscal Year Period
FiscalYearVariant	FiscalYearVariant	Fiscal Year Variant
FixedQuantity	FixedQuantity	Fixed Quantity
FreeDefinedCurrency1	FreeDefinedCurrency1	Freely Defined Currency 1
FreeDefinedCurrency2	FreeDefinedCurrency2	Freely Defined Currency 2
FreeDefinedCurrency3	FreeDefinedCurrency3	Freely Defined Currency 3
FreeDefinedCurrency4	FreeDefinedCurrency4	Freely Defined Currency 4
FreeDefinedCurrency5	FreeDefinedCurrency5	Freely Defined Currency 5
FreeDefinedCurrency6	FreeDefinedCurrency6	Freely Defined Currency 6
FreeDefinedCurrency7	FreeDefinedCurrency7	Freely Defined Currency 7
FreeDefinedCurrency8	FreeDefinedCurrency8	Freely Defined Currency 8
GLAccount	GLAccount	General Ledger
GLAccountHierarchy	GLAccountHierarchy	Financial Statement Version
GLAccountType	GLAccountType	Type of a General Ledger Account
GlobalCurrency	GlobalCurrency	GM Billing Element: Global Currency
InvertedAmountInGlobalCurrency	InvertedAmountInGlobalCurrency	Inverted Amount in Glob Crcy
InvertedAmtInCoCodeCurrency	InvertedAmtInCoCodeCurrency	Amount in Company Code Currency
InvertedAmtInFreeDefinedCrcy1	InvertedAmtInFreeDefinedCrcy1	Amount in Freely Defined Currency 1
InvertedAmtInFreeDefinedCrcy2	InvertedAmtInFreeDefinedCrcy2	Amount in Freely Defined Currency 2
InvertedAmtInFreeDefinedCrcy3	InvertedAmtInFreeDefinedCrcy3	Amount in Freely Defined Currency 3
InvertedAmtInFreeDefinedCrcy4	InvertedAmtInFreeDefinedCrcy4	Amount in Freely Defined Currency 4
InvertedAmtInFreeDefinedCrcy5	InvertedAmtInFreeDefinedCrcy5	Amount in Freely Defined Currency 5
InvertedAmtInFreeDefinedCrcy6	InvertedAmtInFreeDefinedCrcy6	Amount in Freely Defined Currency 6
InvertedAmtInFreeDefinedCrcy7	InvertedAmtInFreeDefinedCrcy7	Amount in Freely Defined Currency 7
InvertedAmtInFreeDefinedCrcy8	InvertedAmtInFreeDefinedCrcy8	Amount in Freely Defined Currency 8
InvertedAmtInTransCrcy	InvertedAmtInTransCrcy	Amount in Transaction Currency
JrnlEntrDerivedFiscalPeriod	JrnlEntrDerivedFiscalPeriod	Journal Entry Derived Fiscal Period
JrnlEntrDerivedFiscalQuarter	JrnlEntrDerivedFiscalQuarter	Journal Entry Derived Fiscal Quarter
JrnlEntrDerivedFiscalYear	JrnlEntrDerivedFiscalYear	Journal Entry Derived Fiscal Year
JrnlEntryItemObsoleteReason	JrnlEntryItemObsoleteReason	Reason Item is Obsolete
Ledger	Ledger	Ledger in General Ledger Accounting
LedgerFiscalYear	LedgerFiscalYear	Fiscal Year of Ledger
LedgerGLLineItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
MaterialGroup	MaterialGroup	Product Sold Group
OperatingConcern	OperatingConcern	Operating concern
OrderType	OrderType	Sales Document Type
Plant	Plant	Valuation Area
PostingDate	PostingDate	Posting Date for GR
PostingKey	PostingKey	Posting Key
ProfitCenter	ProfitCenter	Profit Center
Quantity	Quantity	Quantity
RecognizedCOGSAmtInCCCrcy	RecognizedCOGSAmtInCCCrcy	Recognized COS
RecognizedMarginAmtInCCCrcy	RecognizedMarginAmtInCCCrcy	Recognized Margin
RecognizedRevnAmtInCCCrcy	RecognizedRevnAmtInCCCrcy	Recognized Revenue
RecognizedRevnAmtInGlobCrcy	RecognizedRevnAmtInGlobCrcy	Recognized Revenue
ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
RevenueAmountInCompanyCodeCrcy	RevenueAmountInCompanyCodeCrcy	Revenue Amount in Company Code Currency
RevenueInGlobalCurrency	RevenueInGlobalCurrency	Revenue Amount in Global Currency
SalesDistrict	SalesDistrict	Sales District
SalesOrder	SalesOrder	SD Document
SalesOrderItem	SalesOrderItem	Sales Order Item
Segment	Segment	Segment for Segmental Reporting
SemanticTag	SemanticTag	Semantic Tag of a Hierarchy Node
ShipToParty	ShipToParty	Ship-To Party (obsolete)
SoldMaterial	SoldMaterial	Product Sold
SourceLedger	SourceLedger	Source Ledger
SourceReferenceDocument	SourceReferenceDocument	Source Reference Document
SourceReferenceDocumentItem	SourceReferenceDocumentItem	Source Reference Document Item
SourceReferenceDocumentType	SourceReferenceDocumentType	Source Document Type
SpecialGLCode	SpecialGLCode	Special G/L Indicator
TransactionCurrency	TransactionCurrency	Transaction Currency
TransactionTypeDetermination	TransactionTypeDetermination	Transaction Key
_Customer	_Customer
_AccountingDocumentType	_AccountingDocumentType
_CurrentProfitCenter	_CurrentProfitCenter
_GLAccountInCompanyCode	_GLAccountInCompanyCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_GLIncgSalesOrdPrdtvQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFGLISOPRQUERY

CREATE VIEW C_GLIncgSalesOrdPrdtvQuery AS
SELECT
  JrnlEntrDerivdFiscalYearPeriod,
  SalesOrganization,
  AccountingDocCreatedByUser,
  AccountingDocument,
  AccountingDocumentCategory,
  AccountingDocumentItem,
  AccountingDocumentType,
  AmountInCompanyCodeCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  AmountInGlobalCurrency,
  AmountInTransactionCurrency,
  AssignmentReference,
  BaseUnit,
  BillingDocumentType,
  BillToParty,
  BusinessArea,
  BusinessTransactionType,
  ChartOfAccounts,
  ClearingAccountingDocument,
  ClearingDate,
  CompanyCode,
  CompanyCodeCurrency,
  ControllingArea,
  ControllingDebitCreditCode,
  CostCenter,
  CostOfGoodsSoldAmtInGlobCrcy,
  CreationDate,
  Customer,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  DebitCreditCode,
  DistributionChannel,
  Division,
  DocumentDate,
  FinancialAccountType,
  FinancialTransactionType,
  FiscalPeriod,
  FiscalPeriodStartDate,
  FiscalQuarter,
  FiscalYear,
  FiscalYearPeriod,
  FiscalYearVariant,
  FixedQuantity,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  GLAccount,
  GLAccountHierarchy,
  GLAccountType,
  GlobalCurrency,
  InvertedAmountInGlobalCurrency,
  InvertedAmtInCoCodeCurrency,
  InvertedAmtInFreeDefinedCrcy1,
  InvertedAmtInFreeDefinedCrcy2,
  InvertedAmtInFreeDefinedCrcy3,
  InvertedAmtInFreeDefinedCrcy4,
  InvertedAmtInFreeDefinedCrcy5,
  InvertedAmtInFreeDefinedCrcy6,
  InvertedAmtInFreeDefinedCrcy7,
  InvertedAmtInFreeDefinedCrcy8,
  InvertedAmtInTransCrcy,
  JrnlEntrDerivedFiscalPeriod,
  JrnlEntrDerivedFiscalQuarter,
  JrnlEntrDerivedFiscalYear,
  JrnlEntryItemObsoleteReason,
  Ledger,
  LedgerFiscalYear,
  LedgerGLLineItem,
  MaterialGroup,
  OperatingConcern,
  OrderType,
  Plant,
  PostingDate,
  PostingKey,
  ProfitCenter,
  Quantity,
  RecognizedCOGSAmtInCCCrcy,
  RecognizedMarginAmtInCCCrcy,
  RecognizedRevnAmtInCCCrcy,
  RecognizedRevnAmtInGlobCrcy,
  ReferenceDocumentType,
  RevenueAmountInCompanyCodeCrcy,
  RevenueInGlobalCurrency,
  SalesDistrict,
  SalesOrder,
  SalesOrderItem,
  Segment,
  SemanticTag,
  ShipToParty,
  SoldMaterial,
  SourceLedger,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocumentType,
  SpecialGLCode,
  TransactionCurrency,
  TransactionTypeDetermination
FROM I_GLIncgSalesOrdPrdtvCube
;

Depth:

C_GLIncgSalesOrdPrdtvQuery view

I_GLIncgSalesOrdPrdtvCube view