P_FilteredSourceOfSupply

Filtered Source of Supply | view: PFILTERDSOS | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO
Column Name Description
SourceDocument Purchasing Document Number
SourceDocumentItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
TargetAmount Target Value for Header Area per Distribution
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
Column Name Description
ValidityEndDate End of Validity Period
ValidityStartDate Start of Validity Period
CreationDate Creation Date of Purchasing Document
Column Name Description
PurchasingSourceType Purchasing Document Category Show values
Column Name Description Domain name
NetPriceQuantity Price Unit DEC5
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == TCURC.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == MARA.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == T023.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == T006.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == T001W.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.PLANT == T001W.WERKS
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == T161.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_FILTEREDSOURCEOFSUPPLY.PURCHASINGSOURCETYPE == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == T024.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == T024E.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_FILTEREDSOURCEOFSUPPLY.MANDT == LFA1.MANDT
  • P_FILTEREDSOURCEOFSUPPLY.SUPPLIER == LFA1.LIFNR