C_PurOrdScheduleLineDEX

Data Extraction for Purchase Order Schedule Lines | view: CMMPURORDSLDEX | TRAN | Extraction: Full or Incremental | Component: Reporting

Tables used: EKKO, EKPO, EKET, EKKO, EKPO

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (6)
📅 Dates (15)
☰ Categorical (9)
Other (9)
🔗 Relations (25)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem FK	Item Number of Purchasing Document
PurchaseOrderScheduleLine	Delivery Schedule Line Counter

Column Name	Description
💲 Currency Key (DocumentCurrency):
OpenPurchaseOrderNetAmount	null

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
ScheduleLineOrderQuantity	Scheduled Quantity
PrevDelivQtyOfScheduleLine	Previous Quantity (Delivery Schedule Lines)
RoughGoodsReceiptQty	Quantity of goods received
ScheduleLineIssuedQuantity	Issued Quantity
StockTransferDeliveredQuantity	Quantity Delivered (Stock Transfer)
ScheduleLineCommittedQuantity	Committed Quantity

Column Name	Description
ScheduleLineDeliveryDate	Item delivery date
ScheduleLineDeliveryTime	Delivery Date Time-Spot
PurchaseOrderDate	Purchase Order Date
ValidityStartDate	Start of Validity Period
ValidityEndDate	End of Validity Period
ProductAvailabilityDate	Material Staging/Availability Date
ProductAvailabilityTime	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
ArticleCategory	Material Category	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
IsFinallyInvoiced	Final Invoice Indicator	Show values
InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)	Show values
PurchasingDocumentOrigin	Status of Purchasing Document	Show values
SourceOfCreation	Creation indicator (purchase requisition/schedule lines)	Show values
ScheduleLineIsFixed	Schedule Line is "Fixed"	Show values

Column Name	Description	Domain name
PurchaseRequisition	Purchase Requisition Number	BANFN
Batch	Batch Number	CHARG
PurchasingSchdLnNrOfReminders	No. of Reminders/Expediters for Schedule Line	PACK2
RequisitionerName	Name of requisitioner/requester	AFNAM
PurchaseOrderItemText	Short Text	TEXT40
OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
ExchangeRate	Exchange Rate	FIS_UKURS
Reservation	Number of reservation/dependent requirements	RSNUM

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`C_PURORDSCHEDULELINEDEX.BASEUNIT == T006.MSEHI` `C_PURORDSCHEDULELINEDEX.MANDT == T006.MANDT`
Currency Key Client Currency Key	`C_PURORDSCHEDULELINEDEX.MANDT == TCURC.MANDT` `C_PURORDSCHEDULELINEDEX.DOCUMENTCURRENCY == TCURC.WAERS`
Different Invoicing Party Client Different Invoicing Party	`C_PURORDSCHEDULELINEDEX.MANDT == LFA1.MANDT` `C_PURORDSCHEDULELINEDEX.INVOICINGPARTY == LFA1.LIFNR`
Issuing Storage Location for Stock Transport Order Client Supplying (issuing) plant in case of stock transport order Issuing Storage Location for Stock Transport Order	`C_PURORDSCHEDULELINEDEX.MANDT == T001L.MANDT` `C_PURORDSCHEDULELINEDEX.SUPPLYINGPLANT == T001L.WERKS` `C_PURORDSCHEDULELINEDEX.ISSUINGSTORAGELOCATION == T001L.LGORT`
Material number Material number Client	`C_PURORDSCHEDULELINEDEX.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURORDSCHEDULELINEDEX.MANDT == MARA.MANDT`
Material Number Client Material Number	`C_PURORDSCHEDULELINEDEX.MANDT == MARA.MANDT` `C_PURORDSCHEDULELINEDEX.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_PURORDSCHEDULELINEDEX.MANDT == T023.MANDT` `C_PURORDSCHEDULELINEDEX.MATERIALGROUP == T023.MATKL`
Plant Client Plant	`C_PURORDSCHEDULELINEDEX.MANDT == T001W.MANDT` `C_PURORDSCHEDULELINEDEX.PLANT == T001W.WERKS`
Item category in purchasing document Client Item category in purchasing document	`C_PURORDSCHEDULELINEDEX.MANDT == T163.MANDT` `C_PURORDSCHEDULELINEDEX.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_PURORDSCHEDULELINEDEX.MANDT == T006.MANDT` `C_PURORDSCHEDULELINEDEX.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type Client Purchase Order Type ?	`C_PURORDSCHEDULELINEDEX.MANDT == T161.MANDT` `C_PURORDSCHEDULELINEDEX.PURCHASEORDERTYPE == T161.BSART` `C_PURORDSCHEDULELINEDEX.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Client Purchasing Group	`C_PURORDSCHEDULELINEDEX.MANDT == T024.MANDT` `C_PURORDSCHEDULELINEDEX.PURCHASINGGROUP == T024.EKGRP`
Reason for Ordering Reason for Ordering Client	`C_PURORDSCHEDULELINEDEX.PURCHASINGORDERREASON == TBSG.BSGRU` `C_PURORDSCHEDULELINEDEX.MANDT == TBSG.MANDT`
Purchasing organization Client Purchasing organization	`C_PURORDSCHEDULELINEDEX.MANDT == T024E.MANDT` `C_PURORDSCHEDULELINEDEX.PURCHASINGORGANIZATION == T024E.EKORG`
Promotion Client Promotion	`C_PURORDSCHEDULELINEDEX.MANDT == WAKH.MANDT` `C_PURORDSCHEDULELINEDEX.RETAILPROMOTION == WAKH.AKTNR`
Storage Location Client Plant Storage Location	`C_PURORDSCHEDULELINEDEX.MANDT == T001L.MANDT` `C_PURORDSCHEDULELINEDEX.PLANT == T001L.WERKS` `C_PURORDSCHEDULELINEDEX.STORAGELOCATION == T001L.LGORT`
Supplier Client Supplier	`C_PURORDSCHEDULELINEDEX.MANDT == LFA1.MANDT` `C_PURORDSCHEDULELINEDEX.SUPPLIER == LFA1.LIFNR`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`C_PURORDSCHEDULELINEDEX.MANDT == T001W.MANDT` `C_PURORDSCHEDULELINEDEX.SUPPLYINGPLANT == T001W.WERKS`
Goods Supplier Client Goods Supplier	`C_PURORDSCHEDULELINEDEX.MANDT == LFA1.MANDT` `C_PURORDSCHEDULELINEDEX.SUPPLYINGSUPPLIER == LFA1.LIFNR`