P_SchedgAgrmtItemScheduleLines

Scheduling Agreement Item Schedule Lines | view: PSCHAGSCHEDLINE | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKET, EKKO, EKPO, T161T, USR21
Column Name Description
SchedulingAgreement FK Scheduling Agreement
SchedulingAgreementItem Scheduling Agreement Item
ScheduleLine Delivery Schedule Line Counter
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
NetPriceAmountInDspCrcy null
Column Name Description
TargetQuantity Target Quantity
ScheduleLineOrderQuantity Scheduled Quantity
ScheduleLineExpectedQuantity Scheduled Quantity
Column Name Description
PurchasingDocumentOrderDate Purchasing Document Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
ScheduleLineDeliveryDate Item delivery date
Column Name Description
Column Name Description Domain name
NetPriceQuantity Price Unit DEC5
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
ProductType Product Type Group CHAR2
MultipleAcctAssgmtDistribution null
PartialInvoiceDistribution null
NetPriceQuantityInOrdUnit null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.COMPANYCODE == T001.BUKRS
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == TCURC.MANDT
  • P_SCHEDGAGRMTITEMSCHEDULELINES.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MATERIAL == MARA.MATNR
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MATERIALGROUP == T023.MATKL
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MATERIALTYPE == T134.MTART
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T134.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T006.MANDT
  • P_SCHEDGAGRMTITEMSCHEDULELINES.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.PLANT == T001W.WERKS
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDGAGRMTITEMSCHEDULELINES.[column in domain "BSTYP"] == T161.BSTYP
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.PURCHASINGGROUP == T024.EKGRP
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Plant
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.STORAGELOCATION == T001L.LGORT
  • P_SCHEDGAGRMTITEMSCHEDULELINES.PLANT == T001L.WERKS
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == T001L.MANDT
Supplier
  • Supplier
  • Client
  • P_SCHEDGAGRMTITEMSCHEDULELINES.SUPPLIER == LFA1.LIFNR
  • P_SCHEDGAGRMTITEMSCHEDULELINES.MANDT == LFA1.MANDT