P_SchedgAgrmtItemHistory1

Scheduling Agreement Item History 1 | view: PSCHAGITMHIST1 | Extraction: Not supported | Component: Scheduling Agreement
Tables used: EKKO, EKET, EKBE, EKBEH, EKPO, T161T, USR21
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem Item Number of Purchasing Document
Column Name Description
TargetAmount null
GoodsReceiptAmountInDspCrcy null
InvoiceAmtInDisplayCurrency null
Column Name Description
ScheduleLineOrderQuantity null
GoodsReceiptQuantity null
InvoiceReceiptQty null
TargetQuantity Target Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
today null
PurchasingDocumentOrderDate Purchasing Document Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingProcessingStatus Purchasing document processing state Show values
Column Name Description Domain name
NetPriceAmount null
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
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_SCHEDGAGRMTITEMHISTORY1.COMPANYCODE == T001.BUKRS
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == TCURC.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == MARA.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T023.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T134.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.MATERIALTYPE == T134.MTART
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T006.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T001W.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.PLANT == T001W.WERKS
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T161.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDGAGRMTITEMHISTORY1.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHEDGAGRMTITEMHISTORY1.PURCHASINGGROUP == T024.EKGRP
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T024E.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Client
  • Storage Location
  • Plant
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == T001L.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.STORAGELOCATION == T001L.LGORT
  • P_SCHEDGAGRMTITEMHISTORY1.PLANT == T001L.WERKS
Supplier
  • Client
  • Supplier
  • P_SCHEDGAGRMTITEMHISTORY1.MANDT == LFA1.MANDT
  • P_SCHEDGAGRMTITEMHISTORY1.SUPPLIER == LFA1.LIFNR