P_CO_DIANFrmt1001JrnlEntrOplV2

Format 1001 - JE Operational View | view: PSRCO1001JEOPLV2 | Extraction: Not supported | Component: Financials Colombia
Column Name Description
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmount Amount in Global Currency
AmountInReportingCurrency Amount in Global Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
FinancialAccountType Account Type Show values
OffsettingAccountType Offsetting Account Type Show values
Column Name Description Domain name
TransactionTypeDetermination Transaction Key CHAR3
GLAccount G/L Account Number SAKNR
AccountAssignmentNumber Account Assignment Number NUM02
ReferenceDocumentFiscalYear Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem null
OffsettingAccount Offsetting Account GKONT
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == T003.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Client
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == SKA1.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_CO_DIANFRMT1001JRNLENTROPLV2.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == T004.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == T001.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == T005.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.COMPANYCODECOUNTRY == T005.LAND1
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == T004.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Customer Number
  • Customer Number
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLV2.CUSTOMER == KNA1.KUNNR
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == KNA1.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Reference Document Type P_CO_DIANFRMT1001JRNLENTROPLV2.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Reporting Entity
  • Client
  • Reporting Entity
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == SRF_RPG_ENT.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == LFA1.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • P_CO_DIANFRMT1001JRNLENTROPLV2.MANDT == T007A.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLV2.[column in domain "KALSM_D"] == T007A.KALSM
  • P_CO_DIANFRMT1001JRNLENTROPLV2.TAXCODE == T007A.MWSKZ