I_PaRealignment

CO-PA Realignment | view: IPAREALGNMT | Extraction: Not supported | Component: Information System

Tables used: SCAL_TT_DATE, ACDOCA_KENC, PRTE, ACDOCA, PROJ, PRPS, FINSC_LEDGER_REP, TKENC5

🔑 Keys (7)
💰 Amounts (3)
∑ Quantities
📅 Dates (3)
☰ Categorical
Other (13)
🔗 Relations (42)

Column Name	Description
SourceLedger FK	Source Ledger
Ledger FK	Ledger in General Ledger Accounting
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
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	Finish date
RealignmentRunEndTime	Finish time
PostingDate	Posting Date

Column Name	Description

Column Name	Description	Domain name
FiscalPeriod	Fiscal Period	POPER
RealgnmtPrevPlant	Plant	WERKS
RealgnmtPrevSalesOrder	Sales Order Number	VBELN
RealgnmtPrevSalesOrderItem	Item number in Sales Order	NUM06
SalesOrderItem	Sales Order Item	POSNR
RealgnmtPrevCustomer	Customer Number	KUNNR
RealgnmtPrevOrderID	Order Number	AUFNR
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV
RealgnmtPrevWBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
RealgnmtPrevCostObject	Cost Object	KSTRG
RealgnmtPrevCostCenter	Cost Center	KOSTL
NmbrOfRealignedJrnlEntryItems	null

Master Data Relations	Join Conditions
Journal Entry Type Journal Entry Type Client	`I_PAREALIGNMENT.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `I_PAREALIGNMENT.MANDT == T003.MANDT`
Balance Transaction Currency Client Balance Transaction Currency	`I_PAREALIGNMENT.MANDT == TCURC.MANDT` `I_PAREALIGNMENT.BALANCETRANSACTIONCURRENCY == TCURC.WAERS`
Billing Type Billing Type Billing Type Client	`I_PAREALIGNMENT.BILLINGDOCUMENTTYPE == TVFK.FKART` `I_PAREALIGNMENT.REALGNMTPREVBILLGDOCTYPE == TVFK.FKART` `I_PAREALIGNMENT.MANDT == TVFK.MANDT`
Bill-to Party Bill-to Party Bill-to Party Client	`I_PAREALIGNMENT.BILLTOPARTY == KNA1.KUNNR` `I_PAREALIGNMENT.REALGNMTPREVBILLTOPARTY == KNA1.KUNNR` `I_PAREALIGNMENT.MANDT == KNA1.MANDT`
Business Transaction Type Business Transaction Type Client	`I_PAREALIGNMENT.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `I_PAREALIGNMENT.MANDT == FINSC_CUSTBTTYPE.MANDT`
Company Code Client Company Code	`I_PAREALIGNMENT.MANDT == T001.MANDT` `I_PAREALIGNMENT.COMPANYCODE == T001.BUKRS`
Company Code Currency Company Code Currency Client	`I_PAREALIGNMENT.COMPANYCODECURRENCY == TCURC.WAERS` `I_PAREALIGNMENT.MANDT == TCURC.MANDT`
Controlling Area Client Controlling Area	`I_PAREALIGNMENT.MANDT == TKA01.MANDT` `I_PAREALIGNMENT.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center ? Client Controlling Area Cost Center Cost Center	`I_PAREALIGNMENT.[column in domain "DATBI"] == CSKS.DATBI` `I_PAREALIGNMENT.MANDT == CSKS.MANDT` `I_PAREALIGNMENT.CONTROLLINGAREA == CSKS.KOKRS` `I_PAREALIGNMENT.REALGNMTPREVCOSTCENTER == CSKS.KOSTL` `I_PAREALIGNMENT.COSTCENTER == CSKS.KOSTL`
Cost Object ? Cost Object Cost Object Client	`I_PAREALIGNMENT.[column in domain "DATBI"] == CKPH.DATBI` `I_PAREALIGNMENT.REALGNMTPREVCOSTOBJECT == CKPH.KSTRG` `I_PAREALIGNMENT.COSTOBJECT == CKPH.KSTRG` `I_PAREALIGNMENT.MANDT == CKPH.MANDT`
Customer Number Customer Number Customer Number Client	`I_PAREALIGNMENT.CUSTOMER == KNA1.KUNNR` `I_PAREALIGNMENT.REALGNMTPREVCUSTOMER == KNA1.KUNNR` `I_PAREALIGNMENT.MANDT == KNA1.MANDT`
Customer Group Customer Group Customer Group Client	`I_PAREALIGNMENT.REALGNMTPREVCUSTOMERGROUP == T151.KDGRP` `I_PAREALIGNMENT.CUSTOMERGROUP == T151.KDGRP` `I_PAREALIGNMENT.MANDT == T151.MANDT`
Customer or Supplier Country/Region Customer or Supplier Country/Region Country/Region Key Client	`I_PAREALIGNMENT.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `I_PAREALIGNMENT.REALGNMTPREVCUSTSUPLRCNTRY == T005.LAND1` `I_PAREALIGNMENT.MANDT == T005.MANDT`
Distribution Channel Client Distribution Channel Distribution Channel	`I_PAREALIGNMENT.MANDT == TVTW.MANDT` `I_PAREALIGNMENT.REALGNMTPREVDISTRCHANNEL == TVTW.VTWEG` `I_PAREALIGNMENT.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Functional Area Functional Area Client	`I_PAREALIGNMENT.FUNCTIONALAREA == TFKB.FKBER` `I_PAREALIGNMENT.MANDT == TFKB.MANDT`
G/L Account G/L Account Client Company Code	`I_PAREALIGNMENT.GLACCOUNT == SKB1.SAKNR` `I_PAREALIGNMENT.MANDT == SKB1.MANDT` `I_PAREALIGNMENT.COMPANYCODE == SKB1.BUKRS`
Global Currency Global Currency Client	`I_PAREALIGNMENT.GLOBALCURRENCY == TCURC.WAERS` `I_PAREALIGNMENT.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting Source Ledger	`I_PAREALIGNMENT.MANDT == FINSC_LEDGER.MANDT` `I_PAREALIGNMENT.LEDGER == FINSC_LEDGER.RLDNR` `I_PAREALIGNMENT.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Product Sold Group Product Sold Group Product Sold Group Client	`I_PAREALIGNMENT.REALGNMTPREVMATERIALGROUP == T023.MATKL` `I_PAREALIGNMENT.MATERIALGROUP == T023.MATKL` `I_PAREALIGNMENT.MANDT == T023.MANDT`
Order ID Order ID Order Number Client	`I_PAREALIGNMENT.ORDERID == AUFK.AUFNR` `I_PAREALIGNMENT.REALGNMTPREVORDERID == AUFK.AUFNR` `I_PAREALIGNMENT.MANDT == AUFK.MANDT`
Division Client Division Division	`I_PAREALIGNMENT.MANDT == TSPA.MANDT` `I_PAREALIGNMENT.ORGANIZATIONDIVISION == TSPA.SPART` `I_PAREALIGNMENT.REALGNMTPREVORGDIVISION == TSPA.SPART`
Plant Plant Plant Client	`I_PAREALIGNMENT.REALGNMTPREVPLANT == T001W.WERKS` `I_PAREALIGNMENT.PLANT == T001W.WERKS` `I_PAREALIGNMENT.MANDT == T001W.MANDT`
Profit Center ? Client Controlling Area Profit Center	`I_PAREALIGNMENT.[column in domain "DATBI"] == CEPC.DATBI` `I_PAREALIGNMENT.MANDT == CEPC.MANDT` `I_PAREALIGNMENT.CONTROLLINGAREA == CEPC.KOKRS` `I_PAREALIGNMENT.PROFITCENTER == CEPC.PRCTR`
Billing Type Billing Type Billing Type Client	`I_PAREALIGNMENT.BILLINGDOCUMENTTYPE == TVFK.FKART` `I_PAREALIGNMENT.REALGNMTPREVBILLGDOCTYPE == TVFK.FKART` `I_PAREALIGNMENT.MANDT == TVFK.MANDT`
Bill-to Party Bill-to Party Bill-to Party Client	`I_PAREALIGNMENT.BILLTOPARTY == KNA1.KUNNR` `I_PAREALIGNMENT.REALGNMTPREVBILLTOPARTY == KNA1.KUNNR` `I_PAREALIGNMENT.MANDT == KNA1.MANDT`
Customer Group Customer Group Customer Group Client	`I_PAREALIGNMENT.REALGNMTPREVCUSTOMERGROUP == T151.KDGRP` `I_PAREALIGNMENT.CUSTOMERGROUP == T151.KDGRP` `I_PAREALIGNMENT.MANDT == T151.MANDT`
Country/Region Key Customer or Supplier Country/Region Country/Region Key Client	`I_PAREALIGNMENT.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `I_PAREALIGNMENT.REALGNMTPREVCUSTSUPLRCNTRY == T005.LAND1` `I_PAREALIGNMENT.MANDT == T005.MANDT`
Distribution Channel Client Distribution Channel Distribution Channel	`I_PAREALIGNMENT.MANDT == TVTW.MANDT` `I_PAREALIGNMENT.REALGNMTPREVDISTRCHANNEL == TVTW.VTWEG` `I_PAREALIGNMENT.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Product Sold Group Product Sold Group Product Sold Group Client	`I_PAREALIGNMENT.REALGNMTPREVMATERIALGROUP == T023.MATKL` `I_PAREALIGNMENT.MATERIALGROUP == T023.MATKL` `I_PAREALIGNMENT.MANDT == T023.MANDT`
Division Client Division Division	`I_PAREALIGNMENT.MANDT == TSPA.MANDT` `I_PAREALIGNMENT.ORGANIZATIONDIVISION == TSPA.SPART` `I_PAREALIGNMENT.REALGNMTPREVORGDIVISION == TSPA.SPART`
Sales District Sales District Sales District Client	`I_PAREALIGNMENT.REALGNMTPREVSALESDISTRICT == T171.BZIRK` `I_PAREALIGNMENT.SALESDISTRICT == T171.BZIRK` `I_PAREALIGNMENT.MANDT == T171.MANDT`
Sales Organization Client Sales Organization Sales Organization	`I_PAREALIGNMENT.MANDT == TVKO.MANDT` `I_PAREALIGNMENT.REALGNMTPREVSALESORGANIZATION == TVKO.VKORG` `I_PAREALIGNMENT.SALESORGANIZATION == TVKO.VKORG`
Ship-to Party Ship-to Party Ship-to Party Client	`I_PAREALIGNMENT.REALGNMTPREVSHIPTOPARTY == KNA1.KUNNR` `I_PAREALIGNMENT.SHIPTOPARTY == KNA1.KUNNR` `I_PAREALIGNMENT.MANDT == KNA1.MANDT`
Product Sold Product Sold Product Sold Client	`I_PAREALIGNMENT.REALGNMTPREVSOLDMATERIAL == MARA.MATNR` `I_PAREALIGNMENT.SOLDMATERIAL == MARA.MATNR` `I_PAREALIGNMENT.MANDT == MARA.MANDT`
Sales District Sales District Sales District Client	`I_PAREALIGNMENT.REALGNMTPREVSALESDISTRICT == T171.BZIRK` `I_PAREALIGNMENT.SALESDISTRICT == T171.BZIRK` `I_PAREALIGNMENT.MANDT == T171.MANDT`
Sales Organization Client Sales Organization Sales Organization	`I_PAREALIGNMENT.MANDT == TVKO.MANDT` `I_PAREALIGNMENT.REALGNMTPREVSALESORGANIZATION == TVKO.VKORG` `I_PAREALIGNMENT.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`I_PAREALIGNMENT.MANDT == FAGL_SEGM.MANDT` `I_PAREALIGNMENT.SEGMENT == FAGL_SEGM.SEGMENT`
Ship-to Party Ship-to Party Ship-to Party Client	`I_PAREALIGNMENT.REALGNMTPREVSHIPTOPARTY == KNA1.KUNNR` `I_PAREALIGNMENT.SHIPTOPARTY == KNA1.KUNNR` `I_PAREALIGNMENT.MANDT == KNA1.MANDT`
Product Sold Product Sold Product Sold Client	`I_PAREALIGNMENT.REALGNMTPREVSOLDMATERIAL == MARA.MATNR` `I_PAREALIGNMENT.SOLDMATERIAL == MARA.MATNR` `I_PAREALIGNMENT.MANDT == MARA.MANDT`
Source Ledger Client Ledger in General Ledger Accounting Source Ledger	`I_PAREALIGNMENT.MANDT == FINSC_LEDGER.MANDT` `I_PAREALIGNMENT.LEDGER == FINSC_LEDGER.RLDNR` `I_PAREALIGNMENT.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Supplier Client Supplier	`I_PAREALIGNMENT.MANDT == LFA1.MANDT` `I_PAREALIGNMENT.SUPPLIER == LFA1.LIFNR`

Other Relations \| to Master Data Relations ↑	Join Conditions
Realignment run Realignment run Client ?	`I_PAREALIGNMENT.REALIGNMENTRUN == TKENC1.CHGRUN` `I_PAREALIGNMENT.MANDT == TKENC1.MANDT` `I_PAREALIGNMENT.[column in domain "ERKRS"] == TKENC1.ERKRS`