P_GRAndInvcHistoryBcs

Good Reciepts and Invoices History | view: PGRCGRINVCHIST | Extraction: Not supported | Component: Information System
Tables used: MATDOCEKKOEKBEEKPORBKPRBKPBRBDRSEGRSEGT001TKA02LFA1
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem FK Item Number of Purchasing Document
AccountAssignmentNumber Sequential Number of Account Assignment
PurchasingHistoryDocumentType Transaction/event type, purchase order history Show values
PurchasingHistoryDocumentYear Material Document Year
PurchasingHistoryDocument Number of Material Document
PurchasingHistoryDocumentItem Item in Material Document
Column Name Description
Column Name Description
Column Name Description
InvoiceCreationDate Day On Which Accounting Document Was Entered
GoodsReceiptLatestCreationDate Day On Which Accounting Document Was Entered
Column Name Description
PurchasingHistoryDocumentType Transaction/event type, purchase order history Show values
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
Column Name Description Domain name
SupplierInvoice Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
InvoiceCreatedByUser Name of the Processor Who Entered the Object USNAM
MaterialDocument Number of Material Document BELNR
GRCreatedByUser User Name XUBNAME
SupplierName Name of Supplier TEXT80
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_GRANDINVCHISTORYBCS.COMPANYCODE == T001.BUKRS
  • P_GRANDINVCHISTORYBCS.MANDT == T001.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • P_GRANDINVCHISTORYBCS.INVOICINGPARTY == LFA1.LIFNR
  • P_GRANDINVCHISTORYBCS.MANDT == LFA1.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • P_GRANDINVCHISTORYBCS.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_GRANDINVCHISTORYBCS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_GRANDINVCHISTORYBCS.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_GRANDINVCHISTORYBCS.PURCHASINGGROUP == T024.EKGRP
  • P_GRANDINVCHISTORYBCS.MANDT == T024.MANDT
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • P_GRANDINVCHISTORYBCS.PURCHASINGHISTORYCATEGORY == T163B.BEWTP
  • P_GRANDINVCHISTORYBCS.MANDT == T163B.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_GRANDINVCHISTORYBCS.PURCHASINGORGANIZATION == T024E.EKORG
  • P_GRANDINVCHISTORYBCS.MANDT == T024E.MANDT