C_InvcBfrPurgDocument

Invoices created before PO | view: CGRCINVBFRPURGDC | TRAN | Extraction: Not supported | Component: Information System
Tables used: EKKOEKPORBKPRBKPBRBDRSEGRSEGLFA1
Column Name Description
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year
SupplierInvoiceItem Document Item in Invoice Document
Column Name Description
💲 Currency Key (DocumentCurrency):
SupplierInvoiceItemAmount Amount in Document Currency
GrossAmount null
Column Name Description
Column Name Description
InvoiceCreationDate Day On Which Accounting Document Was Entered
PurchasingDocumentCreationDate Creation Date of Purchasing Document
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
SupplierFullName Supplier Full Name TEXT220
SupplierInvoiceItemText Item Text TEXT50
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_INVCBFRPURGDOCUMENT.COMPANYCODE == T001.BUKRS
  • C_INVCBFRPURGDOCUMENT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_INVCBFRPURGDOCUMENT.DOCUMENTCURRENCY == TCURC.WAERS
  • C_INVCBFRPURGDOCUMENT.MANDT == TCURC.MANDT
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • C_INVCBFRPURGDOCUMENT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_INVCBFRPURGDOCUMENT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_INVCBFRPURGDOCUMENT.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_INVCBFRPURGDOCUMENT.PURCHASINGGROUP == T024.EKGRP
  • C_INVCBFRPURGDOCUMENT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_INVCBFRPURGDOCUMENT.PURCHASINGORGANIZATION == T024E.EKORG
  • C_INVCBFRPURGDOCUMENT.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_INVCBFRPURGDOCUMENT.SUPPLIER == LFA1.LIFNR
  • C_INVCBFRPURGDOCUMENT.MANDT == LFA1.MANDT