I_PurchasingDocumentType

DDL: I_PURCHASINGDOCUMENTTYPE SQL: IMMPURGDOCTYP Type: view BASIC
9 Fields 1 Data Sources 2 Associations

Purchasing Document Type

I_PurchasingDocumentType (Basic)

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

PurchasingDocumentType · Database & Data Management

I_PurchasingDocumentType is a Basic CDS View (Dimension) that provides data about "Purchasing Document Type" in SAP S/4HANA. It reads from 1 data source (t161) and exposes 9 fields with key fields PurchasingDocumentCategory, PurchasingDocumentType. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentMM
CapabilitiesData Source for Search, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t161 t161 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocumentCategory _Category $projection.PurchasingDocumentCategory = _Category.PurchasingDocumentCategory
[0..*] I_PurchasingDocumentTypeText _Text

Annotations (18)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PurchasingDocumentType view
ObjectModel.sapObjectNodeType.name PurchasingDocumentType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.sqlViewName IMMPURGDOCTYP view
EndUserText.label Purchasing Document Type view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
Search.searchable true view
Analytics.dataExtraction.enabled true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentCategory bstyp Purchasing Document Category
KEY PurchasingDocumentType bsart Purchasing Document Type
PurchasingDocumentSubtype bsakz Control indicator for purchasing document type
PurgDocFieldSelControlKey brefn Field Selection Key
PurgHasFlxblWorkflowApproval scnr_based_wfl Flexible Workflow
IsPurReqnOvrlRel gsfrg Overall release of purchase requisitions
PartnerDeterminationProcedure pargr Partner Determination Procedure
_Text _Text
_Category _Category

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_PurchasingDocumentType.
-- 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: IMMPURGDOCTYP

CREATE VIEW I_PurchasingDocumentType AS
SELECT
  bstyp AS PurchasingDocumentCategory,
  bsart AS PurchasingDocumentType,
  bsakz AS PurchasingDocumentSubtype,
  brefn AS PurgDocFieldSelControlKey,
  scnr_based_wfl AS PurgHasFlxblWorkflowApproval,
  gsfrg AS IsPurReqnOvrlRel,
  pargr AS PartnerDeterminationProcedure
FROM t161
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _Category ON PurchasingDocumentCategory = _Category.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More