I_PurgObjTextObjectOutpRlvnce

DDL: I_PURGOBJTEXTOBJECTOUTPRLVNCE SQL: IMMPURTXTOBJOUTP Type: view BASIC
13 Fields 1 Data Sources 5 Associations

Output Relevance of Purchasing Notes

I_PurgObjTextObjectOutpRlvnce (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Database & Data Management

I_PurgObjTextObjectOutpRlvnce is a Basic CDS View that provides data about "Output Relevance of Purchasing Notes" in SAP S/4HANA. It reads from 1 data source (t166k) and exposes 13 fields with key fields PurgOutputOperationCode, PurchasingObjectCategory, PurchasingDocumentType, TextObjectCategory, TextObjectType. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Texts in Outputs for Purchasing Documents
StatusReleased
Purpose
This CDS view retrieves data for different text IDs used in the output relevant purchasing documents. This CDS view provides the data to answer the following business questions: What is the text object type? What is the text object key? Is the text object printed in the output? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important Fields Field Name Description bstyp PurchasingObjectCategory bsart PurchasingDocumentType pstyp PurchasingDocumentItemCategory tdobject TextObjectCategory tdid TextObjectType drflg PurgTextPrintSequenceValue drpri PurgTextPrintPriorityValue txnam TextObjectKey titdr PurgTextTitleIsPrinted

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentMM
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view retrieves data for different text IDs used in the output relevant purchasing documents.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What is the text object type?</p></li> <li><p>What is the text object key?</p></li> <li><p>Is the text object printed in the output?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
t166k t166k from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_PurgOutputOperationCode _PurgOutputOperationCode $projection.PurgOutputOperationCode = _PurgOutputOperationCode.PurgOutputOperationCode
[0..1] I_PurchasingObjectCategory _PurchasingObjectCategory $projection.PurchasingObjectCategory = _PurchasingObjectCategory.PurchasingDocumentCategory
[0..1] I_PurchasingDocumentType _PurchasingDocumentType $projection.PurchasingObjectCategory = _PurchasingDocumentType.PurchasingDocumentCategory and $projection.PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType
[0..1] I_TextObjectCategory _TextObjectCategory $projection.TextObjectCategory = _TextObjectCategory.TextObjectCategory
[0..1] I_TextObjectType _TextObjectType $projection.TextObjectType = _TextObjectType.TextObjectType and $projection.TextObjectCategory = _TextObjectType.TextObjectCategory

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMMPURTXTOBJOUTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Output Relevance of Purchasing Notes view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurgOutputOperationCode druvo Indicator: Print Operation
KEY PurchasingObjectCategory bstyp Purchasing Document Category
KEY PurchasingDocumentType bsart Purchasing Document Type
KEY TextObjectCategory tdobject Texts: Application Object
KEY TextObjectType tdid Text ID Header
PurgTextPrintSequenceValue drflg Print Sequence (Order of Printing)
TextObjectKey txnam Text Name
PurgTextTitleIsPrinted titdr Print Title of Text
_PurgOutputOperationCode _PurgOutputOperationCode
_PurchasingObjectCategory _PurchasingObjectCategory
_PurchasingDocumentType _PurchasingDocumentType
_TextObjectCategory _TextObjectCategory
_TextObjectType _TextObjectType

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 I_PurgObjTextObjectOutpRlvnce.
-- 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: IMMPURTXTOBJOUTP

CREATE VIEW I_PurgObjTextObjectOutpRlvnce AS
SELECT
  druvo AS PurgOutputOperationCode,
  bstyp AS PurchasingObjectCategory,
  bsart AS PurchasingDocumentType,
  tdobject AS TextObjectCategory,
  tdid AS TextObjectType,
  drflg AS PurgTextPrintSequenceValue,
  txnam AS TextObjectKey,
  titdr AS PurgTextTitleIsPrinted
FROM t166k
LEFT OUTER JOIN I_PurgOutputOperationCode AS _PurgOutputOperationCode ON PurgOutputOperationCode = _PurgOutputOperationCode.PurgOutputOperationCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingObjectCategory AS _PurchasingObjectCategory ON PurchasingObjectCategory = _PurchasingObjectCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON PurchasingObjectCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_TextObjectCategory AS _TextObjectCategory ON TextObjectCategory = _TextObjectCategory.TextObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_TextObjectType AS _TextObjectType ON TextObjectType = _TextObjectType.TextObjectType AND TextObjectCategory = _TextObjectType.TextObjectCategory  -- association [0..1]
;

Learn More