C_InvcdPurgDocNoGdsRcpt

Invoices posted for payment without a GR | view: CGRCINVPDWTTGDRC | Extraction: Not supported | Component: Information System
Tables used: EKKOEKBEEKPOEKBEHRBKPRBKPBEKKOT001TKA02LFA1
Column Name Description
CompanyCode FK Company Code
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem FK Item Number of Purchasing Document
SupplierInvoice Document Number of an Invoice Document
FiscalYear Fiscal Year
Column Name Description
💲 Currency Key (DocumentCurrency):
GrossAmount Gross order value in PO currency
InvoiceGrossAmount Gross Invoice Amount in Document Currency
Column Name Description
Column Name Description
CreationDate Day On Which Accounting Document Was Entered
PurchasingDocumentCreationDate Creation Date of Purchasing Document
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
PurchasingHistoryDocumentType Transaction/event type, purchase order history Show values
Column Name Description Domain name
InvoiceCreatedByUser Name of the Processor Who Entered the Object USNAM
CreatedByUser User of person who created a purchasing document USNAM
LastChangeDateTime Change Time Stamp TZNTSTMPL
SupplierFullName Supplier Full Name TEXT220
InvoiceIsExisting null
GoodsReceiptIsExisting null
PurchasingHistoryDocumentYear Material Document Year GJAHR
PurchasingHistoryDocument Number of Material Document BELNR
PurchasingHistoryDocumentItem Item in Material Document MBLPO
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_INVCDPURGDOCNOGDSRCPT.COMPANYCODE == T001.BUKRS
  • C_INVCDPURGDOCNOGDSRCPT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_INVCDPURGDOCNOGDSRCPT.DOCUMENTCURRENCY == TCURC.WAERS
  • C_INVCDPURGDOCNOGDSRCPT.MANDT == TCURC.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • C_INVCDPURGDOCNOGDSRCPT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_INVCDPURGDOCNOGDSRCPT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_INVCDPURGDOCNOGDSRCPT.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_INVCDPURGDOCNOGDSRCPT.PURCHASINGGROUP == T024.EKGRP
  • C_INVCDPURGDOCNOGDSRCPT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_INVCDPURGDOCNOGDSRCPT.PURCHASINGORGANIZATION == T024E.EKORG
  • C_INVCDPURGDOCNOGDSRCPT.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_INVCDPURGDOCNOGDSRCPT.SUPPLIER == LFA1.LIFNR
  • C_INVCDPURGDOCNOGDSRCPT.MANDT == LFA1.MANDT
Vendor account group
  • Vendor account group
  • Client
  • C_INVCDPURGDOCNOGDSRCPT.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_INVCDPURGDOCNOGDSRCPT.MANDT == T077K.MANDT