R_DebitMemoRequestTextTP

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

Debit Memo Request - Text TP

R_DebitMemoRequestTextTP is a Transactional CDS View that provides data about "Debit Memo Request - 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 DebitMemoRequest, 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 (9)

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 Debit Memo Request - Text TP view
ObjectModel.dataCategory #TEXT view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY DebitMemoRequest
KEY Language DebitMemoRequestText Language Report Text Language
KEY LongTextID DebitMemoRequestText LongTextID Text ID
LongTextIDForEdit DebitMemoRequestText LongTextID Text ID
LanguageForEdit DebitMemoRequestText Language Report Text Language
LongText DebitMemoRequestText LongText Text Name
TextDeterminationProcedure I_SalesDocumentType TextDeterminationProcedure
TextDeterminationProcedureItem _TextDeterminationProcedItem TextDeterminationProcedureItem
DebitMemoRequestType _DebitMemoRequest DebitMemoRequestType
SalesOrganization _DebitMemoRequest SalesOrganization Sales Organization
DistributionChannel _DebitMemoRequest DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _DebitMemoRequest OrganizationDivision Org. Division
_DebitMemoRequest _DebitMemoRequest
_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_DebitMemoRequestTextTP.
-- 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_DebitMemoRequestTextTP AS
SELECT
  cast(DebitMemoRequestText.SalesDocument as debit_memo_request preserving type) AS DebitMemoRequest,
  DebitMemoRequestText.Language AS Language,
  DebitMemoRequestText.LongTextID AS LongTextID,
  DebitMemoRequestText.LongTextID AS LongTextIDForEdit,
  DebitMemoRequestText.Language AS LanguageForEdit,
  DebitMemoRequestText.LongText AS LongText,
  SalesDocumentType.TextDeterminationProcedure AS TextDeterminationProcedure,
  _TextDeterminationProcedItem.TextDeterminationProcedureItem AS TextDeterminationProcedureItem,
  _DebitMemoRequest.DebitMemoRequestType AS DebitMemoRequestType,
  _DebitMemoRequest.SalesOrganization AS SalesOrganization,
  _DebitMemoRequest.DistributionChannel AS DistributionChannel,
  _DebitMemoRequest.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