What is C_SlsOrdFlfmtDeliveryDocQ in SAP S/4HANA?

C_SlsOrdFlfmtDeliveryDocQ is a consumption CDS view in SAP S/4HANA. SOFM Delivery Document Query It contains 65 fields.

Which tables does C_SlsOrdFlfmtDeliveryDocQ read from?

C_SlsOrdFlfmtDeliveryDocQ reads data from: I_SlsOrdFlfmtDeliveryDoc.

What VDM layer is C_SlsOrdFlfmtDeliveryDocQ?

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

C_SlsOrdFlfmtDeliveryDocQ

DDL: C_SLSORDFLFMTDELIVERYDOCQ SQL: CSOFDELIVDOCQ Type: view CONSUMPTION

65 Fields 1 Data Sources

SOFM Delivery Document Query

C_SlsOrdFlfmtDeliveryDocQ is a Consumption CDS View that provides data about "SOFM Delivery Document Query" in SAP S/4HANA. It reads from 1 data source (I_SlsOrdFlfmtDeliveryDoc) and exposes 65 fields with key field OutboundDelivery.

Data Sources (1)

Source	Alias	Join Type
I_SlsOrdFlfmtDeliveryDoc	DeliveryDocument	from

Parameters (1)

Name	Type	Default
P_Language	sylangu

Annotations (9)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#S	view
EndUserText.label	SOFM Delivery Document Query	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
AbapCatalog.sqlViewName	CSOFDELIVDOCQ	view

Fields (65)

Key	Field	Source Field	Description
KEY	OutboundDelivery	OutboundDelivery	LE Delivery
	SalesOrganization	SalesOrganization	Sales Organization
	ShippingPoint	ShippingPoint	Shipping Point
	ShippingPointName
	CompleteDeliveryIsDefined	CompleteDeliveryIsDefined	Complete Dlv.
	DeliveryBlockReason	DeliveryBlockReason	Delivery Block
	DeliveryBlockReasonText
	HeaderGrossWeight	HeaderGrossWeight
	HeaderNetWeight	HeaderNetWeight
	HeaderWeightUnit	HeaderWeightUnit
	ActualDeliveryAmount	ActualDeliveryAmount
	TransactionCurrency	TransactionCurrency	Transaction Currency
	TotalNumberOfPackage	TotalNumberOfPackage
	SoldToParty	SoldToParty	Sold-to Party
	SoldToPartyName	SoldToPartyName	Sold-to Party Name
	ShipToParty	ShipToParty	Ship-To Party (obsolete)
	ShipToPartyName	ShipToPartyName	Ship-To Party Name
	PickingDate	PickingDate
	ShippingType	ShippingType	Shipping Type
	ShippingTypeName
	DeliveryDate	DeliveryDate	Delivery Date
	ShippingCondition	ShippingCondition	Shipping Conditions
	ShippingConditionName
	TransportationPlanningDate	TransportationPlanningDate	TranspPlngDate
	PlannedGoodsIssueDate	PlannedGoodsIssueDate
	ActualGoodsMovementDate	ActualGoodsMovementDate
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms 2
	IncotermsClassification	IncotermsClassification	Incoterms
	IncotermsClassificationName
	BillingDocumentDate	BillingDocumentDate	Billing Date
	HeaderBillingBlockReason	HeaderBillingBlockReason	Billing Block
	BillingBlockReasonDescription
	OverallSDProcessStatus	OverallSDProcessStatus
	OverallSDProcessStatusDesc
	OverallPickingStatus	OverallPickingStatus
	OverallPickingStatusDesc
	OverallWarehouseActivityStatus	OverallWarehouseActivityStatus
	OvrlWarehouseActyStatusDesc
	OverallGoodsMovementStatus	OverallGoodsMovementStatus
	OverallGoodsMovementStatusDesc
	OverallPackingStatus	OverallPackingStatus
	OverallPackingStatusDesc
	TransportationPlanningStatus	TransportationPlanningStatus
	TransportationPlanningStsDesc
	HdrGeneralIncompletionStatus	HdrGeneralIncompletionStatus
	HdrGenIncompletionStatusDesc
	HeaderBillgIncompletionStatus	HeaderBillgIncompletionStatus
	HdrBillgIncompletionStatusDesc
	HeaderPackingIncompletionSts	HeaderPackingIncompletionSts
	HdrPackingIncompltnStatusDesc
	HeaderPickgIncompletionStatus	HeaderPickgIncompletionStatus
	HdrPickgIncompltnStatusDesc
	HeaderDelivIncompletionStatus	HeaderDelivIncompletionStatus
	HdrDelivIncompletionStatusDesc
	HdrGoodsMvtIncompletionStatus	HdrGoodsMvtIncompletionStatus
	HdrGoodsMvtIncompltnStatusDesc
	FinDocCreditCheckStatus	FinDocCreditCheckStatus
	FinDocCreditCheckStatusDesc
	ExprtInsurCreditCheckStatus	ExprtInsurCreditCheckStatus
	ExprtInsurCreditCheckStsDesc
	PaytAuthsnCreditCheckSts	PaytAuthsnCreditCheckSts
	PaytAuthsnCreditCheckStsDesc
	CentralCreditCheckStatus	CentralCreditCheckStatus
	CentralCreditCheckStatusDesc
	_TransactionCurrency	_TransactionCurrency

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_SlsOrdFlfmtDeliveryDocQ.
-- 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: CSOFDELIVDOCQ
-- Parameters: P_Language : sylangu

CREATE VIEW C_SlsOrdFlfmtDeliveryDocQ AS
SELECT
  OutboundDelivery,
  SalesOrganization,
  ShippingPoint,
  _ShippingPoint._Text[1: Language=$parameters.P_Language].ShippingPointName AS ShippingPointName,
  CompleteDeliveryIsDefined,
  DeliveryBlockReason,
  _DeliveryBlockReason._Text[1: Language=$parameters.P_Language].DeliveryBlockReasonText AS DeliveryBlockReasonText,
  HeaderGrossWeight,
  HeaderNetWeight,
  HeaderWeightUnit,
  ActualDeliveryAmount,
  TransactionCurrency,
  TotalNumberOfPackage,
  SoldToParty,
  SoldToPartyName,
  ShipToParty,
  ShipToPartyName,
  PickingDate,
  ShippingType,
  _ShippingType._Text[1: Language=$parameters.P_Language].ShippingTypeName AS ShippingTypeName,
  DeliveryDate,
  ShippingCondition,
  _ShippingCondition._Text[1:Language=$parameters.P_Language].ShippingConditionName AS ShippingConditionName,
  TransportationPlanningDate,
  PlannedGoodsIssueDate,
  ActualGoodsMovementDate,
  IncotermsTransferLocation,
  IncotermsClassification,
  _IncotermsClassification._Text[1:Language=$parameters.P_Language].IncotermsClassificationName AS IncotermsClassificationName,
  BillingDocumentDate,
  HeaderBillingBlockReason,
  _HeaderBillingBlockReason._Text[1: Language=$parameters.P_Language].BillingBlockReasonDescription AS BillingBlockReasonDescription,
  OverallSDProcessStatus,
  _OverallSDProcessStatus._Text[1: Language=$parameters.P_Language].OverallSDProcessStatusDesc AS OverallSDProcessStatusDesc,
  OverallPickingStatus,
  _OverallPickingStatus._Text[1: Language=$parameters.P_Language].OverallPickingStatusDesc AS OverallPickingStatusDesc,
  OverallWarehouseActivityStatus,
  _OvrlWarehouseActyStatus._Text[1: Language=$parameters.P_Language].OvrlWarehouseActyStatusDesc AS OvrlWarehouseActyStatusDesc,
  OverallGoodsMovementStatus,
  _OverallGoodsMovementStatus._Text[1: Language=$parameters.P_Language].OverallGoodsMovementStatusDesc AS OverallGoodsMovementStatusDesc,
  OverallPackingStatus,
  _OverallPackingStatus._Text[1: Language=$parameters.P_Language].OverallPackingStatusDesc AS OverallPackingStatusDesc,
  TransportationPlanningStatus,
  _TransportationPlanningSts._Text[1: Language=$parameters.P_Language].TransportationPlanningStsDesc AS TransportationPlanningStsDesc,
  HdrGeneralIncompletionStatus,
  _HdrGeneralIncompletionStatus._Text[1: Language=$parameters.P_Language].HdrGenIncompletionStatusDesc AS HdrGenIncompletionStatusDesc,
  HeaderBillgIncompletionStatus,
  _HeaderBillgIncompletionStatus._Text[1: Language=$parameters.P_Language].HdrBillgIncompletionStatusDesc AS HdrBillgIncompletionStatusDesc,
  HeaderPackingIncompletionSts,
  _HeaderPackingIncompletionSts._Text[1: Language=$parameters.P_Language].HdrPackingIncompltnStatusDesc AS HdrPackingIncompltnStatusDesc,
  HeaderPickgIncompletionStatus,
  _HeaderPickgIncompletionStatus._Text[1: Language=$parameters.P_Language].HdrPickgIncompltnStatusDesc AS HdrPickgIncompltnStatusDesc,
  HeaderDelivIncompletionStatus,
  _HeaderDelivIncompletionStatus._Text[1: Language=$parameters.P_Language].HdrDelivIncompletionStatusDesc AS HdrDelivIncompletionStatusDesc,
  HdrGoodsMvtIncompletionStatus,
  _HdrGoodsMvtIncompletionStatus._Text[1: Language=$parameters.P_Language].HdrGoodsMvtIncompltnStatusDesc AS HdrGoodsMvtIncompltnStatusDesc,
  FinDocCreditCheckStatus,
  _FinDocCreditCheckStatus._Text[1: Language=$parameters.P_Language].FinDocCreditCheckStatusDesc AS FinDocCreditCheckStatusDesc,
  ExprtInsurCreditCheckStatus,
  _ExprtInsurCreditCheckStatus._Text[1: Language=$parameters.P_Language].ExprtInsurCreditCheckStsDesc AS ExprtInsurCreditCheckStsDesc,
  PaytAuthsnCreditCheckSts,
  _PaytAuthsnCreditCheckSts._Text[1: Language=$parameters.P_Language].PaytAuthsnCreditCheckStsDesc AS PaytAuthsnCreditCheckStsDesc,
  CentralCreditCheckStatus,
  _CentralCreditCheckStatus._Text[1: Language=$parameters.P_Language].CentralCreditCheckStatusDesc AS CentralCreditCheckStatusDesc
FROM I_SlsOrdFlfmtDeliveryDoc AS DeliveryDocument
;

Depth:

C_SlsOrdFlfmtDeliveryDocQ view

I_SlsOrdFlfmtDeliveryDoc view