C_APJrnlEntrItmAgingGrid

Aging grid of journal entry view of Accounts Payables | view: CAPJEITMAGGRID | Extraction: Not supported | Component: Information System
Tables used: ACDOCABKPFBSEGT001SADCPADRCT004T001TKA02T005T005TSKA1PROJT005ST005UT074UT074TLFA1T077KT077YLFB1PRPST001T014SKATT004FINSC_LEDGER_REP
Column Name Description
Column Name Description
💲 Display Currency (DisplayCurrency):
TotalAmountInDisplayCrcy Total Amount in Display Currency
TotalNotOvrdAmtInDspCrcy Total Not Due Amount in Display Currency
TotalOverdueAmtInDspCrcy Total Overdue Amount in Display Currency
NetDueIntvl1AmtInDspCrcy Amount in 1st Due Period (Display Currency)
NetDueIntvl2AmtInDspCrcy Amount in 2nd Due Period (Display Currency)
NetDueIntvl3AmtInDspCrcy Amount in 3rd Due Period (Display Currency)
NetDueIntvl4AmtInDspCrcy Amount in 4th Due Period (Display Currency)
FirstIntvlFutrDueAmtInDspCrcy Future Amount in 1st Due Period (Display Currency)
SecondIntvlFutrDueAmtInDspCrcy Future Amount in 2nd Due Period (Display Currency)
ThirdIntvlFutrDueAmtInDspCrcy Future Amount in 3rd Due Period (Display Currency)
FourthIntvlFutrDueAmtInDspCrcy Futre Due Amount for Last Interval in Display Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CompanyCode Company Code BUKRS
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
AccountingDocumentItem Journal Entry Posting View Item BUZEI
Supplier Supplier LIFNR
GLAccount G/L Account SAKNR
SpecialGLCode Special G/L Indicator UMSKZ
ProfitCenter Profit Center PRCTR
BusinessArea Business Area GSBER
Segment Segment for Segmental Reporting FB_SEGMENT
AssignmentReference Assignment Reference ZUONR
SupplierCountry Country / Region Key LAND1
SupplierRegion Region (State, Province, County) REGIO
NetDueIntervalText Net Due Date Interval CHAR50
CompanyCodeName Name of Company Code or Company TEXT25
SupplierName Name of Supplier TEXT80
SupplierCountryName Country/Region Name TEXT50
SupplierRegionName Description TEXT20
AccountingClerkName Name of Accounting Clerk TEXT30
SpecialGLCodeName Long Text for Special G/L Indicators TEXT30
ReconciliationAccountLongName G/L Account Long Text TEXT50
GLAccountLongName G/L Account Long Text TEXT50
SupplierAccountGroupName Account Group Name TEXT30
Master Data Relations Join Conditions
Accounting Clerk
  • Client
  • Accounting Clerk
  • ?
  • C_APJRNLENTRITMAGINGGRID.MANDT == T001S.MANDT
  • C_APJRNLENTRITMAGINGGRID.ACCOUNTINGCLERK == T001S.BUSAB
  • C_APJRNLENTRITMAGINGGRID.[column in domain "BUKRS"] == T001S.BUKRS
Reconciliation Account in General Ledger
  • Client
  • ?
  • Reconciliation Account in General Ledger
  • C_APJRNLENTRITMAGINGGRID.MANDT == SKB1.MANDT
  • C_APJRNLENTRITMAGINGGRID.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_APJRNLENTRITMAGINGGRID.RECONCILIATIONACCOUNT == SKB1.SAKNR
Vendor account group
  • Client
  • Vendor account group
  • C_APJRNLENTRITMAGINGGRID.MANDT == T077K.MANDT
  • C_APJRNLENTRITMAGINGGRID.SUPPLIERACCOUNTGROUP == T077K.KTOKK