P_SchedAgrmtDelivSchedule1

Scheduling Agreement Delivery Schedule 1 | view: PSCHAGMTNXTDEL1 | Extraction: Not supported | Component: Scheduling Agreement
Tables used: EKKOEKETEKKOEKPOT161TUSR21
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem Item Number of Purchasing Document
Column Name Description
Column Name Description
Column Name Description
ScheduleLineDeliveryDate null
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
SchedgAgreementItemNextRelDate Next Delivery According To Scheduling Agreement Show values
SchedAgrmtItemIsOverdue Delivery Status Show values
SchedAgrmtItmInApprvlSts Scheduling Agreement In Approval Status Show values
Column Name Description Domain name
SchedAgrmtValidityStatus Purchase Contract Validity Status CHAR20
NumberOfSchedgAgrmtItems null
Master Data Relations Join Conditions
Plant
  • Client
  • Plant
  • P_SCHEDAGRMTDELIVSCHEDULE1.MANDT == T001W.MANDT
  • P_SCHEDAGRMTDELIVSCHEDULE1.PLANT == T001W.WERKS
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • ?
  • P_SCHEDAGRMTDELIVSCHEDULE1.MANDT == T161.MANDT
  • P_SCHEDAGRMTDELIVSCHEDULE1.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDAGRMTDELIVSCHEDULE1.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_SCHEDAGRMTDELIVSCHEDULE1.MANDT == T024.MANDT
  • P_SCHEDAGRMTDELIVSCHEDULE1.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_SCHEDAGRMTDELIVSCHEDULE1.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SCHEDAGRMTDELIVSCHEDULE1.MANDT == T024E.MANDT
Storage Location
  • Client
  • Storage Location
  • Plant
  • P_SCHEDAGRMTDELIVSCHEDULE1.MANDT == T001L.MANDT
  • P_SCHEDAGRMTDELIVSCHEDULE1.STORAGELOCATION == T001L.LGORT
  • P_SCHEDAGRMTDELIVSCHEDULE1.PLANT == T001L.WERKS