P_SCHDLNMIGRATION

Schedule Line Migration | view: PSCHDLNMIGRATION | Extraction: Not supported | Component: Reporting
Tables used: EKKOEKPOEKETT001TKA02
Column Name Description
ebeln FK Purchasing Document Number
ebelp FK Item Number of Purchasing Document
etenr Delivery Schedule Line Counter
BE_SOURCE_SYS null
Column Name Description
NETWR_SL_REPCURR1 Net Amount (in Reporting Currency 1)
NETWR_SL_REPCURR2 Net Amount (in Reporting Currency 2)
NETWR_BASE Net Amount in Company Currency
OBMNG_NETWR null
OBMNG_NETWR_REPCURR1 Open Amount (in Reporting Currency 1)
OBMNG_NETWR_REPCURR2 Open Amount (in Reporting Currency 2)
OBMNG_NETWR_BASE Open Amount (in Company Currency)
NETPR_REPCURR1 Net Price: Reporting Currency 1
NETPR_REPCURR2 Net Price: Reporting Currency 2
NETPR_BASE Net Price: Company Currency
💲 Currency Key (waers):
netwr Net Order Value in PO Currency
netpr Net Price in Purchasing Document (in Document Currency)
Column Name Description
OBMNG null
TOTALEXPECTEDQUANTITY null
LASTEXPECTEDQUANTITY null
menge Scheduled Quantity
ameng Previous Quantity (Delivery Schedule Lines)
wemng Quantity of goods received
wamng Issued Quantity
mng02 Committed Quantity
📏 Purchase Order Unit of Measure (meins):
MENGE_EKPO Purchase Order Quantity
Column Name Description
aedat Creation Date of Purchasing Document
BEDAT_POHDR Purchasing Document Date
eindt Item delivery date
slfdt Statistics-Relevant Delivery Date
uzeit Delivery Date Time-Spot
bedat Order date of schedule line
dat01 Committed date
altdt Previous delivery date
mbdat Material Staging/Availability Date
mbuhr Material Staging Time (Local, Relating to a Plant)
lddat Loading Date
lduhr Loading Time (Local Time Relating to a Shipping Point)
tddat Transportation Planning Date
tduhr Transp. Planning Time (Local, Relating to a Shipping Point)
wadat Goods Issue Date
wauhr Time of Goods Issue (Local, Relating to a Plant)
eldat Goods Receipt End Date
eluhr Goods Receipt End Time (Local, Relating to a Plant)
startdate Start Date for Period of Performance
enddate End Date for Period of Performance
_dataaging Data Filter Value for Data Aging
Column Name Description
elikz "Delivery Completed" Indicator Show values
wepos Goods Receipt Indicator Show values
memory Purchase order not yet complete Show values
bstyp Purchasing Document Category Show values
vrtkz Distribution Indicator for Multiple Account Assignment Show values
STATU Status of Purchasing Document Show values
procstat Purchasing document processing state Show values
isaged Document is aged Show values
retpo Returns Item Show values
frgrl Release Not Yet Completely Effected Show values
webre Indicator: GR-Based Invoice Verification Show values
estkz Creation indicator (purchase requisition/schedule lines) Show values
fixkz Schedule Line is "Fixed" Show values
abart Scheduling agreement release type Show values
Column Name Description Domain name
uniqueid Schedule line id(Concatenation of EBELN, EBELP, EETEN) PURGDOCSCHEDULELINEUNIQUEID
ZERO_VAL_REPCURR_IND null
SERVICEPERFORMER Service Performer BU_PARTNER
loekz Deletion Indicator in Purchasing Document ELOEK
ernam User of person who created a purchasing document USNAM
lastchangedatetime Change Time Stamp TZNTSTMPL
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
bpumn Denominator for Conv. of Order Price Unit into Order Unit UMBSN
PRODUCTTYPE Product Type Group CHAR2
umrez Numerator for Conversion of Order Unit to Base Unit UMBSZ
umren Denominator for Conversion of Order Unit to Base Unit UMBSN
FinalScheduleLine null
NDD null
banfn Purchase Requisition Number BANFN
mahnz No. of Reminders/Expediters for Schedule Line PACK2
peinh Price Unit DEC5
LOEKZ_POHDR Deletion Indicator in Purchasing Document ELOEK
Master Data Relations Join Conditions
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • P_SCHDLNMIGRATION.MANDT == T006.MANDT
  • P_SCHDLNMIGRATION.BPRME == T006.MSEHI
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • P_SCHDLNMIGRATION.BSTYP == T161.BSTYP
  • P_SCHDLNMIGRATION.MANDT == T161.MANDT
  • P_SCHDLNMIGRATION.BSART == T161.BSART
Company Code
  • Client
  • Company Code
  • P_SCHDLNMIGRATION.MANDT == T001.MANDT
  • P_SCHDLNMIGRATION.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHDLNMIGRATION.EKGRP == T024.EKGRP
  • P_SCHDLNMIGRATION.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_SCHDLNMIGRATION.MANDT == T024E.MANDT
  • P_SCHDLNMIGRATION.EKORG == T024E.EKORG
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_SCHDLNMIGRATION.MANDT == T163K.MANDT
  • P_SCHDLNMIGRATION.KNTTP == T163K.KNTTP
Supplier
  • Supplier
  • Client
  • P_SCHDLNMIGRATION.LIFNR == LFA1.LIFNR
  • P_SCHDLNMIGRATION.MANDT == LFA1.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_SCHDLNMIGRATION.MANDT == T006.MANDT
  • P_SCHDLNMIGRATION.LMEIN == T006.MSEHI
Material Group
  • Client
  • Material Group
  • P_SCHDLNMIGRATION.MANDT == T023.MANDT
  • P_SCHDLNMIGRATION.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • P_SCHDLNMIGRATION.MANDT == MARA.MANDT
  • P_SCHDLNMIGRATION.MATNR == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • P_SCHDLNMIGRATION.MANDT == T006.MANDT
  • P_SCHDLNMIGRATION.MEINS == T006.MSEHI
  • P_SCHDLNMIGRATION.MEINS_EKPO == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • P_SCHDLNMIGRATION.MANDT == T006.MANDT
  • P_SCHDLNMIGRATION.MEINS == T006.MSEHI
  • P_SCHDLNMIGRATION.MEINS_EKPO == T006.MSEHI
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_SCHDLNMIGRATION.MANDT == T163.MANDT
  • P_SCHDLNMIGRATION.PSTYP == T163.PSTYP
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • P_SCHDLNMIGRATION.MANDT == T001W.MANDT
  • P_SCHDLNMIGRATION.RESWK == T001W.WERKS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_SCHDLNMIGRATION.MANDT == TCURC.MANDT
  • P_SCHDLNMIGRATION.WAERS == TCURC.WAERS
  • P_SCHDLNMIGRATION.WAERS_BASE == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_SCHDLNMIGRATION.MANDT == TCURC.MANDT
  • P_SCHDLNMIGRATION.WAERS == TCURC.WAERS
  • P_SCHDLNMIGRATION.WAERS_BASE == TCURC.WAERS
Plant
  • Client
  • Plant
  • P_SCHDLNMIGRATION.MANDT == T001W.MANDT
  • P_SCHDLNMIGRATION.WERKS == T001W.WERKS