C_SlsOrdReqItmFrmExtSourceTP

DDL: C_SLSORDREQITMFRMEXTSOURCETP Type: view_entity CONSUMPTION
16 Fields 1 Data Sources 1 OData Services

Projection for Sls Ord Req Itm

C_SlsOrdReqItmFrmExtSourceTP is a Consumption CDS View that provides data about "Projection for Sls Ord Req Itm" in SAP S/4HANA. It reads from 1 data source (R_SalesOrderRequestItemTP) and exposes 16 fields with key fields SalesOrderRequest, SalesOrderRequestItem. It is exposed through 1 OData service (C_SLSORDREQFRMEXTSOURCE_SD).

Data Sources (1)

SourceAliasJoin Type
R_SalesOrderRequestItemTP R_SalesOrderRequestItemTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
OData.entitySet.name SalesOrderRequestItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Projection for Sls Ord Req Itm view

OData Services (1)

ServiceBindingVersionContractRelease
C_SLSORDREQFRMEXTSOURCE_SD C_SLSORDREQFRMEXTSRC_SRV V4 C1 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest SalesOrderRequestItem SalesOrderRequest Sales Order Request
KEY SalesOrderRequestItem SalesOrderRequestItem SalesOrderRequestItem Item
Product SalesOrderRequestItem Product Product Sold
ProductNameasProductNamelocalized
RequestedQuantity SalesOrderRequestItem RequestedQuantity Requested Quantity
RequestedQuantityUnit SalesOrderRequestItem RequestedQuantityUnit Requested Quantity Unit
RequestedDeliveryDate SalesOrderRequestItem RequestedDeliveryDate Requested Delivery Date
UnderlyingPurchaseOrderItem SalesOrderRequestItem UnderlyingPurchaseOrderItem PO Item
ExtractedCustomerMaterial
ExtractedProduct
ExtractedProductDescription
CustomerUnitPrice
ExtractedPOItemNetAmount
TransactionCurrency
CurrencyNameasCurrencyNamelocalized
MaterialByCustomer MaterialByCustomer Customer Mat.

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_SlsOrdReqItmFrmExtSourceTP.
-- 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.

CREATE VIEW C_SlsOrdReqItmFrmExtSourceTP AS
SELECT
  SalesOrderRequestItem.SalesOrderRequest AS SalesOrderRequest,
  SalesOrderRequestItem.SalesOrderRequestItem AS SalesOrderRequestItem,
  SalesOrderRequestItem.Product AS Product,
  SalesOrderRequestItem._Product._Text.ProductName as ProductName : localized AS ProductNameasProductNamelocalized,
  SalesOrderRequestItem.RequestedQuantity AS RequestedQuantity,
  SalesOrderRequestItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  SalesOrderRequestItem.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesOrderRequestItem.UnderlyingPurchaseOrderItem AS UnderlyingPurchaseOrderItem,
  SalesOrderRequestItem._SourceItem.ExtractedCustomerMaterial AS ExtractedCustomerMaterial,
  SalesOrderRequestItem._SourceItem.ExtractedProduct AS ExtractedProduct,
  SalesOrderRequestItem._SourceItem.ExtractedProductDescription AS ExtractedProductDescription,
  SalesOrderRequestItem._SourceItem.CustomerUnitPrice AS CustomerUnitPrice,
  SalesOrderRequestItem._SourceItem.ExtractedPOItemNetAmount AS ExtractedPOItemNetAmount,
  SalesOrderRequestItem._SourceItem.TransactionCurrency AS TransactionCurrency,
  SalesOrderRequestItem._SourceItem._TransactionCurrency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized,
  MaterialByCustomer
FROM R_SalesOrderRequestItemTP
;

Learn More