C_BlockedSupplierOpenItem

Blocked Supplier Open Item | view: CGRCBLKSUPOPNITM | Extraction: Not supported | Component: Information System

Tables used: BKPF, BSEG, T001, TKA02, TKA01, T000, LFA1, LFB1, T001, T014, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (4)
💰 Amounts (1)
∑ Quantities
📅 Dates (4)
☰ Categorical (7)
Other (13)
🔗 Relations (11)

Column Name	Description
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
JournalEntry	Journal Entry
AccountingDocumentItem	Journal Entry Posting View Item

Column Name	Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency	Amount in Company Code Currency

Column Name	Description

Column Name	Description
PostingDate	Posting Date
DocumentDate	Journal Entry Date
AccountingDocumentCreationDate	Accounting Document Entry Date
LastChangeDate	Last Change Date

Column Name	Description
AccountingDocumentCategory	Journal Entry Category	Show values
DebitCreditCode	Debit/Credit Code	Show values
FinancialAccountType	Account Type	Show values
IsCompletelyDelivered	Is completely delivered	Show values
ClearingIsReversed	Clearing Is Reversed	Show values
IsSalesRelated	Is Sales Related	Show values
IsUsedInPaymentTransaction	Is Used In Payment Transaction	Show values

Column Name	Description	Domain name
SupplierName	Name of Supplier	TEXT80
FiscalYearPeriod	Fiscal Year + Fiscal Period	FINS_FYEARPERIOD
AccountingDocCreatedByUser	User that created the journal entry
TransactionCode	Transaction Code	TCODE
ReverseDocument	Reverse Document	BELNR
DocumentReferenceID	Document Reference ID	XBLNR1
ReferenceDocumentType	Reference Document Type	AWTYP
ControllingAreaName	Controlling Area Name	TEXT25
ProfitCenter	Profit Center	PRCTR
CostCenter	Cost Center	KOSTL
SpecialGLTransactionType	Special G/L Transaction Type	UMSKS
CompanyCodeName	Name of Company Code or Company	TEXT25
FiscalPeriod	Fiscal Period	POPER

Master Data Relations	Join Conditions
Journal Entry Type Journal Entry Type Client	`C_BLOCKEDSUPPLIEROPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `C_BLOCKEDSUPPLIEROPENITEM.MANDT == T003.MANDT`
Chart of Accounts Chart of Accounts Client	`C_BLOCKEDSUPPLIEROPENITEM.CHARTOFACCOUNTS == T004.KTOPL` `C_BLOCKEDSUPPLIEROPENITEM.MANDT == T004.MANDT`
Company Code Client Company Code	`C_BLOCKEDSUPPLIEROPENITEM.MANDT == T001.MANDT` `C_BLOCKEDSUPPLIEROPENITEM.COMPANYCODE == T001.BUKRS`
Controlling Area Controlling Area Client	`C_BLOCKEDSUPPLIEROPENITEM.CONTROLLINGAREA == TKA01.KOKRS` `C_BLOCKEDSUPPLIEROPENITEM.MANDT == TKA01.MANDT`
Customer Number Client Customer Number	`C_BLOCKEDSUPPLIEROPENITEM.MANDT == KNA1.MANDT` `C_BLOCKEDSUPPLIEROPENITEM.CUSTOMER == KNA1.KUNNR`
Fiscal Year Variant Fiscal Year Variant Client	`C_BLOCKEDSUPPLIEROPENITEM.FISCALYEARVARIANT == T009.PERIV` `C_BLOCKEDSUPPLIEROPENITEM.MANDT == T009.MANDT`
G/L Account Client Company Code G/L Account	`C_BLOCKEDSUPPLIEROPENITEM.MANDT == SKB1.MANDT` `C_BLOCKEDSUPPLIEROPENITEM.COMPANYCODE == SKB1.BUKRS` `C_BLOCKEDSUPPLIEROPENITEM.GLACCOUNT == SKB1.SAKNR`
Posting Key Posting Key Client	`C_BLOCKEDSUPPLIEROPENITEM.POSTINGKEY == TBSL.BSCHL` `C_BLOCKEDSUPPLIEROPENITEM.MANDT == TBSL.MANDT`
Special G/L Indicator Client Special G/L Indicator ?	`C_BLOCKEDSUPPLIEROPENITEM.MANDT == T074U.MANDT` `C_BLOCKEDSUPPLIEROPENITEM.SPECIALGLCODE == T074U.UMSKZ` `C_BLOCKEDSUPPLIEROPENITEM.[column in domain "KOART"] == T074U.KOART`
Supplier Supplier Client	`C_BLOCKEDSUPPLIEROPENITEM.SUPPLIER == LFA1.LIFNR` `C_BLOCKEDSUPPLIEROPENITEM.MANDT == LFA1.MANDT`
Vendor account group Vendor account group Client	`C_BLOCKEDSUPPLIEROPENITEM.SUPPLIERACCOUNTGROUP == T077K.KTOKK` `C_BLOCKEDSUPPLIEROPENITEM.MANDT == T077K.MANDT`