P_Purchaseorders_Fs

Private factsheet - Purchase Orders | view: PPURORDERSFS | Extraction: Not supported | Component: Material Master
Tables used: EKKOEKPOT001TKA02T161TT024T024ET001WLFA1ADRPUSR21
Column Name Description
PurchasingDocument Purchasing Document Number
Column Name Description
Column Name Description
Column Name Description
PurchasingDocumentOrderDate Purchasing Document Date
CreationDate Creation Date of Purchasing Document
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
PersonFullName Full Name of Person TEXT80
PurchasingDocumentDeletionCode null
IncotermsTransferLocation Incoterms (Part 2) INCO2
AdditionalName Name 2 NAME
PaymentTerms Terms of Payment Key ZTERM
CreatedByUser User of person who created a purchasing document USNAM
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingOrganizationName Purchasing Organization Name TEXT20
SupplierName null
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PlantName Plant Name TEXT30
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_PURCHASEORDERS_FS.COMPANYCODE == T001.BUKRS
  • P_PURCHASEORDERS_FS.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_PURCHASEORDERS_FS.DOCUMENTCURRENCY == TCURC.WAERS
  • P_PURCHASEORDERS_FS.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • P_PURCHASEORDERS_FS.INCOTERMSCLASSIFICATION == TINC.INCO1
  • P_PURCHASEORDERS_FS.MANDT == TINC.MANDT
Language Key P_PURCHASEORDERS_FS.LANGUAGE == T002.SPRAS
Material Number
  • Material Number
  • Client
  • P_PURCHASEORDERS_FS.MATERIAL == MARA.MATNR
  • P_PURCHASEORDERS_FS.MANDT == MARA.MANDT
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • P_PURCHASEORDERS_FS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_PURCHASEORDERS_FS.MANDT == T161.MANDT
  • P_PURCHASEORDERS_FS.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASEORDERS_FS.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASEORDERS_FS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASEORDERS_FS.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASEORDERS_FS.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURCHASEORDERS_FS.SUPPLIER == LFA1.LIFNR
  • P_PURCHASEORDERS_FS.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • P_PURCHASEORDERS_FS.MANDT == T001W.MANDT
  • P_PURCHASEORDERS_FS.SUPPLYINGPLANT == T001W.WERKS