P_SchedgAgrmtItemHistory2

Scheduling Agreement Item History 2 | view: PSCHAGITMHIST2 | 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
GoodsReceiptQuantity null
InvoiceReceiptQty null
TargetQuantity Target Quantity
ScheduleLineOrderQuantity null
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
PurchasingDocumentOrderDate Purchasing Document Date
PostingDate Posting Date in the Document
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
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
MultipleAcctAssgmtDistribution null
PartialInvoiceDistribution null
NetPriceAmount null
NetPriceQuantity Price Unit DEC5
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.COMPANYCODE == T001.BUKRS
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.DOCUMENTCURRENCY == TCURC.WAERS
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.MATERIAL == MARA.MATNR
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.MATERIALGROUP == T023.MATKL
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T134.MANDT
  • P_SCHEDGAGRMTITEMHISTORY2.MATERIALTYPE == T134.MTART
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.ORDERQUANTITYUNIT == T006.MSEHI
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.PLANT == T001W.WERKS
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_SCHEDGAGRMTITEMHISTORY2.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.PURCHASINGGROUP == T024.EKGRP
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T024E.MANDT
Storage Location
  • Plant
  • Storage Location
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.PLANT == T001L.WERKS
  • P_SCHEDGAGRMTITEMHISTORY2.STORAGELOCATION == T001L.LGORT
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == T001L.MANDT
Supplier
  • Supplier
  • Client
  • P_SCHEDGAGRMTITEMHISTORY2.SUPPLIER == LFA1.LIFNR
  • P_SCHEDGAGRMTITEMHISTORY2.MANDT == LFA1.MANDT