R_SlsSchedgAgrmtTextTP

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

Sales Scheduling Agreement - Text TP

R_SlsSchedgAgrmtTextTP is a Transactional CDS View that provides data about "Sales Scheduling Agreement - 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 SalesSchedulingAgreement, 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
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.dataCategory #TEXT view
EndUserText.label Sales Scheduling Agreement - Text TP view

Fields (15)

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