A_CustProjSlsOrdItemText

DDL: A_CUSTPROJSLSORDITEMTEXT SQL: ACUSTPROJSOITXT Type: view COMPOSITE Package: SD_SLS_PBS
11 Fields 2 Data Sources 1 Associations

Sales Order Item Text

A_CustProjSlsOrdItemText is a Composite CDS View that provides data about "Sales Order Item Text" in SAP S/4HANA. It reads from 2 data sources (I_CustProjSlsOrdItem, P_SalesDocumentItemText) and exposes 11 fields with key fields CustomerProject, SalesOrderItem, Language, LongTextID. It has 1 association to related views. Part of development package SD_SLS_PBS.

Data Sources (2)

SourceAliasJoin Type
I_CustProjSlsOrdItem CustProjSlsOrdItem inner
P_SalesDocumentItemText P_SalesDocumentItemText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_CustProjSlsOrdItem _CustProjSlsOrdItem _CustProjSlsOrdItem.CustomerProject = $projection.CustomerProject and _CustProjSlsOrdItem.SalesOrderItem = $projection.SalesOrderItem

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ACUSTPROJSOITXT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Order Item Text view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CustomerProject I_CustProjSlsOrdItem CustomerProject Engmnt Project ID
KEY SalesOrderItem I_CustProjSlsOrdItem SalesOrderItem Sales Order Item
KEY Language Language Report Text Language
KEY LongTextID LongTextID Text ID
LongText LongText Text Name
SalesOrder
SalesOrderType I_CustProjSlsOrdItem SalesOrderType Sales Order Type
OrganizationDivision I_CustProjSlsOrdItem OrganizationDivision Org. Division
SalesOrganization I_CustProjSlsOrdItem SalesOrganization Sales Organization
DistributionChannel I_CustProjSlsOrdItem DistributionChannel RefDistCh-Cust/Mat.
_CustProjSlsOrdItem _CustProjSlsOrdItem

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 A_CustProjSlsOrdItemText.
-- 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: ACUSTPROJSOITXT

CREATE VIEW A_CustProjSlsOrdItemText AS
SELECT
  CustProjSlsOrdItem.CustomerProject AS CustomerProject,
  CustProjSlsOrdItem.SalesOrderItem AS SalesOrderItem,
  Language,
  LongTextID,
  LongText,
  cast(CustProjSalesOrderItemText.SalesDocument as vdm_sales_order preserving type) AS SalesOrder,
  CustProjSlsOrdItem.SalesOrderType AS SalesOrderType,
  CustProjSlsOrdItem.OrganizationDivision AS OrganizationDivision,
  CustProjSlsOrdItem.SalesOrganization AS SalesOrganization,
  CustProjSlsOrdItem.DistributionChannel AS DistributionChannel
FROM P_SalesDocumentItemText
INNER JOIN I_CustProjSlsOrdItem AS CustProjSlsOrdItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_CustProjSlsOrdItem AS _CustProjSlsOrdItem ON _CustProjSlsOrdItem.CustomerProject = CustomerProject AND _CustProjSlsOrdItem.SalesOrderItem = SalesOrderItem  -- association [1..1]
;

Learn More