C_IN_StockTransportOvwQ

DDL: C_IN_STOCKTRANSPORTOVWQ SQL: CINSTODOCOVWQ Type: view CONSUMPTION

Stock Transport Overview Query

C_IN_StockTransportOvwQ is a Consumption CDS View that provides data about "Stock Transport Overview Query" in SAP S/4HANA. It reads from 1 data source (C_IN_StockTransportOrderCube) and exposes 19 fields.

Data Sources (1)

SourceAliasJoin Type
C_IN_StockTransportOrderCube C_IN_StockTransportOrderCube from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CINSTODOCOVWQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
OData.publish true view
EndUserText.label Stock Transport Overview Query view

Fields (19)

KeyFieldSource TableSource FieldDescription
PurchasingDocument PurchasingDocument STO Number
AccountingDocument AccountingDocument Inbound Invoice
DeliveryDocument DeliveryDocument Delivery Document
DocumentReferenceID DocumentReferenceID Document Reference Id
BillingDocument BillingDocument Outbound Invoice
CreationDateYear CreationDateYear Creation Year
FiscalYear CreationDateYear
PurchasingHistoryDocumentType PurchasingHistoryDocumentType Purchasing History Document Type
CompanyCode CompanyCode Company Code
SupplyingPlant SupplyingPlant Supplying Plant
ReceivingPlant ReceivingPlant Receiving Plant
PurchasingDocumentCategory PurchasingDocumentCategory Purchasing Document Category
PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear Purchasing History Document Year
STOCreationDate STOCreationDate STO Creation Date
CreationDateMonth CreationDateMonth Creation Month
PurchasingHistoryCategory PurchasingHistoryCategory Purchasing History Category
BillingDocCreationDate BillingDocCreationDate Billing Document Creation Date
SubsequentDocument SubsequentDocument Subsequent Document
NumberOfPurchaseOrders NumberOfPurchaseOrders Number of Purchase Orders

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_IN_StockTransportOvwQ.
-- 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: CINSTODOCOVWQ

CREATE VIEW C_IN_StockTransportOvwQ AS
SELECT
  PurchasingDocument,
  AccountingDocument,
  DeliveryDocument,
  DocumentReferenceID,
  BillingDocument,
  CreationDateYear,
  CreationDateYear AS FiscalYear,
  PurchasingHistoryDocumentType,
  CompanyCode,
  SupplyingPlant,
  ReceivingPlant,
  PurchasingDocumentCategory,
  PurchasingHistoryDocumentYear,
  STOCreationDate,
  CreationDateMonth,
  PurchasingHistoryCategory,
  BillingDocCreationDate,
  SubsequentDocument,
  NumberOfPurchaseOrders
FROM C_IN_StockTransportOrderCube
;