I_PrmtHbRpldPurOrderEnhcd

Replicated PO enhanced | view: IREPLDPOENH | TRAN | Extraction: Not supported | Component: Central Purchase Order
Tables used: MMPUR_EXT_EKKO
Column Name Description
PurchaseOrder Purchasing Document Number
ExtSourceSystem Connected System ID
Column Name Description
💲 Currency Key (DocumentCurrency):
PurchaseOrderNetAmount Net Value in Document Currency
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchaseOrderDate Purchase Order Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
ScheduleLineDeliveryDate Item delivery date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchaseOrderSubtype Control indicator for purchasing document type Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingProcessingStatus Purchasing document processing state Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
IsIntrastatReportingRelevant Relevant for Intrastat Reporting Show values
IsIntrastatReportingExcluded Exclude from Intrastat Reporting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
HasNote Boolean Variables (X=true, space=false) Show values
HasAttachment Boolean Variables (X=true, space=false) Show values
PurchaseOrderStatus Purchasing Document Status Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
CreatedByUserFullName Full Name of Person TEXT80
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
CompanyCodeCountry Country/Region Key LAND1
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
DeliveryDocumentCondition Number of the Document Condition KNUMV
ExchangeRate null
LastChangeDateTime Change Time Stamp TZNTSTMPL
ManualSupplierAddressID Address Number AD_ADDRNUM
NumberOfOverduePurOrders Number of Overdue Purchase Orders INT4
NumberOfOverduePurOrdItm Number of Overdue Purchase Orders Items INT4
PurchaseOrderStatusName Purchase order status name CHAR260
ApproverUser Approver XUBNAME
ApproverName Approver Name TEXT40
PurOrdOutputCtrlType Purchase Order Output Status Flag CHAR1
PurchaseOrderOutputStatus Purchase Order Output Status Flag CHAR1
PurchaseOrderOutputStatusName Purchase Order Output Status name CHAR60
PurchaseOrderOutputDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WeightedRelevance Weighted Relevance
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == T001.MANDT
  • I_PRMTHBRPLDPURORDERENHCD.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == TCURC.MANDT
  • I_PRMTHBRPLDPURORDERENHCD.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_PRMTHBRPLDPURORDERENHCD.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_PRMTHBRPLDPURORDERENHCD.INCOTERMSVERSION == TINCV.INCOV
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • I_PRMTHBRPLDPURORDERENHCD.INVOICINGPARTY == LFA1.LIFNR
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == LFA1.MANDT
Language Key I_PRMTHBRPLDPURORDERENHCD.LANGUAGE == T002.SPRAS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Client
  • ?
  • I_PRMTHBRPLDPURORDERENHCD.PRICINGPROCEDURE == T683.KALSM
  • I_PRMTHBRPLDPURORDERENHCD.[column in domain "KAPPL"] == T683.KAPPL
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == T683.MANDT
  • I_PRMTHBRPLDPURORDERENHCD.[column in domain "KVEWE"] == T683.KVEWE
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • I_PRMTHBRPLDPURORDERENHCD.PURCHASEORDERTYPE == T161.BSART
  • I_PRMTHBRPLDPURORDERENHCD.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_PRMTHBRPLDPURORDERENHCD.PURCHASINGGROUP == T024.EKGRP
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == T024E.MANDT
  • I_PRMTHBRPLDPURORDERENHCD.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • I_PRMTHBRPLDPURORDERENHCD.SUPPLIER == LFA1.LIFNR
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == LFA1.MANDT
Goods Supplier
  • Client
  • Goods Supplier
  • I_PRMTHBRPLDPURORDERENHCD.MANDT == LFA1.MANDT
  • I_PRMTHBRPLDPURORDERENHCD.SUPPLYINGSUPPLIER == LFA1.LIFNR