What is I_PPS_PurchasingDocument in SAP S/4HANA?

I_PPS_PurchasingDocument is a basic CDS view in SAP S/4HANA. Purchasing Document It contains 121 fields.

Which tables does I_PPS_PurchasingDocument read from?

I_PPS_PurchasingDocument reads data from: R_PurchasingDocument, t161.

What VDM layer is I_PPS_PurchasingDocument?

I_PPS_PurchasingDocument is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PPS_PurchasingDocument

DDL: I_PPS_PURCHASINGDOCUMENT Type: view_entity BASIC

121 Fields 2 Data Sources 1 Associations

Purchasing Document

I_PPS_PurchasingDocument is a Basic CDS View that provides data about "Purchasing Document" in SAP S/4HANA. It reads from 2 data sources (R_PurchasingDocument, t161) and exposes 121 fields with key field PurchasingDocument. It has 1 association to related views.

Data Sources (2)

Source	Alias	Join Type
R_PurchasingDocument	R_PurchasingDocument	from
t161	t161	inner

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_PPS_PurgDocumentExtension	_Extension	`$projection.PurchasingDocument = _Extension.PurchasingDocument`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Purchasing Document	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#BASIC	view

Fields (121)

Key	Field	Source Table	Source Field	Description
KEY	PurchasingDocument	R_PurchasingDocument	PurchasingDocument	Purchasing Document
	PurchasingDocumentCategory	R_PurchasingDocument	PurchasingDocumentCategory	Doc. Category
	PurchasingDocumentType	R_PurchasingDocument	PurchasingDocumentType	RFQ Type
	PurchasingDocumentSubtype	R_PurchasingDocument	PurchasingDocumentSubtype	Control
	PurchasingDocumentProcessCode	R_PurchasingDocument	PurchasingDocumentProcessCode	Process Indicator
	CompanyCode	R_PurchasingDocument	CompanyCode	Receiver Company Code
	PurchasingDocumentDeletionCode	R_PurchasingDocument	PurchasingDocumentDeletionCode	Del. Indicator
	PurchasingDocumentIsAged	R_PurchasingDocument	PurchasingDocumentIsAged	Document aged
	ItemNumberInterval	R_PurchasingDocument	ItemNumberInterval	Item Interval
	ItemNumberIntervalForSubItems	R_PurchasingDocument	ItemNumberIntervalForSubItems	Subitem Interv.
	PurchasingDocumentOrigin	R_PurchasingDocument	PurchasingDocumentOrigin	Status
	ReleaseIsNotCompleted	R_PurchasingDocument	ReleaseIsNotCompleted	Subj.to Release
	ReleaseCode	R_PurchasingDocument	ReleaseCode	Release ind.
	PurchasingReleaseStrategy	R_PurchasingDocument	PurchasingReleaseStrategy	Rel. Strategy
	PurgReleaseSequenceStatus	R_PurchasingDocument	PurgReleaseSequenceStatus	Release State
	TaxReturnCountry	R_PurchasingDocument	TaxReturnCountry	Reporting C/R
	CreationDate	R_PurchasingDocument	CreationDate	Time Stamp
	LastChangeDateTime	R_PurchasingDocument	LastChangeDateTime	Timestamp
	CreatedByUser	R_PurchasingDocument	CreatedByUser	User Name
	Supplier	R_PurchasingDocument	Supplier	Supplier
	SupplierRespSalesPersonName	R_PurchasingDocument	SupplierRespSalesPersonName	Salesperson
	SupplierPhoneNumber	R_PurchasingDocument	SupplierPhoneNumber	Telephone
	ManualSupplierAddressID	R_PurchasingDocument	ManualSupplierAddressID	Address Number
	CorrespncExternalReference	R_PurchasingDocument	CorrespncExternalReference	Your Reference
	CorrespncInternalReference	R_PurchasingDocument	CorrespncInternalReference	Our Reference
	PurchasingOrganization	R_PurchasingDocument	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	R_PurchasingDocument	PurchasingGroup	Purchasing Group
	DocumentCurrency	R_PurchasingDocument	DocumentCurrency	Document Currency
	ExchangeRate	R_PurchasingDocument	ExchangeRate	Exchange rate
	PurchasingDocumentOrderDate	R_PurchasingDocument	PurchasingDocumentOrderDate	PO Date
	SupplyingSupplier	R_PurchasingDocument	SupplyingSupplier	Goods Supplier
	SupplyingPlant	R_PurchasingDocument	SupplyingPlant	Supplying Plant
	InvoicingParty	R_PurchasingDocument	InvoicingParty	Supplier
	Customer	R_PurchasingDocument	Customer	Sold-to Party
	PurchaseContract	R_PurchasingDocument	PurchaseContract	Purchasing Doc.
	Language	R_PurchasingDocument	Language	Report Text Language
	PurgReasonForDocCancellation	R_PurchasingDocument	PurgReasonForDocCancellation	Reas. for Canc.
	PurchasingCompletenessStatus	R_PurchasingDocument	PurchasingCompletenessStatus	Incomplete
	IncotermsClassification	R_PurchasingDocument	IncotermsClassification	Incoterms
	IncotermsTransferLocation	R_PurchasingDocument	IncotermsTransferLocation	Incoterms 2
	PaymentTerms	R_PurchasingDocument	PaymentTerms	Pyt Terms
	CashDiscount1Days	R_PurchasingDocument	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	R_PurchasingDocument	CashDiscount2Days	Days from Baseline Date for Payment
	NetPaymentDays	R_PurchasingDocument	NetPaymentDays	Net Pmt Terms Period
	CashDiscount1Percent	R_PurchasingDocument	CashDiscount1Percent	Disc. Percent 1
	CashDiscount2Percent	R_PurchasingDocument	CashDiscount2Percent	Disc. Percent 2
	PricingProcedure	R_PurchasingDocument	PricingProcedure	Procedure
	TargetAmount	R_PurchasingDocument	TargetAmount	Target Value
	PurgDocumentDistributionType	R_PurchasingDocument	PurgDocumentDistributionType	Distribution Type
	PricingDocument	R_PurchasingDocument	PricingDocument	Document Condition
	ValidityStartDate	R_PurchasingDocument	ValidityStartDate	Validity Start Date
	ValidityEndDate	R_PurchasingDocument	ValidityEndDate	ValidTo
	ScheduleAgreementHasReleaseDoc	R_PurchasingDocument	ScheduleAgreementHasReleaseDoc	Release Docu.
	QuotationLatestSubmissionDate	R_PurchasingDocument	QuotationLatestSubmissionDate	Quot. Deadline
	BindingPeriodValidityEndDate	R_PurchasingDocument	BindingPeriodValidityEndDate	Binding Period
	QuotationSubmissionDate	R_PurchasingDocument	QuotationSubmissionDate	Quotation Date
	PurchasingCollectiveNumber	R_PurchasingDocument	PurchasingCollectiveNumber	Collective No.
	SupplierQuotationExternalID	R_PurchasingDocument	SupplierQuotationExternalID	Quotation
	RequestForQuotation	R_PurchasingDocument	RequestForQuotation	RFQ
	ExchangeRateIsFixed	R_PurchasingDocument	ExchangeRateIsFixed	Fixed Exch.Rate
	IncotermsVersion	R_PurchasingDocument	IncotermsVersion	Inco. Version
	IncotermsLocation1	R_PurchasingDocument	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	R_PurchasingDocument	IncotermsLocation2	Inco. Location2
	IncotermsSupChnLoc1AddlUUID	R_PurchasingDocument	IncotermsSupChnLoc1AddlUUID	Location UUID
	IncotermsSupChnLoc2AddlUUID	R_PurchasingDocument	IncotermsSupChnLoc2AddlUUID	Location UUID
	IncotermsSupChnDvtgLocAddlUUID	R_PurchasingDocument	IncotermsSupChnDvtgLocAddlUUID	Location UUID
	PurchasingProcessingStatus	R_PurchasingDocument	PurchasingProcessingStatus	Proc. State
	PurgReleaseTimeTotalAmount	R_PurchasingDocument	PurgReleaseTimeTotalAmount	Tot. val. rel.
	DownPaymentType	R_PurchasingDocument	DownPaymentType	Down Payment
	DownPaymentPercentageOfTotAmt	R_PurchasingDocument	DownPaymentPercentageOfTotAmt	Down Payment %
	DownPaymentAmount	R_PurchasingDocument	DownPaymentAmount	Downpayment
	DownPaymentDueDate	R_PurchasingDocument	DownPaymentDueDate	Due Date for DP
	RetentionType	R_PurchasingDocument	RetentionType	Retention
	PurgDocHdrInvcRtntnPct	R_PurchasingDocument	PurgDocHdrInvcRtntnPct	Retention %
	PurchasingDocumentName	R_PurchasingDocument	PurchasingDocumentName	Purch. Doc. Name
	QuotationEarliestSubmsnDate	R_PurchasingDocument	QuotationEarliestSubmsnDate	Start Date
	LatestRegistrationDate	R_PurchasingDocument	LatestRegistrationDate	Apply By
	PurgDocDefaultShippingType	R_PurchasingDocument	PurgDocDefaultShippingType	Shp.type: stage
	PurgDocFollowOnDocumentType	R_PurchasingDocument	PurgDocFollowOnDocumentType	Follow-On Document Type
	VATRegistration	R_PurchasingDocument	VATRegistration	VAT Registration No.
	VATRegistrationCountry	R_PurchasingDocument	VATRegistrationCountry	CtryRgnSlsTxNo.
	IsIntrastatReportingRelevant	R_PurchasingDocument	IsIntrastatReportingRelevant	Intrastat rel.
	IsIntrastatReportingExcluded	R_PurchasingDocument	IsIntrastatReportingExcluded	exclude Intra
	IsEndOfPurposeBlocked	R_PurchasingDocument	IsEndOfPurposeBlocked	Busin. Purp. Cmpltd.
	ActivePurchasingDocument	R_PurchasingDocument	ActivePurchasingDocument	Active Purchase Doc
	PurgDocChangeRequestStatus	R_PurchasingDocument	PurgDocChangeRequestStatus	Change Request Stat.
	PurchasingDocumentVersion	R_PurchasingDocument	PurchasingDocumentVersion	Version
	PurgDocExternalReference	R_PurchasingDocument	PurgDocExternalReference	Ext. Reference ID
	PurgProdCmplncTotDngrsGoodsSts	R_PurchasingDocument	PurgProdCmplncTotDngrsGoodsSts	Dangerous Goods Sts
	PurgAggrgdProdCmplncSuplrSts	R_PurchasingDocument	PurgAggrgdProdCmplncSuplrSts	Supplier Check Sts
	PurgAggrgdProdMarketabilitySts	R_PurchasingDocument	PurgAggrgdProdMarketabilitySts	Prod. Marktablty Sts
	PurgAggrgdSftyDataSheetStatus	R_PurchasingDocument	PurgAggrgdSftyDataSheetStatus	Sfty Data Sheet Sts
	PurchasingParentDocument	R_PurchasingDocument	PurchasingParentDocument	Parent Document ID
	ProcmtHubCompanyCodeGroupingID	R_PurchasingDocument	ProcmtHubCompanyCodeGroupingID	Grouping ID
	PurgHasCatalogRelevantItems	R_PurchasingDocument	PurgHasCatalogRelevantItems	Ctlg Item Rlvt Doc
	RetsMgmtProcess	R_PurchasingDocument	RetsMgmtProcess	Process ID No.
	_CompanyCode	R_PurchasingDocument	_CompanyCode
	_CreatedByUser	R_PurchasingDocument	_CreatedByUser
	_DocumentCurrency	R_PurchasingDocument	_DocumentCurrency
	_IncotermsClassification	R_PurchasingDocument	_IncotermsClassification
	_IncotermsVersion	R_PurchasingDocument	_IncotermsVersion
	_InvoicingParty	R_PurchasingDocument	_InvoicingParty
	_Language	R_PurchasingDocument	_Language
	_PaymentTerms	R_PurchasingDocument	_PaymentTerms
	_PricingProcedure	R_PurchasingDocument	_PricingProcedure
	_PurchaseContract	R_PurchasingDocument	_PurchaseContract
	_PurchasingDocumentCategory	R_PurchasingDocument	_PurchasingDocumentCategory
	_PurchasingDocumentItem	R_PurchasingDocument	_PurchasingDocumentItem
	_PurchasingDocumentOrigin	R_PurchasingDocument	_PurchasingDocumentOrigin
	_PurchasingDocumentPartner	R_PurchasingDocument	_PurchasingDocumentPartner
	_PurchasingDocumentType	R_PurchasingDocument	_PurchasingDocumentType
	_PurchasingGroup	R_PurchasingDocument	_PurchasingGroup
	_PurchasingOrganization	R_PurchasingDocument	_PurchasingOrganization
	_PurchasingProcessingStatus	R_PurchasingDocument	_PurchasingProcessingStatus
	_ReleaseCode	R_PurchasingDocument	_ReleaseCode
	_Supplier	R_PurchasingDocument	_Supplier
	_SupplierAddress_2	R_PurchasingDocument	_SupplierAddress_2
	_SupplyingPlant	R_PurchasingDocument	_SupplyingPlant
	_SupplyingSupplier	R_PurchasingDocument	_SupplyingSupplier
	PPSFuturePostingDate	_Extension	PPSFuturePostingDate	Future Posting Date
	_Extension		_Extension

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_PPS_PurchasingDocument.
-- 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 I_PPS_PurchasingDocument AS
SELECT
  R_PurchasingDocument.PurchasingDocument AS PurchasingDocument,
  R_PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  R_PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  R_PurchasingDocument.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  R_PurchasingDocument.PurchasingDocumentProcessCode AS PurchasingDocumentProcessCode,
  R_PurchasingDocument.CompanyCode AS CompanyCode,
  R_PurchasingDocument.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  R_PurchasingDocument.PurchasingDocumentIsAged AS PurchasingDocumentIsAged,
  R_PurchasingDocument.ItemNumberInterval AS ItemNumberInterval,
  R_PurchasingDocument.ItemNumberIntervalForSubItems AS ItemNumberIntervalForSubItems,
  R_PurchasingDocument.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  R_PurchasingDocument.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  R_PurchasingDocument.ReleaseCode AS ReleaseCode,
  R_PurchasingDocument.PurchasingReleaseStrategy AS PurchasingReleaseStrategy,
  R_PurchasingDocument.PurgReleaseSequenceStatus AS PurgReleaseSequenceStatus,
  R_PurchasingDocument.TaxReturnCountry AS TaxReturnCountry,
  R_PurchasingDocument.CreationDate AS CreationDate,
  R_PurchasingDocument.LastChangeDateTime AS LastChangeDateTime,
  R_PurchasingDocument.CreatedByUser AS CreatedByUser,
  R_PurchasingDocument.Supplier AS Supplier,
  R_PurchasingDocument.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  R_PurchasingDocument.SupplierPhoneNumber AS SupplierPhoneNumber,
  R_PurchasingDocument.ManualSupplierAddressID AS ManualSupplierAddressID,
  R_PurchasingDocument.CorrespncExternalReference AS CorrespncExternalReference,
  R_PurchasingDocument.CorrespncInternalReference AS CorrespncInternalReference,
  R_PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  R_PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  R_PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  R_PurchasingDocument.ExchangeRate AS ExchangeRate,
  R_PurchasingDocument.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  R_PurchasingDocument.SupplyingSupplier AS SupplyingSupplier,
  R_PurchasingDocument.SupplyingPlant AS SupplyingPlant,
  R_PurchasingDocument.InvoicingParty AS InvoicingParty,
  R_PurchasingDocument.Customer AS Customer,
  R_PurchasingDocument.PurchaseContract AS PurchaseContract,
  R_PurchasingDocument.Language AS Language,
  R_PurchasingDocument.PurgReasonForDocCancellation AS PurgReasonForDocCancellation,
  R_PurchasingDocument.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  R_PurchasingDocument.IncotermsClassification AS IncotermsClassification,
  R_PurchasingDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  R_PurchasingDocument.PaymentTerms AS PaymentTerms,
  R_PurchasingDocument.CashDiscount1Days AS CashDiscount1Days,
  R_PurchasingDocument.CashDiscount2Days AS CashDiscount2Days,
  R_PurchasingDocument.NetPaymentDays AS NetPaymentDays,
  R_PurchasingDocument.CashDiscount1Percent AS CashDiscount1Percent,
  R_PurchasingDocument.CashDiscount2Percent AS CashDiscount2Percent,
  R_PurchasingDocument.PricingProcedure AS PricingProcedure,
  R_PurchasingDocument.TargetAmount AS TargetAmount,
  R_PurchasingDocument.PurgDocumentDistributionType AS PurgDocumentDistributionType,
  R_PurchasingDocument.PricingDocument AS PricingDocument,
  R_PurchasingDocument.ValidityStartDate AS ValidityStartDate,
  R_PurchasingDocument.ValidityEndDate AS ValidityEndDate,
  R_PurchasingDocument.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  R_PurchasingDocument.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  R_PurchasingDocument.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  R_PurchasingDocument.QuotationSubmissionDate AS QuotationSubmissionDate,
  R_PurchasingDocument.PurchasingCollectiveNumber AS PurchasingCollectiveNumber,
  R_PurchasingDocument.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  R_PurchasingDocument.RequestForQuotation AS RequestForQuotation,
  R_PurchasingDocument.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  R_PurchasingDocument.IncotermsVersion AS IncotermsVersion,
  R_PurchasingDocument.IncotermsLocation1 AS IncotermsLocation1,
  R_PurchasingDocument.IncotermsLocation2 AS IncotermsLocation2,
  R_PurchasingDocument.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  R_PurchasingDocument.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  R_PurchasingDocument.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  R_PurchasingDocument.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  R_PurchasingDocument.PurgReleaseTimeTotalAmount AS PurgReleaseTimeTotalAmount,
  R_PurchasingDocument.DownPaymentType AS DownPaymentType,
  R_PurchasingDocument.DownPaymentPercentageOfTotAmt AS DownPaymentPercentageOfTotAmt,
  R_PurchasingDocument.DownPaymentAmount AS DownPaymentAmount,
  R_PurchasingDocument.DownPaymentDueDate AS DownPaymentDueDate,
  R_PurchasingDocument.RetentionType AS RetentionType,
  R_PurchasingDocument.PurgDocHdrInvcRtntnPct AS PurgDocHdrInvcRtntnPct,
  R_PurchasingDocument.PurchasingDocumentName AS PurchasingDocumentName,
  R_PurchasingDocument.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  R_PurchasingDocument.LatestRegistrationDate AS LatestRegistrationDate,
  R_PurchasingDocument.PurgDocDefaultShippingType AS PurgDocDefaultShippingType,
  R_PurchasingDocument.PurgDocFollowOnDocumentType AS PurgDocFollowOnDocumentType,
  R_PurchasingDocument.VATRegistration AS VATRegistration,
  R_PurchasingDocument.VATRegistrationCountry AS VATRegistrationCountry,
  R_PurchasingDocument.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  R_PurchasingDocument.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  R_PurchasingDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  R_PurchasingDocument.ActivePurchasingDocument AS ActivePurchasingDocument,
  R_PurchasingDocument.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  R_PurchasingDocument.PurchasingDocumentVersion AS PurchasingDocumentVersion,
  R_PurchasingDocument.PurgDocExternalReference AS PurgDocExternalReference,
  R_PurchasingDocument.PurgProdCmplncTotDngrsGoodsSts AS PurgProdCmplncTotDngrsGoodsSts,
  R_PurchasingDocument.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  R_PurchasingDocument.PurgAggrgdProdMarketabilitySts AS PurgAggrgdProdMarketabilitySts,
  R_PurchasingDocument.PurgAggrgdSftyDataSheetStatus AS PurgAggrgdSftyDataSheetStatus,
  R_PurchasingDocument.PurchasingParentDocument AS PurchasingParentDocument,
  R_PurchasingDocument.ProcmtHubCompanyCodeGroupingID AS ProcmtHubCompanyCodeGroupingID,
  R_PurchasingDocument.PurgHasCatalogRelevantItems AS PurgHasCatalogRelevantItems,
  R_PurchasingDocument.RetsMgmtProcess AS RetsMgmtProcess,
  R_PurchasingDocument._CompanyCode AS _CompanyCode,
  R_PurchasingDocument._CreatedByUser AS _CreatedByUser,
  R_PurchasingDocument._DocumentCurrency AS _DocumentCurrency,
  R_PurchasingDocument._IncotermsClassification AS _IncotermsClassification,
  R_PurchasingDocument._IncotermsVersion AS _IncotermsVersion,
  R_PurchasingDocument._InvoicingParty AS _InvoicingParty,
  R_PurchasingDocument._Language AS _Language,
  R_PurchasingDocument._PaymentTerms AS _PaymentTerms,
  R_PurchasingDocument._PricingProcedure AS _PricingProcedure,
  R_PurchasingDocument._PurchaseContract AS _PurchaseContract,
  R_PurchasingDocument._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  R_PurchasingDocument._PurchasingDocumentItem AS _PurchasingDocumentItem,
  R_PurchasingDocument._PurchasingDocumentOrigin AS _PurchasingDocumentOrigin,
  R_PurchasingDocument._PurchasingDocumentPartner AS _PurchasingDocumentPartner,
  R_PurchasingDocument._PurchasingDocumentType AS _PurchasingDocumentType,
  R_PurchasingDocument._PurchasingGroup AS _PurchasingGroup,
  R_PurchasingDocument._PurchasingOrganization AS _PurchasingOrganization,
  R_PurchasingDocument._PurchasingProcessingStatus AS _PurchasingProcessingStatus,
  R_PurchasingDocument._ReleaseCode AS _ReleaseCode,
  R_PurchasingDocument._Supplier AS _Supplier,
  R_PurchasingDocument._SupplierAddress_2 AS _SupplierAddress_2,
  R_PurchasingDocument._SupplyingPlant AS _SupplyingPlant,
  R_PurchasingDocument._SupplyingSupplier AS _SupplyingSupplier,
  _Extension.PPSFuturePostingDate AS PPSFuturePostingDate
FROM R_PurchasingDocument
INNER JOIN t161 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPS_PurgDocumentExtension AS _Extension ON PurchasingDocument = _Extension.PurchasingDocument  -- association [0..1]
;

Depth:

I_PPS_PurchasingDocument view_entity

R_PurchasingDocument view
t161