I_ProcmtHubPurgDocTypeText

DDL: I_PROCMTHUBPURGDOCTYPETEXT SQL: ICPODOCTYPTEXT Type: view BASIC
7 Fields 1 Data Sources 1 Associations

Document type text view basic

I_ProcmtHubPurgDocTypeText is a Basic CDS View that provides data about "Document type text view basic" in SAP S/4HANA. It reads from 1 data source (mmpur_ext_t161t) and exposes 7 fields with key fields Client, Language, PurchasingDocumentType, PurchasingDocumentCategory, ExtSourceSystem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
mmpur_ext_t161t mmpur_ext_t161t from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ProcmtHubPurgDocType _ProcmtHubPurgDocType $projection.PurchasingDocumentType = _ProcmtHubPurgDocType.PurchasingDocumentType and $projection.PurchasingDocumentCategory = _ProcmtHubPurgDocType.PurchasingDocumentCategory

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICPODOCTYPTEXT view
ObjectModel.representativeKey PurchasingDocumentType view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Document type text view basic view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Client mandt Editing Client
KEY Language language Report Text Language
KEY PurchasingDocumentType documenttype Order Type
KEY PurchasingDocumentCategory documentcategory Document Category
KEY ExtSourceSystem extsourcesystem Connected System ID
PurchasingDocumentTypeName documenttypename Description
_ProcmtHubPurgDocType _ProcmtHubPurgDocType

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_ProcmtHubPurgDocTypeText.
-- 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: ICPODOCTYPTEXT

CREATE VIEW I_ProcmtHubPurgDocTypeText AS
SELECT
  mandt AS Client,
  Language,
  documenttype AS PurchasingDocumentType,
  documentcategory AS PurchasingDocumentCategory,
  ExtSourceSystem,
  documenttypename AS PurchasingDocumentTypeName
FROM mmpur_ext_t161t
LEFT OUTER JOIN I_ProcmtHubPurgDocType AS _ProcmtHubPurgDocType ON PurchasingDocumentType = _ProcmtHubPurgDocType.PurchasingDocumentType AND PurchasingDocumentCategory = _ProcmtHubPurgDocType.PurchasingDocumentCategory  -- association [1..*]
;

Learn More