Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_PurgOrdMassUpdtNode

DDL: C_PURGORDMASSUPDTNODE SQL: CPOMASUPDTNODE Type: view CONSUMPTION Package: ODATA_MM_PUR_POMASS_UPDATE
105 Fields 1 Data Sources 1 Associations

Mass Change to Purchase Orders

C_PurgOrdMassUpdtNode is a Consumption CDS View that provides data about "Mass Change to Purchase Orders" in SAP S/4HANA. It reads from 1 data source (P_PurchaseOrderMassUpdate) and exposes 105 fields with key field FormattedPurDoc. It has 1 association to related views. Part of development package ODATA_MM_PUR_POMASS_UPDATE.

Data Sources (1)

SourceAliasJoin Type
P_PurchaseOrderMassUpdate P_PurchaseOrderMassUpdate from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_PurgOrdMassUpdtStruc _Structure $projection.FormattedPurDoc = _Structure.FormattedPurDoc

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CPOMASUPDTNODE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Mass Change to Purchase Orders view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
hierarchy.parentChild.name MASSUPDATE view
hierarchy.parentChild.multipleParents false view
hierarchy.parentChild.siblingsOrder.by FormattedPurDoc view
hierarchy.parentChild.siblingsOrder.direction #ASC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #HIERARCHY view
ObjectModel.representativeKey FormattedPurDoc view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor view

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY FormattedPurDoc FormattedPurDoc
FormattedPurchasingDocItem FormattedPurchasingDocItem
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
NumberOfPurchaseOrderItems NumberOfPurchaseOrderItems Number of PO Items
ParentNode ParentNode Parent Node
NumberOfItems NumberOfItems
Supplier Supplier Supplier
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchaseOrderType PurchaseOrderType PO Type
PurchaseOrderDate PurchaseOrderDate PO Date
PurchasingDocumentOrigin PurchasingDocumentOrigin Status
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
Material Material Vehicle Model
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
PurchasingGroup PurchasingGroup Purchasing Group
DocumentCurrency DocumentCurrency Document Currency
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
SupplierRespSalesPersonName SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber SupplierPhoneNumber Telephone
SupplyingSupplier SupplyingSupplier Goods Supplier
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
InvoicingParty InvoicingParty Supplier
ExchangeRate ExchangeRate Exchange rate
IncotermsVersion IncotermsVersion Inco. Version
HeaderIncotermsLoc1 HeaderIncotermsLoc1
HeaderIncotermsLoc2 HeaderIncotermsLoc2
PaymentTermsName PaymentTermsName Description
IncotermsClassificationName IncotermsClassificationName Incoterms Classification Description
SupplierName SupplierName Supplier Name
PurchasingDocumentTypeName PurchasingDocumentTypeName Description
PurchasingOrganizationName PurchasingOrganizationName Purch. Org. Name
PurchasingGroupName PurchasingGroupName Purchasing Grp. Name
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
ManufacturerMaterial ManufacturerMaterial MPN: Material
StorageLocation StorageLocation StorageLocation
MaterialGroup MaterialGroup Product Group
PurchasingInfoRecord PurchasingInfoRecord Info Record
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
NetPriceQuantity NetPriceQuantity Price Unit
NetAmount NetAmount Stated Amount
TaxCode TaxCode Tax Code
PriceIsToBePrinted PriceIsToBePrinted Print Price
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed Unlimited Tol.
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
ValuationType ValuationType Valuation Type
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
PurchaseOrderItemCategory PurchaseOrderItemCategory Item Category
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
PartialInvoiceDistribution PartialInvoiceDistribution Partial invoice
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
BaseUnit BaseUnit Unit of Measure
EffectiveAmount EffectiveAmount Effective value
ItemNetWeight ItemNetWeight Net Weight
ItemWeightUnit ItemWeightUnit Unit of Weight
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
InternationalArticleNumber InternationalArticleNumber EAN/UPC
SupplierConfirmationControlKey SupplierConfirmationControlKey Conf. Control
ProfitCenter ProfitCenter Profit Center
PricingDateControl PricingDateControl Pr. Date Cat.
ItemVolume ItemVolume Volume
ItemVolumeUnit ItemVolumeUnit Volume Unit
ItemIncotermsClassification ItemIncotermsClassification Incoterms
ItemIncotermsTransferLocation ItemIncotermsTransferLocation Incoterms 2
SupplierSubrange SupplierSubrange Suppl. Subrange
ServicePackage ServicePackage Package number
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed ERS
IsReturnsItem IsReturnsItem Returns Item
EarmarkedFunds EarmarkedFunds Earmarked Funds
EarmarkedFundsItem EarmarkedFundsItem Document Item
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
ServicePerformer ServicePerformer Service Performer
ProductType ProductType Product Type Group
OrderPriceUnit OrderPriceUnit Order Price Un.
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
PurchasingDocumentStatus PurchasingDocumentStatus Short Description
MaterialName MaterialName Material Description
PurchaseOrderItemText PurchaseOrderItemText Short Text
PlantName PlantName Plant Name
CompanyCodeName CompanyCodeName Company Name
PurchasingDocumentStatusName PurchasingDocumentStatusName
PurgDocItemCategoryName PurgDocItemCategoryName Text for ItCat.
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
SemanticObject SemanticObject Semantic Object
_Structure _Structure

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_PurgOrdMassUpdtNode.
-- 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: CPOMASUPDTNODE

CREATE VIEW C_PurgOrdMassUpdtNode AS
SELECT
  FormattedPurDoc,
  FormattedPurchasingDocItem,
  PurchaseOrder,
  PurchaseOrderItem,
  NumberOfPurchaseOrderItems,
  ParentNode,
  NumberOfItems,
  Supplier,
  PurchasingOrganization,
  PurchaseOrderType,
  PurchaseOrderDate,
  PurchasingDocumentOrigin,
  CompanyCode,
  Plant,
  Material,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchasingGroup,
  DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  IncotermsClassification,
  IncotermsTransferLocation,
  InvoicingParty,
  ExchangeRate,
  IncotermsVersion,
  HeaderIncotermsLoc1,
  HeaderIncotermsLoc2,
  PaymentTermsName,
  IncotermsClassificationName,
  SupplierName,
  PurchasingDocumentTypeName,
  PurchasingOrganizationName,
  PurchasingGroupName,
  PurchasingDocumentDeletionCode,
  ManufacturerMaterial,
  StorageLocation,
  MaterialGroup,
  PurchasingInfoRecord,
  SupplierMaterialNumber,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  NetPriceQuantity,
  NetAmount,
  TaxCode,
  PriceIsToBePrinted,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  ValuationType,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  PurchaseOrderItemCategory,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  BaseUnit,
  EffectiveAmount,
  ItemNetWeight,
  ItemWeightUnit,
  TaxJurisdiction,
  InternationalArticleNumber,
  SupplierConfirmationControlKey,
  ProfitCenter,
  PricingDateControl,
  ItemVolume,
  ItemVolumeUnit,
  ItemIncotermsClassification,
  ItemIncotermsTransferLocation,
  SupplierSubrange,
  ServicePackage,
  EvaldRcptSettlmtIsAllowed,
  IsReturnsItem,
  EarmarkedFunds,
  EarmarkedFundsItem,
  IncotermsLocation1,
  IncotermsLocation2,
  ServicePerformer,
  ProductType,
  OrderPriceUnit,
  IsBusinessPurposeCompleted,
  PurchasingDocumentStatus,
  MaterialName,
  PurchaseOrderItemText,
  PlantName,
  CompanyCodeName,
  PurchasingDocumentStatusName,
  PurgDocItemCategoryName,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  SemanticObject
FROM P_PurchaseOrderMassUpdate
LEFT OUTER JOIN C_PurgOrdMassUpdtStruc AS _Structure ON FormattedPurDoc = _Structure.FormattedPurDoc  -- association [0..1]
;

Learn More