C_SameUsrToCreatePOAndInvc

Same user create PO and Invoice | view: CGRCSUCRPOINV | Extraction: Not supported | Component: Information System
Tables used: EKKOEKBEEKPORBKPRBKPBRBDRSEGRSEGT001TKA02LFA1
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
💲 Currency Key (DocumentCurrency):
GrossAmount null
Column Name Description
Column Name Description
PurchasingDocumentCreationDate Creation Date of Purchasing Document
InvoiceCreationDate Day On Which Accounting Document Was Entered
PostingDate Posting Date in the Document
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
PurchaseOrderCreatedByUser 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
  • Client
  • Company Code
  • C_SAMEUSRTOCREATEPOANDINVC.MANDT == T001.MANDT
  • C_SAMEUSRTOCREATEPOANDINVC.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_SAMEUSRTOCREATEPOANDINVC.MANDT == TCURC.MANDT
  • C_SAMEUSRTOCREATEPOANDINVC.DOCUMENTCURRENCY == TCURC.WAERS
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • C_SAMEUSRTOCREATEPOANDINVC.MANDT == T156.MANDT
  • C_SAMEUSRTOCREATEPOANDINVC.GOODSMOVEMENTTYPE == T156.BWART
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • C_SAMEUSRTOCREATEPOANDINVC.MANDT == LFA1.MANDT
  • C_SAMEUSRTOCREATEPOANDINVC.INVOICINGPARTY == LFA1.LIFNR
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • C_SAMEUSRTOCREATEPOANDINVC.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_SAMEUSRTOCREATEPOANDINVC.MANDT == T161.MANDT
  • C_SAMEUSRTOCREATEPOANDINVC.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_SAMEUSRTOCREATEPOANDINVC.MANDT == T024.MANDT
  • C_SAMEUSRTOCREATEPOANDINVC.PURCHASINGGROUP == T024.EKGRP
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • C_SAMEUSRTOCREATEPOANDINVC.PURCHASINGHISTORYCATEGORY == T163B.BEWTP
  • C_SAMEUSRTOCREATEPOANDINVC.MANDT == T163B.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_SAMEUSRTOCREATEPOANDINVC.MANDT == T024E.MANDT
  • C_SAMEUSRTOCREATEPOANDINVC.PURCHASINGORGANIZATION == T024E.EKORG