R_CustomerReturnTextTP

DDL: R_CUSTOMERRETURNTEXTTP Type: view_entity TRANSACTIONAL
15 Fields 3 Data Sources 3 Associations

Returns Order - Text TP

R_CustomerReturnTextTP is a Transactional CDS View that provides data about "Returns Order - Text TP" in SAP S/4HANA. It reads from 3 data sources (P_SalesDocumentText, I_SalesDocumentBasic, I_SalesDocumentType) and exposes 15 fields with key fields CustomerReturn, Language, LongTextID. It has 3 associations to related views.

Data Sources (3)

SourceAliasJoin Type
P_SalesDocumentText P_SalesDocumentText from
I_SalesDocumentBasic SalesDocumentBasic inner
I_SalesDocumentType SalesDocumentType inner

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_TextDeterminationProcedItem _TextDeterminationProcedItem $projection.TextDeterminationProcedure = _TextDeterminationProcedItem.TextDeterminationProcedure and $projection.LongTextID = _TextDeterminationProcedItem.LongTextID and _TextDeterminationProcedItem.TextObjectCategory = 'VBBK'
[0..1] I_Language _Language $projection.LanguageForEdit = _Language.Language
[0..1] I_SDDocumentLongTextID _LongTextID $projection.LongTextIDForEdit = _LongTextID.LongTextID

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Returns Order - Text TP view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn
KEY Language CustomerReturnText Language Report Text Language
KEY LongTextID CustomerReturnText LongTextID Text ID
LongTextIDForEdit CustomerReturnText LongTextID Text ID
LanguageForEdit CustomerReturnText Language Report Text Language
LongText CustomerReturnText LongText Text Name
TextDeterminationProcedure I_SalesDocumentType TextDeterminationProcedure
TextDeterminationProcedureItem _TextDeterminationProcedItem TextDeterminationProcedureItem
CustomerReturnType _CustomerReturn CustomerReturnType
SalesOrganization _CustomerReturn SalesOrganization Sales Organization
DistributionChannel _CustomerReturn DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _CustomerReturn OrganizationDivision Org. Division
_CustomerReturn _CustomerReturn
_Language _Language
_LongTextID _LongTextID

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 R_CustomerReturnTextTP.
-- 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 R_CustomerReturnTextTP AS
SELECT
  cast(CustomerReturnText.SalesDocument as vdm_customer_return preserving type) AS CustomerReturn,
  CustomerReturnText.Language AS Language,
  CustomerReturnText.LongTextID AS LongTextID,
  CustomerReturnText.LongTextID AS LongTextIDForEdit,
  CustomerReturnText.Language AS LanguageForEdit,
  CustomerReturnText.LongText AS LongText,
  SalesDocumentType.TextDeterminationProcedure AS TextDeterminationProcedure,
  _TextDeterminationProcedItem.TextDeterminationProcedureItem AS TextDeterminationProcedureItem,
  _CustomerReturn.CustomerReturnType AS CustomerReturnType,
  _CustomerReturn.SalesOrganization AS SalesOrganization,
  _CustomerReturn.DistributionChannel AS DistributionChannel,
  _CustomerReturn.OrganizationDivision AS OrganizationDivision
FROM P_SalesDocumentText
INNER JOIN I_SalesDocumentBasic AS SalesDocumentBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentType AS SalesDocumentType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TextDeterminationProcedItem AS _TextDeterminationProcedItem ON TextDeterminationProcedure = _TextDeterminationProcedItem.TextDeterminationProcedure AND LongTextID = _TextDeterminationProcedItem.LongTextID AND _TextDeterminationProcedItem.TextObjectCategory = 'VBBK'  -- association [0..*]
LEFT OUTER JOIN I_Language AS _Language ON LanguageForEdit = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentLongTextID AS _LongTextID ON LongTextIDForEdit = _LongTextID.LongTextID  -- association [0..1]
;

Learn More