C_PaRealignment

CO-PA Realignment Results | view: CPAREALGNMT | TEXT | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, ACDOCA_KENC, PRTE, ACDOCA, T003, KNA1, SKB1, PROJ, LFA1, PRPS, FINSC_LEDGER_REP, TKENC5
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
CompanyCode FK Company Code
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
RealignmentRun FK Realignment run
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
Column Name Description
RealignmentRunEndDate Realignment Date
RealignmentRunEndTime Realignment time
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
RealignmentRunEndYear Realignment Year
RealignmentRunEndMonth Realignment Month
FiscalPeriod Fiscal Period POPER
RealgnmtPrevPlant Previous Plant WERKS
RealgnmtPrevSalesOrder Previous Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
RealgnmtPrevSalesOrderItem Previous Sales Order Item NUM06
RealgnmtPrevCustomer Previous Customer Number KUNNR
RealgnmtPrevOrderID Previous Internal Order AUFNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
RealgnmtPrevWBSElement Previous Work Breakdown Structure Element (WBS Element) PS_POSID
RealgnmtPrevCostObject Previous Cost Object KSTRG
RealgnmtPrevCostCenter Previous Cost Center KOSTL
NmbrOfRealignedJrnlEntryItems Realigned Journal Entry Items FINS_JE_COUNTER
GLAccountAuthorizationGroup Authorization Group BRGRU
SupplierBasicAuthorizationGrp Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
AcctgDocTypeAuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_PAREALIGNMENT.MANDT == T003.MANDT
  • C_PAREALIGNMENT.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_PAREALIGNMENT.MANDT == TCURC.MANDT
  • C_PAREALIGNMENT.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Billing Type
  • Billing Type
  • Previous Billing Type
  • Client
  • C_PAREALIGNMENT.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_PAREALIGNMENT.REALGNMTPREVBILLGDOCTYPE == TVFK.FKART
  • C_PAREALIGNMENT.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Previous Bill-To Party
  • Client
  • C_PAREALIGNMENT.BILLTOPARTY == KNA1.KUNNR
  • C_PAREALIGNMENT.REALGNMTPREVBILLTOPARTY == KNA1.KUNNR
  • C_PAREALIGNMENT.MANDT == KNA1.MANDT
Business Transaction Type
  • Client
  • Business Transaction Type
Company Code
  • Client
  • Company Code
  • C_PAREALIGNMENT.MANDT == T001.MANDT
  • C_PAREALIGNMENT.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_PAREALIGNMENT.MANDT == TCURC.MANDT
  • C_PAREALIGNMENT.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_PAREALIGNMENT.MANDT == TKA01.MANDT
  • C_PAREALIGNMENT.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Cost Center
  • Previous Cost Center
  • Controlling Area
  • C_PAREALIGNMENT.MANDT == CSKS.MANDT
  • C_PAREALIGNMENT.[column in domain "DATBI"] == CSKS.DATBI
  • C_PAREALIGNMENT.COSTCENTER == CSKS.KOSTL
  • C_PAREALIGNMENT.REALGNMTPREVCOSTCENTER == CSKS.KOSTL
  • C_PAREALIGNMENT.CONTROLLINGAREA == CSKS.KOKRS
Cost Object
  • Client
  • ?
  • Previous Cost Object
  • Cost Object
  • C_PAREALIGNMENT.MANDT == CKPH.MANDT
  • C_PAREALIGNMENT.[column in domain "DATBI"] == CKPH.DATBI
  • C_PAREALIGNMENT.REALGNMTPREVCOSTOBJECT == CKPH.KSTRG
  • C_PAREALIGNMENT.COSTOBJECT == CKPH.KSTRG
Customer Number
  • Client
  • Previous Customer Number
  • Customer Number
  • C_PAREALIGNMENT.MANDT == KNA1.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVCUSTOMER == KNA1.KUNNR
  • C_PAREALIGNMENT.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • Previous Customer Group
  • C_PAREALIGNMENT.MANDT == T151.MANDT
  • C_PAREALIGNMENT.CUSTOMERGROUP == T151.KDGRP
  • C_PAREALIGNMENT.REALGNMTPREVCUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Client
  • Customer or Supplier Country/Region
  • Previous Country/Region Key
  • C_PAREALIGNMENT.MANDT == T005.MANDT
  • C_PAREALIGNMENT.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • C_PAREALIGNMENT.REALGNMTPREVCUSTSUPLRCNTRY == T005.LAND1
Distribution Channel
  • Client
  • Distribution Channel
  • Previous Distribution Channel
  • C_PAREALIGNMENT.MANDT == TVTW.MANDT
  • C_PAREALIGNMENT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_PAREALIGNMENT.REALGNMTPREVDISTRCHANNEL == TVTW.VTWEG
Functional Area
  • Client
  • Functional Area
  • C_PAREALIGNMENT.MANDT == TFKB.MANDT
  • C_PAREALIGNMENT.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_PAREALIGNMENT.MANDT == SKB1.MANDT
  • C_PAREALIGNMENT.GLACCOUNT == SKB1.SAKNR
  • C_PAREALIGNMENT.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_PAREALIGNMENT.MANDT == TCURC.MANDT
  • C_PAREALIGNMENT.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Product Sold Group
  • Client
  • Product Sold Group
  • Previous Product Sold Group
  • C_PAREALIGNMENT.MANDT == T023.MANDT
  • C_PAREALIGNMENT.MATERIALGROUP == T023.MATKL
  • C_PAREALIGNMENT.REALGNMTPREVMATERIALGROUP == T023.MATKL
Internal Order
  • Client
  • Internal Order
  • Previous Internal Order
  • C_PAREALIGNMENT.MANDT == AUFK.MANDT
  • C_PAREALIGNMENT.ORDERID == AUFK.AUFNR
  • C_PAREALIGNMENT.REALGNMTPREVORDERID == AUFK.AUFNR
Division
  • Client
  • Previous Division
  • Division
  • C_PAREALIGNMENT.MANDT == TSPA.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVORGDIVISION == TSPA.SPART
  • C_PAREALIGNMENT.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • Previous Plant
  • C_PAREALIGNMENT.MANDT == T001W.MANDT
  • C_PAREALIGNMENT.PLANT == T001W.WERKS
  • C_PAREALIGNMENT.REALGNMTPREVPLANT == T001W.WERKS
Profit Center
  • Client
  • ?
  • Profit Center
  • Controlling Area
  • C_PAREALIGNMENT.MANDT == CEPC.MANDT
  • C_PAREALIGNMENT.[column in domain "DATBI"] == CEPC.DATBI
  • C_PAREALIGNMENT.PROFITCENTER == CEPC.PRCTR
  • C_PAREALIGNMENT.CONTROLLINGAREA == CEPC.KOKRS
Previous Billing Type
  • Billing Type
  • Previous Billing Type
  • Client
  • C_PAREALIGNMENT.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_PAREALIGNMENT.REALGNMTPREVBILLGDOCTYPE == TVFK.FKART
  • C_PAREALIGNMENT.MANDT == TVFK.MANDT
Previous Bill-To Party
  • Bill-to Party
  • Previous Bill-To Party
  • Client
  • C_PAREALIGNMENT.BILLTOPARTY == KNA1.KUNNR
  • C_PAREALIGNMENT.REALGNMTPREVBILLTOPARTY == KNA1.KUNNR
  • C_PAREALIGNMENT.MANDT == KNA1.MANDT
Previous Customer Group
  • Client
  • Customer Group
  • Previous Customer Group
  • C_PAREALIGNMENT.MANDT == T151.MANDT
  • C_PAREALIGNMENT.CUSTOMERGROUP == T151.KDGRP
  • C_PAREALIGNMENT.REALGNMTPREVCUSTOMERGROUP == T151.KDGRP
Previous Country/Region Key
  • Client
  • Customer or Supplier Country/Region
  • Previous Country/Region Key
  • C_PAREALIGNMENT.MANDT == T005.MANDT
  • C_PAREALIGNMENT.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • C_PAREALIGNMENT.REALGNMTPREVCUSTSUPLRCNTRY == T005.LAND1
Previous Distribution Channel
  • Client
  • Distribution Channel
  • Previous Distribution Channel
  • C_PAREALIGNMENT.MANDT == TVTW.MANDT
  • C_PAREALIGNMENT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_PAREALIGNMENT.REALGNMTPREVDISTRCHANNEL == TVTW.VTWEG
Previous Product Sold Group
  • Client
  • Product Sold Group
  • Previous Product Sold Group
  • C_PAREALIGNMENT.MANDT == T023.MANDT
  • C_PAREALIGNMENT.MATERIALGROUP == T023.MATKL
  • C_PAREALIGNMENT.REALGNMTPREVMATERIALGROUP == T023.MATKL
Previous Division
  • Client
  • Previous Division
  • Division
  • C_PAREALIGNMENT.MANDT == TSPA.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVORGDIVISION == TSPA.SPART
  • C_PAREALIGNMENT.ORGANIZATIONDIVISION == TSPA.SPART
Previous Sales District
  • Client
  • Sales District
  • Previous Sales District
  • C_PAREALIGNMENT.MANDT == T171.MANDT
  • C_PAREALIGNMENT.SALESDISTRICT == T171.BZIRK
  • C_PAREALIGNMENT.REALGNMTPREVSALESDISTRICT == T171.BZIRK
Previous Sales Organization
  • Client
  • Previous Sales Organization
  • Sales Organization
  • C_PAREALIGNMENT.MANDT == TVKO.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVSALESORGANIZATION == TVKO.VKORG
  • C_PAREALIGNMENT.SALESORGANIZATION == TVKO.VKORG
Previous Ship-To Party
  • Client
  • Previous Ship-To Party
  • Ship-to Party
  • C_PAREALIGNMENT.MANDT == KNA1.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVSHIPTOPARTY == KNA1.KUNNR
  • C_PAREALIGNMENT.SHIPTOPARTY == KNA1.KUNNR
Previous Product Sold
  • Client
  • Previous Product Sold
  • Product Sold
  • C_PAREALIGNMENT.MANDT == MARA.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVSOLDMATERIAL == MARA.MATNR
  • C_PAREALIGNMENT.SOLDMATERIAL == MARA.MATNR
Sales District
  • Client
  • Sales District
  • Previous Sales District
  • C_PAREALIGNMENT.MANDT == T171.MANDT
  • C_PAREALIGNMENT.SALESDISTRICT == T171.BZIRK
  • C_PAREALIGNMENT.REALGNMTPREVSALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Previous Sales Organization
  • Sales Organization
  • C_PAREALIGNMENT.MANDT == TVKO.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVSALESORGANIZATION == TVKO.VKORG
  • C_PAREALIGNMENT.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Ship-to Party
  • Client
  • Previous Ship-To Party
  • Ship-to Party
  • C_PAREALIGNMENT.MANDT == KNA1.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVSHIPTOPARTY == KNA1.KUNNR
  • C_PAREALIGNMENT.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Client
  • Previous Product Sold
  • Product Sold
  • C_PAREALIGNMENT.MANDT == MARA.MANDT
  • C_PAREALIGNMENT.REALGNMTPREVSOLDMATERIAL == MARA.MATNR
  • C_PAREALIGNMENT.SOLDMATERIAL == MARA.MATNR
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Client
  • Supplier
  • C_PAREALIGNMENT.MANDT == LFA1.MANDT
  • C_PAREALIGNMENT.SUPPLIER == LFA1.LIFNR
Other Relations | to Master Data Relations ↑ Join Conditions
Realignment run
  • Client
  • Realignment run
  • ?
  • C_PAREALIGNMENT.MANDT == TKENC1.MANDT
  • C_PAREALIGNMENT.REALIGNMENTRUN == TKENC1.CHGRUN
  • C_PAREALIGNMENT.[column in domain "ERKRS"] == TKENC1.ERKRS