P_SchedgAgrmt

Scheduling Agreement Details | view: PMMSCHEDAGRMT | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKET, EKKO, EKPO, T161T, USR21
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem Item Number of Purchasing Document
ScheduleLine Delivery Schedule Line Counter
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem FK Item number of purchase requisition
Column Name Description
💲 Currency Key (Currency):
SchedulingAgreementSpend Scheduling Agreement Amount
SchedgAgreementExpectedSpend Expected Spend of Scheduling Agreement
Column Name Description
Column Name Description
ScheduleLineDeliveryDate Item delivery date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
PurchaseOrderDate Purchase Requisition Number BANFN
PurchaseOrderType Purchasing Document Type BSART
ProductType Product Type Group CHAR2
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_SCHEDGAGRMT.COMPANYCODE == T001.BUKRS
  • P_SCHEDGAGRMT.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_SCHEDGAGRMT.MANDT == TCURC.MANDT
  • P_SCHEDGAGRMT.CURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • P_SCHEDGAGRMT.MATERIAL == MARA.MATNR
  • P_SCHEDGAGRMT.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_SCHEDGAGRMT.MANDT == T023.MANDT
  • P_SCHEDGAGRMT.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_SCHEDGAGRMT.MANDT == T001W.MANDT
  • P_SCHEDGAGRMT.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_SCHEDGAGRMT.MANDT == T163.MANDT
  • P_SCHEDGAGRMT.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • P_SCHEDGAGRMT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_SCHEDGAGRMT.MANDT == T161.MANDT
  • P_SCHEDGAGRMT.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHEDGAGRMT.PURCHASINGGROUP == T024.EKGRP
  • P_SCHEDGAGRMT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SCHEDGAGRMT.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SCHEDGAGRMT.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Client
  • Plant
  • P_SCHEDGAGRMT.STORAGELOCATION == T001L.LGORT
  • P_SCHEDGAGRMT.MANDT == T001L.MANDT
  • P_SCHEDGAGRMT.PLANT == T001L.WERKS
Supplier
  • Supplier
  • Client
  • P_SCHEDGAGRMT.SUPPLIER == LFA1.LIFNR
  • P_SCHEDGAGRMT.MANDT == LFA1.MANDT