P_GLE_ADB_GR_06

Fill currency fields | view: PGLEADBGR_06 | Extraction: Not supported | Component: Average Daily Balance

🔑 Keys
💰 Amounts (9)
∑ Quantities
📅 Dates
☰ Categorical
Other (30)
🔗 Relations (29)

Column Name	Description

Column Name	Description
tsl_m	null
tsl_q	null
tsl_y	null
hsl_m	null
hsl_q	null
hsl_y	null
ksl_m	null
ksl_q	null
ksl_y	null

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
SourceLedger	Ledger in General Ledger Accounting	FINS_LEDGER
Ledger	Ledger in General Ledger Accounting	FINS_LEDGER
LedgerGLLineItem	Six-Character Posting Item for Ledger	DOCLN6
ConsolidationChartOfAccounts	Consolidation Chart of Accounts	FC_ITCLG
CompanyCode	Company Code	BUKRS
PartnerConsolidationUnit	null
ConsolidationVersion	Version	FC_RVERS
ConsolidationUnit	Consolidation Unit	FINCS_MD_BUNIT
AccountingDocument	Document Number of an Accounting Document	BELNR
ConsolidationLedger	Consolidation Ledger	FC_RLDNR_CONS
BaseUnit	null
FiscalPeriod	Fiscal Period	POPER
FiscalYear	Fiscal Year	GJAHR
FinancialStatementItem	Financial Statement Item	FC_ITEM
SubItemCategory	Fixed value for a subitem category-like characteristic	CHAR10
SubItem	null
FinancialTransactionType	Transaction type	RMVCT
FunctionalArea	Functional Area	FKBER
BusinessArea	Business Area	GSBER
CostCenter	Cost Center	KOSTL
GLAccount	Account Number	SAKNR
ProfitCenter	Profit Center	PRCTR
Segment	Segment for Segmental Reporting	FB_SEGMENT
ReferenceFiscalYear	Fiscal Year	GJAHR
AssignmentReference	Assignment Reference	ZUONR
WBSElementExternalID	WBS Element	FIS_WBS
Project	Project	FIS_PROJECT
CustomerSupplierCorporateGroup	Customer Supplier Corporate Group	KONZS
CreationDateTime	Time Stamp of Creation	TZNTSTMPS
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV

Master Data Relations	Join Conditions
Billing Type Billing Type Client	`P_GLE_ADB_GR_06.BILLINGDOCUMENTTYPE == TVFK.FKART` `P_GLE_ADB_GR_06.MANDT == TVFK.MANDT`
Bill-to Party Bill-to Party Client	`P_GLE_ADB_GR_06.BILLTOPARTY == KNA1.KUNNR` `P_GLE_ADB_GR_06.MANDT == KNA1.MANDT`
Chart of Accounts Chart of Accounts Client	`P_GLE_ADB_GR_06.CHARTOFACCOUNTS == T004.KTOPL` `P_GLE_ADB_GR_06.MANDT == T004.MANDT`
Dimension Client Dimension	`P_GLE_ADB_GR_06.MANDT == TF150.MANDT` `P_GLE_ADB_GR_06.CONSOLIDATIONDIMENSION == TF150.DIMEN`
Controlling Area Controlling Area Client	`P_GLE_ADB_GR_06.CONTROLLINGAREA == TKA01.KOKRS` `P_GLE_ADB_GR_06.MANDT == TKA01.MANDT`
Customer Number Customer Number Client	`P_GLE_ADB_GR_06.CUSTOMER == KNA1.KUNNR` `P_GLE_ADB_GR_06.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`P_GLE_ADB_GR_06.CUSTOMERGROUP == T151.KDGRP` `P_GLE_ADB_GR_06.MANDT == T151.MANDT`
Customer or Supplier Country/Region Customer or Supplier Country/Region Client	`P_GLE_ADB_GR_06.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `P_GLE_ADB_GR_06.MANDT == T005.MANDT`
Customer Supplier Industry Customer Supplier Industry Client	`P_GLE_ADB_GR_06.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH` `P_GLE_ADB_GR_06.MANDT == T016.MANDT`
Distribution Channel Distribution Channel Client	`P_GLE_ADB_GR_06.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `P_GLE_ADB_GR_06.MANDT == TVTW.MANDT`
Material Number Material Number Client	`P_GLE_ADB_GR_06.MATERIAL == MARA.MATNR` `P_GLE_ADB_GR_06.MANDT == MARA.MANDT`
Product Sold Group Product Sold Group Product Sold Group Client	`P_GLE_ADB_GR_06.MATERIALGROUP == T023.MATKL` `P_GLE_ADB_GR_06.SOLDPRODUCTGROUP == T023.MATKL` `P_GLE_ADB_GR_06.MANDT == T023.MANDT`
Order ID Order ID Client	`P_GLE_ADB_GR_06.ORDERID == AUFK.AUFNR` `P_GLE_ADB_GR_06.MANDT == AUFK.MANDT`
Division Division Client	`P_GLE_ADB_GR_06.ORGANIZATIONDIVISION == TSPA.SPART` `P_GLE_ADB_GR_06.MANDT == TSPA.MANDT`
Partner Business Area Client Partner Business Area	`P_GLE_ADB_GR_06.MANDT == TGSB.MANDT` `P_GLE_ADB_GR_06.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Company ID of Trading Partner Client	`P_GLE_ADB_GR_06.PARTNERCOMPANY == T880.RCOMP` `P_GLE_ADB_GR_06.MANDT == T880.MANDT`
Partner Cost Center ? Controlling Area Partner Cost Center Client	`P_GLE_ADB_GR_06.[column in domain "DATBI"] == CSKS.DATBI` `P_GLE_ADB_GR_06.CONTROLLINGAREA == CSKS.KOKRS` `P_GLE_ADB_GR_06.PARTNERCOSTCENTER == CSKS.KOSTL` `P_GLE_ADB_GR_06.MANDT == CSKS.MANDT`
Partner Functional Area Client Partner Functional Area	`P_GLE_ADB_GR_06.MANDT == TFKB.MANDT` `P_GLE_ADB_GR_06.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Profit Center Partner Profit Center ? Controlling Area Client	`P_GLE_ADB_GR_06.PARTNERPROFITCENTER == CEPC.PRCTR` `P_GLE_ADB_GR_06.[column in domain "DATBI"] == CEPC.DATBI` `P_GLE_ADB_GR_06.CONTROLLINGAREA == CEPC.KOKRS` `P_GLE_ADB_GR_06.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_GLE_ADB_GR_06.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `P_GLE_ADB_GR_06.MANDT == FAGL_SEGM.MANDT`
Plant Plant Client	`P_GLE_ADB_GR_06.PLANT == T001W.WERKS` `P_GLE_ADB_GR_06.MANDT == T001W.MANDT`
Group Currency of Consolidation Version Client Group Currency of Consolidation Version	`P_GLE_ADB_GR_06.MANDT == TCURC.MANDT` `P_GLE_ADB_GR_06.RGCURR == TCURC.WAERS`
Local Currency Local Currency Client	`P_GLE_ADB_GR_06.RLCURR == TCURC.WAERS` `P_GLE_ADB_GR_06.MANDT == TCURC.MANDT`
Sales District Sales District Client	`P_GLE_ADB_GR_06.SALESDISTRICT == T171.BZIRK` `P_GLE_ADB_GR_06.MANDT == T171.MANDT`
Sales Organization Sales Organization Client	`P_GLE_ADB_GR_06.SALESORGANIZATION == TVKO.VKORG` `P_GLE_ADB_GR_06.MANDT == TVKO.MANDT`
Ship-to Party Ship-to Party Client	`P_GLE_ADB_GR_06.SHIPTOPARTY == KNA1.KUNNR` `P_GLE_ADB_GR_06.MANDT == KNA1.MANDT`
Product Sold Product Sold Client	`P_GLE_ADB_GR_06.SOLDPRODUCT == MARA.MATNR` `P_GLE_ADB_GR_06.MANDT == MARA.MANDT`
Product Sold Group Product Sold Group Product Sold Group Client	`P_GLE_ADB_GR_06.MATERIALGROUP == T023.MATKL` `P_GLE_ADB_GR_06.SOLDPRODUCTGROUP == T023.MATKL` `P_GLE_ADB_GR_06.MANDT == T023.MANDT`
Supplier Supplier Client	`P_GLE_ADB_GR_06.SUPPLIER == LFA1.LIFNR` `P_GLE_ADB_GR_06.MANDT == LFA1.MANDT`