C_SameUsrToProcGRAndInvc

Same user processes GR and invoice | view: CGRCP006 | 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
MaterialDocument Number of Material Document
Column Name Description
💲 Currency Key (DocumentCurrency):
GrossAmount null
Column Name Description
Column Name Description
GoodsReceiptLatestCreationDate Day On Which Accounting Document Was Entered
CreationDate Creation Date of Purchasing Document
InvoiceCreationDate 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
GRCreatedByUser User Name
CreatedByUser User of person who created a purchasing document
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year GJAHR
InvoiceCreatedByUser Name of the Processor Who Entered the Object
SupplierName Name of Supplier TEXT80
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_SAMEUSRTOPROCGRANDINVC.COMPANYCODE == T001.BUKRS
  • C_SAMEUSRTOPROCGRANDINVC.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_SAMEUSRTOPROCGRANDINVC.DOCUMENTCURRENCY == TCURC.WAERS
  • C_SAMEUSRTOPROCGRANDINVC.MANDT == TCURC.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • C_SAMEUSRTOPROCGRANDINVC.INVOICINGPARTY == LFA1.LIFNR
  • C_SAMEUSRTOPROCGRANDINVC.MANDT == LFA1.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • C_SAMEUSRTOPROCGRANDINVC.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_SAMEUSRTOPROCGRANDINVC.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_SAMEUSRTOPROCGRANDINVC.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_SAMEUSRTOPROCGRANDINVC.PURCHASINGGROUP == T024.EKGRP
  • C_SAMEUSRTOPROCGRANDINVC.MANDT == T024.MANDT
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • C_SAMEUSRTOPROCGRANDINVC.PURCHASINGHISTORYCATEGORY == T163B.BEWTP
  • C_SAMEUSRTOPROCGRANDINVC.MANDT == T163B.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_SAMEUSRTOPROCGRANDINVC.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SAMEUSRTOPROCGRANDINVC.MANDT == T024E.MANDT