P_GLACCOUNT_HIST_EXTRACTION

CDS view for historic data extraction | view: P_GL_HIST | Extraction: Not supported | Component: Fiori UI for Accounts Receivable
Tables used: BSEGFEBKOFEBEP
Column Name Description
BankStatementShortID Short Key for Bank Statement (Surrogate Key)
BankStatementItem Memo Record Number (Line Item Number in Bank Statement)
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
CompanyCode FK Company Code
Column Name Description
Column Name Description
Column Name Description
BankStatementDate Statement Date
Column Name Description
MemoLineIsChanged Note to Payee Has Been Changed Manually Show values
InterpretationAlgorithm Interpretation Algorithm Show values
Column Name Description Domain name
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
BankStatement Statement Number NUM5
PaymentTransactionTypeGroup Transaction Type VGTYP_EB
PaymentExternalTransacType External Business Transaction VGEXT_EB
PaymentTransaction Business Transaction Code CHAR3
BankPostingKey Text Key CHAR4
PaymentManualTransacType Transaction VGMAN_EB
PaymentTransactionDescription Bank Posting Text CHAR50
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
Cheque Check number CHCKN
BankReference Bank Reference Number CHAR35
PaymentReference Payment Reference CHAR30
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
BankStatementItemDescription1 Additional Information 1 CHAR30
BankStatementItemDescription2 Additional Information 2 CHAR30
RecordOccurence null
Master Data Relations Join Conditions
Document Type
  • Client
  • Document Type
  • P_GLACCOUNT_HIST_EXTRACTION.MANDT == T003.MANDT
  • P_GLACCOUNT_HIST_EXTRACTION.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Input Help for Posting Rule (Internal Activity)
  • Client
  • Posting Rule
  • P_GLACCOUNT_HIST_EXTRACTION.MANDT == T028D.MANDT
  • P_GLACCOUNT_HIST_EXTRACTION.BANKSTATEMENTPOSTINGRULE == T028D.VGINT
Company code
  • Client
  • Company Code
  • P_GLACCOUNT_HIST_EXTRACTION.MANDT == T001.MANDT
  • P_GLACCOUNT_HIST_EXTRACTION.COMPANYCODE == T001.BUKRS
General Ledger Account
  • General Ledger Account
  • Client
  • Company Code
  • P_GLACCOUNT_HIST_EXTRACTION.GLACCOUNT == SKB1.SAKNR
  • P_GLACCOUNT_HIST_EXTRACTION.MANDT == SKB1.MANDT
  • P_GLACCOUNT_HIST_EXTRACTION.COMPANYCODE == SKB1.BUKRS
Foreign currency (not account currency)
  • Client
  • Foreign Currency Key (Not Account Currency)
  • P_GLACCOUNT_HIST_EXTRACTION.MANDT == TCURC.MANDT
  • P_GLACCOUNT_HIST_EXTRACTION.ORIGINALCURRENCY == TCURC.WAERS
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • P_GLACCOUNT_HIST_EXTRACTION.MANDT == T007A.MANDT
  • P_GLACCOUNT_HIST_EXTRACTION.TAXCODE == T007A.MWSKZ
  • P_GLACCOUNT_HIST_EXTRACTION.[column in domain "KALSM_D"] == T007A.KALSM