C_ClrdInvcPurgDocWthoutGds

PO with cleared invoices without a GR | view: CGRCCLINVPDWTHTG | Extraction: Not supported | Component: Information System
Column Name Description
CompanyCode FK Company Code
PurchasingDocument FK Purchasing Document
PurchasingDocumentItem FK Purchasing Document Item
Column Name Description
💲 Currency Key (DocumentCurrency):
GrossAmount Gross order value in PO currency
💲 Company Code Currency (CompanyCodeCurrency):
InvoiceRcptAmtInCoCodeCrcy Invoice Receipt Amount in Company Code Currency
Column Name Description
Column Name Description
CreationDate 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
InvoiceCreatedByUser Name of the Processor Who Entered the Object USNAM
CreatedByUser User of person who created a purchasing document USNAM
NumberOfGoodsReceipts Number of Goods Receipts
NumberOfInvoiceReceipts Number of Invoice Receipts
SupplierName Name of Supplier TEXT80
SupplierInvoice Document Number of an Invoice Document BELNR
LastChangedByUser User of Last Change in GR/IR Clearing Process XUBNAME
GRIRClearingProcessStatus GR/IR Clearing Process Status FIS_GRIR_CLEARING_STATUS
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == T001.MANDT
  • C_CLRDINVCPURGDOCWTHOUTGDS.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == TCURC.MANDT
  • C_CLRDINVCPURGDOCWTHOUTGDS.COMPANYCODECURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == TCURC.MANDT
  • C_CLRDINVCPURGDOCWTHOUTGDS.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • C_CLRDINVCPURGDOCWTHOUTGDS.MATERIAL == MARA.MATNR
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == T001W.MANDT
  • C_CLRDINVCPURGDOCWTHOUTGDS.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • C_CLRDINVCPURGDOCWTHOUTGDS.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_CLRDINVCPURGDOCWTHOUTGDS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_CLRDINVCPURGDOCWTHOUTGDS.PURCHASINGGROUP == T024.EKGRP
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_CLRDINVCPURGDOCWTHOUTGDS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_CLRDINVCPURGDOCWTHOUTGDS.SUPPLIER == LFA1.LIFNR
  • C_CLRDINVCPURGDOCWTHOUTGDS.MANDT == LFA1.MANDT