What is C_MassUpdtPurgDocsMsgDets in SAP S/4HANA?

C_MassUpdtPurgDocsMsgDets is a consumption CDS view in SAP S/4HANA. Message Facet Object Page It contains 102 fields.

Which tables does C_MassUpdtPurgDocsMsgDets read from?

C_MassUpdtPurgDocsMsgDets reads data from: P_SimlnLogSingleSuccess.

What VDM layer is C_MassUpdtPurgDocsMsgDets?

C_MassUpdtPurgDocsMsgDets is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MassUpdtPurgDocsMsgDets

DDL: C_MASSUPDTPURGDOCSMSGDETS SQL: CDOCMSGDET Type: view CONSUMPTION

102 Fields 1 Data Sources 3 Associations

Message Facet Object Page

C_MassUpdtPurgDocsMsgDets is a Consumption CDS View that provides data about "Message Facet Object Page" in SAP S/4HANA. It reads from 1 data source (P_SimlnLogSingleSuccess) and exposes 102 fields with key fields SimulationJobUUID, SystemMessageNumber, SystemMessageIdentification, SystemMessageType, SystemMessageVariable1. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_SimlnLogSingleSuccess	P_SimlnLogSingleSuccess	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_PurchaseOrder	_PurchaseOrderHeader	`$projection.PurchasingDocument = _PurchaseOrderHeader.PurchaseOrder`
[1..1]	P_PurchaseOrderItemsImpacted	_PurchaseOrderItem	`$projection.PurchasingDocument = _PurchaseOrderItem.PurchaseOrder and $projection.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem`
[0..1]	I_PurchaseOrderStatusText	_PurchaseOrderStatus	`$projection.PurchasingDocument = _PurchaseOrderStatus.PurchaseOrder`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CDOCMSGDET	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Message Facet Object Page	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (102)

Key	Field	Source Table	Source Field	Description
KEY	SimulationJobUUID		SimulationJobUUID
KEY	SystemMessageNumber		SystemMessageNumber	Message Number
KEY	SystemMessageIdentification		SystemMessageIdentification	Message ID
KEY	SystemMessageType		SystemMessageType	Message type
KEY	SystemMessageVariable1		SystemMessageVariable1	Variable 1
KEY	SystemMessageVariable2		SystemMessageVariable2	Variable 2
KEY	SystemMessageVariable3		SystemMessageVariable3	Variable 3
KEY	SystemMessageVariable4		SystemMessageVariable4	Variable 4
KEY	PurchasingDocument		PurchasingDocument	Purchase Order
KEY	PurchasingDocumentItem		PurchasingDocumentItem	Purchase Order Item
	Supplier	_PurchaseOrderHeader	Supplier	Supplier
	SupplierName
	PurchasingOrganization	_PurchaseOrderHeader	PurchasingOrganization	Purchasing Organization
	PurchasingOrganizationName
	PurchaseOrderType	_PurchaseOrderHeader	PurchaseOrderType	Purchasing Document Type
	PurchasingDocumentTypeName
	PurchaseOrderDate	_PurchaseOrderHeader	PurchaseOrderDate	PO Date
	CompanyCode	_PurchaseOrderItem	CompanyCode	Receiver Company Code
	CompanyCodeName
	Plant	_PurchaseOrderItem	Plant	Valuation Area
	PlantName
	Material	_PurchaseOrderItem	Material	Vehicle Model
	MaterialName
	PaymentTerms	_PurchaseOrderHeader	PaymentTerms	Terms of Payment
	PaymentTermsName
	CashDiscount1Days	_PurchaseOrderHeader	CashDiscount1Days	Discount Days 1
	CashDiscount2Days	_PurchaseOrderHeader	CashDiscount2Days	Discount Days 2
	NetPaymentDays	_PurchaseOrderHeader	NetPaymentDays	Discount Days
	CashDiscount1Percent	_PurchaseOrderHeader	CashDiscount1Percent	Discount Percentage 1
	CashDiscount2Percent	_PurchaseOrderHeader	CashDiscount2Percent	Discount Percentage 2
	PurchasingGroup	_PurchaseOrderHeader	PurchasingGroup	Purchasing Group
	PurchasingGroupName
	DocumentCurrency	_PurchaseOrderItem	DocumentCurrency	Currency Key
	ValidityStartDate	_PurchaseOrderHeader	ValidityStartDate	Validity Period Start
	ValidityEndDate	_PurchaseOrderHeader	ValidityEndDate	Validity Period End
	SupplierRespSalesPersonName	_PurchaseOrderHeader	SupplierRespSalesPersonName	Salesperson
	SupplierPhoneNumber	_PurchaseOrderHeader	SupplierPhoneNumber	Telephone
	SupplyingSupplier	_PurchaseOrderHeader	SupplyingSupplier	Goods Supplier
	SupplierFullName
	IncotermsClassification	_PurchaseOrderHeader	IncotermsClassification	Incoterms Information (Header Level)
	IncotermsClassificationName
	InvoicingParty	_PurchaseOrderHeader	InvoicingParty	Supplier
	InvoicingPartyName
	ExchangeRate	_PurchaseOrderHeader	ExchangeRate	Exchange Rate
	IncotermsVersion	_PurchaseOrderHeader	IncotermsVersion	Inco. Version
	IncotermsVersionName
	HeaderIncotermsLoc1	_PurchaseOrderHeader	IncotermsLocation1	Incoterm Location 1 (Header)
	HeaderIncotermsLoc2	_PurchaseOrderHeader	IncotermsLocation2	Incoterm Location 2 (Header)
	StorageLocation	_PurchaseOrderItem	StorageLocation	StorageLocation
	StorageLocationName
	MaterialGroup	_PurchaseOrderItem	MaterialGroup	Product Group
	MaterialGroupName
	PurchasingInfoRecord	_PurchaseOrderItem	PurchasingInfoRecord	Purchasing Info Record
	SupplierMaterialNumber	_PurchaseOrderItem	SupplierMaterialNumber	Supplier Material Number
	OrderPriceUnitToOrderUnitNmrtr	_PurchaseOrderItem	OrderPriceUnitToOrderUnitNmrtr	Numerator for OPU Conversion
	OrdPriceUnitToOrderUnitDnmntr	_PurchaseOrderItem	OrdPriceUnitToOrderUnitDnmntr	Denominator for OPU Conversion
	OrderItemQtyToBaseQtyNmrtr	_PurchaseOrderItem	OrderItemQtyToBaseQtyNmrtr	Numerator for OU Conversion
	OrderItemQtyToBaseQtyDnmntr	_PurchaseOrderItem	OrderItemQtyToBaseQtyDnmntr	Denominator for OU Conversion
	NetPriceQuantity	_PurchaseOrderItem	NetPriceQuantity	Price Unit
	NetAmount	_PurchaseOrderItem	NetAmount	Net Value
	TaxCode	_PurchaseOrderItem	TaxCode	Tax Code
	PriceIsToBePrinted	_PurchaseOrderItem	PriceIsToBePrinted	Print Price
	OverdelivTolrtdLmtRatioInPct	_PurchaseOrderItem	OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance Limit
	UnlimitedOverdeliveryIsAllowed	_PurchaseOrderItem	UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Indicator
	UnderdelivTolrtdLmtRatioInPct	_PurchaseOrderItem	UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance Limit
	ValuationType	_PurchaseOrderItem	ValuationType	Valuation Type
	IsCompletelyDelivered	_PurchaseOrderItem	IsCompletelyDelivered	Is completely delivered
	IsFinallyInvoiced	_PurchaseOrderItem	IsFinallyInvoiced	Final Invoice
	PurchaseOrderItemCategory	_PurchaseOrderItem	PurchaseOrderItemCategory	Item Category
	PurgDocItemCategoryName	_PurchaseOrderItem	PurgDocItemCategoryName	Text for ItCat.
	AccountAssignmentCategory	_PurchaseOrderItem	AccountAssignmentCategory	Account Assignment Category
	GoodsReceiptIsExpected	_PurchaseOrderItem	GoodsReceiptIsExpected	Goods Receipt
	GoodsReceiptIsNonValuated	_PurchaseOrderItem	GoodsReceiptIsNonValuated	Non-Valuated Goods Receipt
	InvoiceIsExpected	_PurchaseOrderItem	InvoiceIsExpected	Invoice Receipt
	InvoiceIsGoodsReceiptBased	_PurchaseOrderItem	InvoiceIsGoodsReceiptBased	Goods-Receipt Based Invoice Verification
	BaseUnit	_PurchaseOrderItem	BaseUnit	Base Unit
	EffectiveAmount	_PurchaseOrderItem	EffectiveAmount	Effective Value
	ItemNetWeight	_PurchaseOrderItem	ItemNetWeight	Net Weight
	ItemWeightUnit	_PurchaseOrderItem	ItemWeightUnit	Unit of Weight
	TaxJurisdiction	_PurchaseOrderItem	TaxJurisdiction	Tax Jurisdiction
	InternationalArticleNumber	_PurchaseOrderItem	InternationalArticleNumber	International Article Number
	SupplierConfirmationControlKey	_PurchaseOrderItem	SupplierConfirmationControlKey	Confirmation Control
	SupplierConfControlKeyName
	PricingDateControl	_PurchaseOrderItem	PricingDateControl	Pr. Date Cat.
	ItemVolume	_PurchaseOrderItem	ItemVolume	Volume
	ItemVolumeUnit	_PurchaseOrderItem	ItemVolumeUnit	Volume Unit
	ItemIncotermsClassification	_PurchaseOrderItem	IncotermsClassification	Incoterms Information (Item Level)
	SupplierSubrange	_PurchaseOrderItem	SupplierSubrange	Suppl. Subrange
	ServicePackage	_PurchaseOrderItem	ServicePackage	Package Number
	EvaldRcptSettlmtIsAllowed	_PurchaseOrderItem	EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement
	IsReturnsItem	_PurchaseOrderItem	IsReturnsItem	Returns Item
	EarmarkedFundsDocument	_PurchaseOrderItem	EarmarkedFundsDocument	Earmarked Funds
	EarmarkedFundsDocumentItem	_PurchaseOrderItem	EarmarkedFundsDocumentItem	Document Item
	IncotermsLocation1	_PurchaseOrderItem	IncotermsLocation1	Incoterm Location 1 (Item)
	IncotermsLocation2	_PurchaseOrderItem	IncotermsLocation2	Incoterm Location 2 (Item)
	ServicePerformer	_PurchaseOrderItem	ServicePerformer	Service Performer
	ProductType	_PurchaseOrderItem	ProductType	Product Type
	ProductTypeName
	OrderPriceUnit	_PurchaseOrderItem	OrderPriceUnit	Order Price Un.
	PurchasingDocumentStatus	_PurchaseOrderStatus	PurchasingDocumentStatus	Order Status
	PurchasingDocumentStatusName	_PurchaseOrderStatus	PurchasingDocumentStatusName
	PurchaseOrderItemText	_PurchaseOrderItem	PurchaseOrderItemText	Short Text

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 C_MassUpdtPurgDocsMsgDets.
-- 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: CDOCMSGDET

CREATE VIEW C_MassUpdtPurgDocsMsgDets AS
SELECT
  SimulationJobUUID,
  SystemMessageNumber,
  SystemMessageIdentification,
  SystemMessageType,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  PurchasingDocument,
  PurchasingDocumentItem,
  _PurchaseOrderHeader.Supplier AS Supplier,
  _PurchaseOrderHeader._Supplier.SupplierName AS SupplierName,
  _PurchaseOrderHeader.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderHeader._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchaseOrderHeader.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrderHeader._PurchaseOrderType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurchaseOrderHeader.PurchaseOrderDate AS PurchaseOrderDate,
  _PurchaseOrderItem.CompanyCode AS CompanyCode,
  _PurchaseOrderHeader._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchaseOrderItem.Plant AS Plant,
  _PurchaseOrderItem._Plant.PlantName AS PlantName,
  _PurchaseOrderItem.Material AS Material,
  _PurchaseOrderItem._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _PurchaseOrderHeader.PaymentTerms AS PaymentTerms,
  _PurchaseOrderHeader._PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  _PurchaseOrderHeader.CashDiscount1Days AS CashDiscount1Days,
  _PurchaseOrderHeader.CashDiscount2Days AS CashDiscount2Days,
  _PurchaseOrderHeader.NetPaymentDays AS NetPaymentDays,
  _PurchaseOrderHeader.CashDiscount1Percent AS CashDiscount1Percent,
  _PurchaseOrderHeader.CashDiscount2Percent AS CashDiscount2Percent,
  _PurchaseOrderHeader.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderHeader._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  _PurchaseOrderHeader.ValidityStartDate AS ValidityStartDate,
  _PurchaseOrderHeader.ValidityEndDate AS ValidityEndDate,
  _PurchaseOrderHeader.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  _PurchaseOrderHeader.SupplierPhoneNumber AS SupplierPhoneNumber,
  _PurchaseOrderHeader.SupplyingSupplier AS SupplyingSupplier,
  _PurchaseOrderHeader._SupplyingSupplier.SupplierFullName AS SupplierFullName,
  _PurchaseOrderHeader.IncotermsClassification AS IncotermsClassification,
  _PurchaseOrderHeader._IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  _PurchaseOrderHeader.InvoicingParty AS InvoicingParty,
  _PurchaseOrderHeader._InvoicingParty.SupplierFullName AS InvoicingPartyName,
  _PurchaseOrderHeader.ExchangeRate AS ExchangeRate,
  _PurchaseOrderHeader.IncotermsVersion AS IncotermsVersion,
  _PurchaseOrderHeader._IncotermsVersion._Text[1:Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  _PurchaseOrderHeader.IncotermsLocation1 AS HeaderIncotermsLoc1,
  _PurchaseOrderHeader.IncotermsLocation2 AS HeaderIncotermsLoc2,
  _PurchaseOrderItem.StorageLocation AS StorageLocation,
  _PurchaseOrderItem._StorageLocation.StorageLocationName AS StorageLocationName,
  _PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  _PurchaseOrderItem._MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  _PurchaseOrderItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PurchaseOrderItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  _PurchaseOrderItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  _PurchaseOrderItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  _PurchaseOrderItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  _PurchaseOrderItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  _PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  _PurchaseOrderItem.NetAmount AS NetAmount,
  _PurchaseOrderItem.TaxCode AS TaxCode,
  _PurchaseOrderItem.PriceIsToBePrinted AS PriceIsToBePrinted,
  _PurchaseOrderItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _PurchaseOrderItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  _PurchaseOrderItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  _PurchaseOrderItem.ValuationType AS ValuationType,
  _PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  _PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItem.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurchaseOrderItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _PurchaseOrderItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _PurchaseOrderItem.InvoiceIsExpected AS InvoiceIsExpected,
  _PurchaseOrderItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  _PurchaseOrderItem.BaseUnit AS BaseUnit,
  _PurchaseOrderItem.EffectiveAmount AS EffectiveAmount,
  _PurchaseOrderItem.ItemNetWeight AS ItemNetWeight,
  _PurchaseOrderItem.ItemWeightUnit AS ItemWeightUnit,
  _PurchaseOrderItem.TaxJurisdiction AS TaxJurisdiction,
  _PurchaseOrderItem.InternationalArticleNumber AS InternationalArticleNumber,
  _PurchaseOrderItem.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  _PurchaseOrderItem._ConfirmationControlVH.SupplierConfControlKeyName AS SupplierConfControlKeyName,
  _PurchaseOrderItem.PricingDateControl AS PricingDateControl,
  _PurchaseOrderItem.ItemVolume AS ItemVolume,
  _PurchaseOrderItem.ItemVolumeUnit AS ItemVolumeUnit,
  _PurchaseOrderItem.IncotermsClassification AS ItemIncotermsClassification,
  _PurchaseOrderItem.SupplierSubrange AS SupplierSubrange,
  _PurchaseOrderItem.ServicePackage AS ServicePackage,
  _PurchaseOrderItem.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  _PurchaseOrderItem.IsReturnsItem AS IsReturnsItem,
  _PurchaseOrderItem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  _PurchaseOrderItem.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  _PurchaseOrderItem.IncotermsLocation1 AS IncotermsLocation1,
  _PurchaseOrderItem.IncotermsLocation2 AS IncotermsLocation2,
  _PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  _PurchaseOrderItem.ProductType AS ProductType,
  _PurchaseOrderItem._ProductType._Text[1:Language = $session.system_language].Name AS ProductTypeName,
  _PurchaseOrderItem.OrderPriceUnit AS OrderPriceUnit,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  _PurchaseOrderStatus.PurchasingDocumentStatusName AS PurchasingDocumentStatusName,
  _PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText
FROM P_SimlnLogSingleSuccess
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrderHeader ON PurchasingDocument = _PurchaseOrderHeader.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN P_PurchaseOrderItemsImpacted AS _PurchaseOrderItem ON PurchasingDocument = _PurchaseOrderItem.PurchaseOrder AND PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderStatusText AS _PurchaseOrderStatus ON PurchasingDocument = _PurchaseOrderStatus.PurchaseOrder  -- association [0..1]
;

Depth:

C_MassUpdtPurgDocsMsgDets view

P_SimlnLogSingleSuccess view