ESH_S_SCHED_AGREEMENT_H

Search view -SCHED_AGREEMENT_H | view: ESH_U_SCHEDAGRMT | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: AFKOAFVCAFVUAFVVEKKOEKPOEKKNJESTPRTEEKKOEKPOT001TKA02TKA01MARAT023T023TMAKTAUFKT430T001WT024WPROJPROJCNLDST_SHORTTXT161T161TT024T024ET000LFA1LFM1USR21PRPSCRHD
Column Name Description
SCHEDULINGAGREEMENT Purchasing Document Number
Column Name Description
Column Name Description
Column Name Description
VALIDITYENDDATE End of Validity Period
VALIDITYSTARTDATE Start of Validity Period
Column Name Description
PURCHASINGDOCUMENTCATEGORY Purchasing Document Category Show values
Column Name Description Domain name
COMPANYCODENAME Name of Company Code or Company TEXT25
CREATEDBYUSER User of person who created a purchasing document USNAM
MATERIALGROUPNAME Product Group Description TEXT20
MATERIALNAME Material Description TEXT40
ORGANIZATIONBPNAME1 Name 1 NAME
PLANT Plant WERKS
PLANTNAME Plant Name TEXT30
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type TEXT20
PURCHASINGGROUPNAME Purchasing Group Name TEXT18
PURCHORGANIZATION Purchasing Organization EKORG
PURCHASINGORGANIZATIONNAME Purchasing Organization Name TEXT20
PURCHSINGORGNAIZATIONNAME Purchasing Organization Name TEXT20
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • ESH_S_SCHED_AGREEMENT_H.MATERIAL == MARA.MATNR
  • ESH_S_SCHED_AGREEMENT_H.MANDT == MARA.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • ESH_S_SCHED_AGREEMENT_H.PROJECTNETWORK == AUFK.AUFNR
  • ESH_S_SCHED_AGREEMENT_H.MANDT == AUFK.MANDT
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • ESH_S_SCHED_AGREEMENT_H.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • ESH_S_SCHED_AGREEMENT_H.PURCHASINGDOCUMENTTYPE == T161.BSART
  • ESH_S_SCHED_AGREEMENT_H.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_S_SCHED_AGREEMENT_H.PURCHASINGGROUP == T024.EKGRP
  • ESH_S_SCHED_AGREEMENT_H.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Purchasing Organization
  • Client
  • ESH_S_SCHED_AGREEMENT_H.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_S_SCHED_AGREEMENT_H.PURCHORGANIZATION == T024E.EKORG
  • ESH_S_SCHED_AGREEMENT_H.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • ESH_S_SCHED_AGREEMENT_H.SUPPLIER == LFA1.LIFNR
  • ESH_S_SCHED_AGREEMENT_H.MANDT == LFA1.MANDT