C_PurReqnItmWrkflwDeadlineEml

Purchase Requsition Workflow deadline email notification | view: CMMPURREQWFLEML | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, SWWWIHEAD, SWWFLEXDL, SWWFLEXDLA, SWWWIDEADL, SWPSTEPLOG, SWWWIHEAD, SWWWIHEAD, FM01, T001W, T001K, SWW_WI2OBJ, SWWWICOMMENT, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
WorkflowTaskInternalID Work item ID
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
PurReqnLimitConsumptionAmt Consumption Value for Limit Items
ItemNetAmount null
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
Column Name Description
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
DeliveryDate Item delivery date
CreationDate Requisition (request) date
PurReqCreationDate Requisition (request) date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
PurReqnWrkflwTskCrtnUTCDate Latest Start Date for Work Item
PurReqnWrkflwTskCrtnUTCTime Latest start time for work item
PurReqnWrkflwTaskDueUTCDate Latest End Date for Work Item
PurReqnWrkflwTaskDueUTCTime Latest end time for work item
Column Name Description
PurReqnReleaseStatus Requisition Processing State Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
PurchasingDocumentCategory Purchasing Document Category Show values
SourceOfSupplyIsAssigned Assigned Source of Supply Show values
ProcessingStatus Processing status of purchase requisition Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
PurReqnSourceOfSupplyType Purchasing Document Category Show values
ConsumptionPosting Consumption posting Show values
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
IsPurReqnBlocked Purchase Requisition Blocked Show values
IsClosed Purchase requisition closed Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
InvoiceIsExpected Invoice receipt indicator Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
PurchaseRequisitionIsFixed Purchase requisition is fixed Show values
Column Name Description Domain name
PurchaseRequisition Purchase requisition number BANFN
PurchaseRequisitionItem Item number of purchase requisition BNFPO
PurchaseReqnItemUniqueID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
PurchaseRequisitionItemText Short Text TEXT40
PurReqnPriceQuantity Price unit DEC5
MaterialGoodsReceiptDuration Goods receipt processing time in days DEC3
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
RequisitionerName Name of requisitioner/requester AFNAM
CreatedByUser Name of Person Responsible for Creating the Object USNAM
DeliveryAddressID Address ADRNR
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
PurReqnSSPRequestor Requestor
PurReqnSSPAuthor Author of Requisition UNAME
PurReqnSSPCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
PurReqnSSPCatalogItem Catalog Item Id
PurReqnSSPCrossCatalogItem Catalog Item Key
ServicePerformer Service Performer BU_PARTNER
PurchaseRequisitionStatus Release State FRGZU
SupplierMaterialNumber Material Number Used by Supplier IDNEX
Batch Batch Number CHARG
MinRemainingShelfLife Minimum Remaining Shelf Life DEC4
RequirementTracking Requirement Tracking Number CHAR10
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
WorkflowTaskURL Workflow: Workflow Task URL SWF_WORKFLOW_TASK_URL
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T163K.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Link to Central Address Management
  • Client
  • ?
  • ?
  • Manual address number in purchasing document item
  • Manual address number in purchasing document item
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == ADRC.CLIENT
  • C_PURREQNITMWRKFLWDEADLINEEML.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURREQNITMWRKFLWDEADLINEEML.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_PURREQNITMWRKFLWDEADLINEEML.ADDRESSID == ADRC.ADDRNUMBER
  • C_PURREQNITMWRKFLWDEADLINEEML.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T006.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.BASEUNIT == T006.MSEHI
Company code
  • Client
  • Company Code
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T001.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.COMPANYCODE == T001.BUKRS
Fixed Vendor
  • Client
  • Fixed Vendor
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == LFA1.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.FIXEDSUPPLIER == LFA1.LIFNR
Number of delivery address
  • Client
  • ?
  • ?
  • Number of delivery address
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == ADRC.CLIENT
  • C_PURREQNITMWRKFLWDEADLINEEML.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURREQNITMWRKFLWDEADLINEEML.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_PURREQNITMWRKFLWDEADLINEEML.ITEMDELIVERYADDRESSID == ADRC.ADDRNUMBER
Language Key C_PURREQNITMWRKFLWDEADLINEEML.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • Client
  • ?
  • ?
  • Manual address number in purchasing document item
  • Manual address number in purchasing document item
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == ADRC.CLIENT
  • C_PURREQNITMWRKFLWDEADLINEEML.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURREQNITMWRKFLWDEADLINEEML.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_PURREQNITMWRKFLWDEADLINEEML.ADDRESSID == ADRC.ADDRNUMBER
  • C_PURREQNITMWRKFLWDEADLINEEML.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
Material Number
  • Client
  • Material Number
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == MARA.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T023.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.MATERIALGROUP == T023.MATKL
MRP Controller
  • Client
  • Plant
  • MRP Controller
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T024D.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.PLANT == T024D.WERKS
  • C_PURREQNITMWRKFLWDEADLINEEML.MRPCONTROLLER == T024D.DISPO
Plant
  • Client
  • Plant
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T001W.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • Purchasing Document Category
  • C_PURREQNITMWRKFLWDEADLINEEML.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T161.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T163.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T024.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == EINA.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURREQNITMWRKFLWDEADLINEEML.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == TCURC.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.PURREQNITEMCURRENCY == TCURC.WAERS
Storage location
  • Client
  • Plant
  • Storage location
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == T001L.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.PLANT == T001L.WERKS
  • C_PURREQNITMWRKFLWDEADLINEEML.STORAGELOCATION == T001L.LGORT
Desired Vendor
  • Desired Vendor
  • Client
  • C_PURREQNITMWRKFLWDEADLINEEML.SUPPLIER == LFA1.LIFNR
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == LFA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Category of delivery date
  • Category of delivery date
  • Client
  • ?
  • C_PURREQNITMWRKFLWDEADLINEEML.DELIVDATECATEGORY == TPRG.PRGBZ
  • C_PURREQNITMWRKFLWDEADLINEEML.MANDT == TPRG.MANDT
  • C_PURREQNITMWRKFLWDEADLINEEML.[column in domain "SPRAS"] == TPRG.SPRAS