C_SlsOrdFlfmtSalesOrderQ
SOFM Sales Order Query
C_SlsOrdFlfmtSalesOrderQ is a Consumption CDS View that provides data about "SOFM Sales Order Query" in SAP S/4HANA. It reads from 1 data source (I_SlsOrdFlfmtSalesOrder) and exposes 77 fields with key field SalesOrder. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SlsOrdFlfmtSalesOrder | SalesDocument | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_Language | sylangu |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_SalesDocumentBasic | _Extension | SalesDocument.SalesOrder = _Extension.SalesDocument |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| EndUserText.label | SOFM Sales Order Query | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| AbapCatalog.sqlViewName | CSOFSLSORDQ | view |
Fields (77)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesOrder | SalesOrder | SD Document | |
| SalesOrderType | SalesOrderType | Sales Order Type | ||
| SalesOrderTypeName | ||||
| SDDocumentCategory | SDDocumentCategory | Document Cat. | ||
| CreationDate | CreationDate | Time Stamp | ||
| CreatedByUser | CreatedByUser | User Name | ||
| CreationTime | CreationTime | Time of Change | ||
| LastChangeDate | LastChangeDate | Time Stamp | ||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| SalesOrganizationName | ||||
| DistributionChannel | DistributionChannel | RefDistCh-Cust/Mat. | ||
| DistributionChannelName | ||||
| OrganizationDivision | OrganizationDivision | Org. Division | ||
| DivisionName | ||||
| SalesOffice | SalesOffice | Sales Office | ||
| SalesGroup | SalesGroup | Sales Group | ||
| SoldToParty | SoldToParty | Sold-to Party | ||
| SoldToPartyName | SoldToPartyName | Sold-to Party Name | ||
| ShipToParty | ShipToParty | Ship-To Party (obsolete) | ||
| ShipToPartyName | ShipToPartyName | Ship-To Party Name | ||
| BillToParty | BillToParty | Inv. Recipient | ||
| BillToPartyName | BillToPartyName | |||
| PayerParty | PayerParty | Payer | ||
| PayerPartyName | PayerPartyName | |||
| CustomerClassification | CustomerClassification | Customer Class. | ||
| CustomerClassificationDesc | ||||
| SalesOrderDate | SalesOrderDate | Document Date | ||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | Purchase Order Number | ||
| NextCreditCheckDate | NextCreditCheckDate | |||
| TotalNetAmount | TotalNetAmount | Total Net Amount | ||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| CompleteDeliveryIsDefined | CompleteDeliveryIsDefined | Complete Dlv. | ||
| DeliveryBlockReason | DeliveryBlockReason | Delivery Block | ||
| DeliveryBlockReasonText | ||||
| RequestedDeliveryDate | RequestedDeliveryDate | Requested Delivery Date | ||
| ShippingCondition | ShippingCondition | Shipping Conditions | ||
| ShippingConditionName | ||||
| IncotermsClassification | IncotermsClassification | Incoterms | ||
| IncotermsClassificationName | ||||
| IncotermsTransferLocation | IncotermsTransferLocation | Incoterms 2 | ||
| IncotermsLocation1 | IncotermsLocation1 | Inco. Location1 | ||
| IncotermsLocation2 | IncotermsLocation2 | Inco. Location2 | ||
| IncotermsVersion | IncotermsVersion | Inco. Version | ||
| IncotermsVersionName | ||||
| ShippingType | ShippingType | Shipping Type | ||
| ShippingTypeName | ||||
| HeaderBillingBlockReason | HeaderBillingBlockReason | Billing Block | ||
| BillingBlockReasonDescription | ||||
| BillingDocumentDate | BillingDocumentDate | Billing Date | ||
| CustomerPaymentTerms | CustomerPaymentTerms | Pyt Terms | ||
| CustomerPaymentTermsName | ||||
| OverallSDDocumentRejectionSts | OverallSDDocumentRejectionSts | |||
| OverallDelivConfStatus | OverallDelivConfStatus | |||
| OverallDeliveryStatus | OverallDeliveryStatus | |||
| HdrGeneralIncompletionStatus | HdrGeneralIncompletionStatus | |||
| HdrGenIncompletionStatusDesc | ||||
| HeaderDelivIncompletionStatus | HeaderDelivIncompletionStatus | |||
| HdrDelivIncompletionStatusDesc | ||||
| OverallPricingIncompletionSts | OverallPricingIncompletionSts | |||
| OverallPrcIncompletionStsDesc | ||||
| HeaderBillgIncompletionStatus | HeaderBillgIncompletionStatus | |||
| HdrBillgIncompletionStatusDesc | ||||
| FinDocCreditCheckStatus | FinDocCreditCheckStatus | |||
| FinDocCreditCheckStatusDesc | ||||
| ExprtInsurCreditCheckStatus | ExprtInsurCreditCheckStatus | |||
| ExprtInsurCreditCheckStsDesc | ||||
| PaytAuthsnCreditCheckSts | PaytAuthsnCreditCheckSts | |||
| PaytAuthsnCreditCheckStsDesc | ||||
| CentralCreditCheckStatus | CentralCreditCheckStatus | |||
| CentralCreditCheckStatusDesc | ||||
| CtrlgObjStatusIsDeliveryBlkd | ||||
| CtrlgObjStatusIsBillingBlkd | ||||
| CtrlgObjStatusIsDeliveryBlkd | ||||
| CtrlgObjStatusIsBillingBlkd | ||||
| CustomerProject | CustomerProject | Engmnt Project ID | ||
| CustomerProjectName | CustomerProjectName | |||
| _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_SlsOrdFlfmtSalesOrderQ.
-- 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: CSOFSLSORDQ
-- Parameters: P_Language : sylangu
CREATE VIEW C_SlsOrdFlfmtSalesOrderQ AS
SELECT
SalesOrder,
SalesOrderType,
_SalesOrderType._Text[1: Language=$parameters.P_Language].SalesDocumentTypeName AS SalesOrderTypeName,
SDDocumentCategory,
CreationDate,
CreatedByUser,
CreationTime,
LastChangeDate,
SalesOrganization,
_SalesOrganization._Text[1: Language=$parameters.P_Language].SalesOrganizationName AS SalesOrganizationName,
DistributionChannel,
_DistributionChannel._Text[1: Language=$parameters.P_Language].DistributionChannelName AS DistributionChannelName,
OrganizationDivision,
_OrganizationDivision._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
SalesOffice,
SalesGroup,
SoldToParty,
SoldToPartyName,
ShipToParty,
ShipToPartyName,
BillToParty,
BillToPartyName,
PayerParty,
PayerPartyName,
CustomerClassification,
_CustomerClassification._Text[1: Language=$parameters.P_Language].CustomerClassificationDesc AS CustomerClassificationDesc,
SalesOrderDate,
PurchaseOrderByCustomer,
NextCreditCheckDate,
TotalNetAmount,
TransactionCurrency,
CompleteDeliveryIsDefined,
DeliveryBlockReason,
_DeliveryBlockReason._Text[1: Language=$parameters.P_Language].DeliveryBlockReasonText AS DeliveryBlockReasonText,
RequestedDeliveryDate,
ShippingCondition,
_ShippingCondition._Text[1: Language=$parameters.P_Language].ShippingConditionName AS ShippingConditionName,
IncotermsClassification,
_IncotermsClassification._Text[1:Language=$parameters.P_Language].IncotermsClassificationName AS IncotermsClassificationName,
IncotermsTransferLocation,
IncotermsLocation1,
IncotermsLocation2,
IncotermsVersion,
_IncotermsVersion._Text[1:Language=$parameters.P_Language].IncotermsVersionName AS IncotermsVersionName,
ShippingType,
_ShippingType._Text[1: Language=$parameters.P_Language].ShippingTypeName AS ShippingTypeName,
HeaderBillingBlockReason,
_HeaderBillingBlockReason._Text[1: Language=$parameters.P_Language].BillingBlockReasonDescription AS BillingBlockReasonDescription,
BillingDocumentDate,
CustomerPaymentTerms,
_CustomerPaymentTerms._Text[1: Language=$parameters.P_Language].CustomerPaymentTermsName AS CustomerPaymentTermsName,
OverallSDDocumentRejectionSts,
OverallDelivConfStatus,
OverallDeliveryStatus,
HdrGeneralIncompletionStatus,
_HdrGeneralIncompletionStatus._Text[1: Language=$parameters.P_Language].HdrGenIncompletionStatusDesc AS HdrGenIncompletionStatusDesc,
HeaderDelivIncompletionStatus,
_HeaderDelivIncompletionStatus._Text[1: Language=$parameters.P_Language].HdrDelivIncompletionStatusDesc AS HdrDelivIncompletionStatusDesc,
OverallPricingIncompletionSts,
_OverallPricingIncompletionSts._Text[1: Language=$parameters.P_Language].OverallPrcIncompletionStsDesc AS OverallPrcIncompletionStsDesc,
HeaderBillgIncompletionStatus,
_HeaderBillgIncompletionStatus._Text[1: Language=$parameters.P_Language].HdrBillgIncompletionStatusDesc AS HdrBillgIncompletionStatusDesc,
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,
cast( _ConObjStatusDelBlocked.CtrlgObjStatusIsDeliveryBlkd as user_status_deliv_block ) AS CtrlgObjStatusIsDeliveryBlkd,
cast( _ConObjStatusBillgBlocked.CtrlgObjStatusIsBillingBlkd as user_status_inv_block ) AS CtrlgObjStatusIsBillingBlkd,
CustomerProject,
CustomerProjectName
FROM I_SlsOrdFlfmtSalesOrder AS SalesDocument
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument.SalesOrder = _Extension.SalesDocument -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA