P_PurgDocumentConvertedValues

Purchasing Document Converted Values | view: PMMPDCNVRTDVAL | Extraction: Not supported | Component: Reporting
Tables used: MMPUR_ANA_EKET
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem FK Item Number of Purchasing Document
ScheduleLine Schedule Line Number
ProcurementHubSourceSystem Connected System ID
Column Name Description
💲 Reporting Currency 1 (DisplayCurrency):
PurchaseOrderAmount Net Amount (in Reporting Currency 1)
OpenPurchaseOrderNetAmount Open Amount (in Reporting Currency 1)
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
OpenAmountInDocumentCurrency Open Amount (in Document Currency)
💲 Company Currency (CompanyCodeCurrency):
NetAmountInCoCodeCurrency Net Amount in Company Currency
OpenAmountInCompanyCodeCrcy Open Amount (in Company Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
ScheduleLineOpenQuantity Open Quantity
ScheduleLineOrderQuantity Scheduled Quantity
PrevDelivQtyOfScheduleLine Previous Quantity (Delivery Schedule Lines)
GoodsReceiptQuantity Quantity of goods received
ScheduleLineIssuedQuantity Issued Quantity
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
ScheduleLineCommittedQuantity Committed Quantity
Column Name Description
CreationDate Last Changed On
PurchasingDocumentOrderDate Purchasing Document Date
ScheduleLineDeliveryTime Delivery Date Time-Spot
ScheduleLineDeliveryDate Item delivery date
SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
ProductAvailabilityDate Material Staging/Availability Date
MaterialStagingTime Material Staging Time (Local, Relating to a Plant)
LoadingDate Loading Date
LoadingTime Loading Time (Local Time Relating to a Shipping Point)
TransportationPlanningDate Transportation Planning Date
TransportationPlanningTime Transp. Planning Time (Local, Relating to a Shipping Point)
GoodsIssueDate Goods Issue Date
GoodsIssueTime Time of Goods Issue (Local, Relating to a Plant)
STOLatestPossibleGRDate Goods Receipt End Date
STOLatestPossibleGRTime Goods Receipt End Time (Local, Relating to a Plant)
Column Name Description
AnlytlCrcyExchangeRateStatus Reporting Currency Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
PurchasingDocumentDeletionCode Asset class marked for deletion Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
PurchasingProcessingStatus Purchasing document processing state Show values
PurchasingDocumentIsAged Document is aged Show values
SourceOfCreation Creation indicator (purchase requisition/schedule lines) Show values
Column Name Description Domain name
ScheduleLineUniqueID Schedule line id(Concatenation of EBELN, EBELP, EETEN) PURGDOCSCHEDULELINEUNIQUEID
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
CompanyCode Company Code BUKRS
Supplier Account Number of Supplier LIFNR
Plant Plant WERKS
Material Material Number MATNR
MaterialGroup Material Group MATKL
ServicePerformer Service Performer BU_PARTNER
ProductType Product Type Group CHAR2
PurchasingDocumentType Order Type (Purchasing) BSART
PurchasingDocumentItemCategory Item category in purchasing document PSTYP
AccountAssignmentCategory Account Assignment Category KNTTP
LastChangeDateTime Change Time Stamp TZNTSTMPL
PurchaseRequisition Purchase Requisition Number BANFN
NoOfRemindersOfScheduleLine No. of Reminders/Expediters for Schedule Line PACK2
Other Relations Join Conditions
Category of delivery date
  • Category of delivery date
  • Client
  • ?
  • P_PURGDOCUMENTCONVERTEDVALUES.DELIVDATECATEGORY == TPRG.PRGBZ
  • P_PURGDOCUMENTCONVERTEDVALUES.MANDT == TPRG.MANDT
  • P_PURGDOCUMENTCONVERTEDVALUES.[column in domain "SPRAS"] == TPRG.SPRAS