C_PurReqnSchedAgrmtVH

Sched Agreement val help for Prof PR | view: CPURREQNSCDAGRMT | Extraction: Not supported | Component: Purchase Requisitions
Tables used: EKKOEKPO
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PURREQNSCHEDAGRMTVH.COMPANYCODE == T001.BUKRS
  • C_PURREQNSCHEDAGRMTVH.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_PURREQNSCHEDAGRMTVH.MANDT == TCURC.MANDT
  • C_PURREQNSCHEDAGRMTVH.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • C_PURREQNSCHEDAGRMTVH.MATERIAL == MARA.MATNR
  • C_PURREQNSCHEDAGRMTVH.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_PURREQNSCHEDAGRMTVH.MANDT == T023.MANDT
  • C_PURREQNSCHEDAGRMTVH.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURREQNSCHEDAGRMTVH.MANDT == T001W.MANDT
  • C_PURREQNSCHEDAGRMTVH.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • C_PURREQNSCHEDAGRMTVH.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURREQNSCHEDAGRMTVH.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURREQNSCHEDAGRMTVH.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURREQNSCHEDAGRMTVH.PURCHASINGGROUP == T024.EKGRP
  • C_PURREQNSCHEDAGRMTVH.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURREQNSCHEDAGRMTVH.MANDT == T024E.MANDT
  • C_PURREQNSCHEDAGRMTVH.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Client
  • Plant
  • Storage Location
  • C_PURREQNSCHEDAGRMTVH.MANDT == T001L.MANDT
  • C_PURREQNSCHEDAGRMTVH.PLANT == T001L.WERKS
  • C_PURREQNSCHEDAGRMTVH.STORAGELOCATION == T001L.LGORT
Supplier
  • Supplier
  • Client
  • C_PURREQNSCHEDAGRMTVH.SUPPLIER == LFA1.LIFNR
  • C_PURREQNSCHEDAGRMTVH.MANDT == LFA1.MANDT