P_Copa_Doc2

P_COPA_DOC2 | view: PFICOPADOC2 | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, FINSC_LD_CMP, FINSC_LEDGER_REP
Column Name Description
Column Name Description
💲 Transaction Currency (TWAER):
WTGBTR Amount in Transaction Currency
💲 Currency Key (OWAER):
WOGBTR Value in CO Object Currency
💲 Controlling area currency (KWAER):
WKGBTR Total Value in Controlling Area Currency
WKFBTR Fixed Value in Controlling Area Currency
PAGBTR Total Price Variance in CO Area Currency
PAFBTR Fixed Price Variance in Controlling Area Currency
Column Name Description
📏 Unit of Measure (MEINH):
MEGBTR Total Quantity
MEFBTR Fixed quantity
📏 Unit of entry (MEINB):
MBGBTR Total quantity entered
MBFBTR Fixed quantity entered
📏 Additional Unit of Measure 1 (qunit1):
quant1 Additional Quantity 1
📏 Additional Unit of Measure 2 (qunit2):
quant2 Additional Quantity 2
📏 Additional Unit of Measure 3 (qunit3):
quant3 Additional Quantity 3
Column Name Description
DABRZ Reference Date for Settlement
prodper Production Month (Date to find period and year)
bldat Journal Entry Date
budat Posting Date
augdt Clearing Date
bzdat Asset Value Date
Column Name Description
WRTTP Value Type Show values
BEKNZ CO Debit/Credit Indicator Show values
MVFLG Quantity Completion Show values
gkoar Account Type Show values
rbest Category of Reference Purchase Order Show values
erlkz Indicator: Line Item is Completed Show values
beltp Debit Type Show values
scope Object Class Show values
pscope Partner object class Show values
bwstrat Strategy for Determining an Allocation Price Show values
AUTYP Order category Show values
pautyp Partner Order Category Show values
LEDNR Ledger for Controlling Objects Show values
drcrk Debit/Credit Code Show values
koart Account Type Show values
rhoart Type of Origin Object Show values
AUTYP_ORI Order category Show values
xopvw Managed on an Open Item Basis Show values
co_belkz CO Debit/Credit Indicator Show values
kzbws Inventory Special Stock Valuation Type Show values
xobew Vendor Stock Valuation Indicator Show values
glaccount_type Type of a General Ledger Account Show values
xreversing Indicator: Item is Reversing Another Item Show values
xreversed Indicator: Item is Reversed Show values
xtruerev Indicator: True reversal (i.e. cancellation) Show values
parobsrc Source of PAROB: PAROB1 or type of partner object Show values
rrcty Record Type Show values
bstat Journal Entry Category Show values
UNUSED_CE3 Flag: NOT Posted to Costing-Based Profitability Analysis Show values
KNT_FRM_KZ Indicator for use in account-based Profitability Analysis Show values
Column Name Description Domain name
BELNR Document Number CO_BELNR
BUZEI Posting Row BUZEI
PERIO Fiscal Period POPER
PAROB Partner Object J_OBJNR
sgtxt Item Text TEXT50
refbz Reference Document Line Item NUMC6
ZLENR Document Item Number NUM3
BW_REFBZ Posting Row in Operative Version BUZEI
gkont Offsetting Account GKONT
zekkn Sequential Number of Account Assignment NUM02
pernr Personnel Number PERNR
BTRKL Amount Class for Value in Controlling Area Currency NUMC2
paobjnr Profitability Segment Number (CO-PA) RKEOBJNR
PKSTAR Cost element of partner KSTAR
GRANT_NBR Grant GM_GRANT_NBR
PGRANT_NBR Partner Grant GM_GRANT_NBR
REFBZ_FI Journal Entry Posting View Item BUZEI
POSNR Accounting Document Line Item Number POSNR_ACC
AWKEY Object key AWKEY
accas Account Assignment ACCAS
KOSTL Cost Center KOSTL
LSTAR Activity Type LSTAR
AUFNR Order ID AUFNR
PS_PSP_PNR WBS Element PS_POSNR
PSPNR Work Breakdown Structure Element (WBS Element) PS_POSID
PSPID Project definition PS_PSPID
VBELN Sales and Distribution Document Number VBELN
VBPOSNR Sales Document Item POSNR
CE4KEY Assignment Object Key for CO-PA Data Basis (CE4xxxx) RKEOBJNR
work_item_id Work Item ID /CPD/PFP_WORKITEM_ID
paccas Partner Account Assignment ACCAS
PPSPNR Partner WBS Element PS_POSID
PPSPID Partner Project PS_PSPID
PCE4KEY Partner Assignment Object Key for CO-PA Data Basis (CE4xxxx) RKEOBJNR
gjahr Fiscal Year GJAHR
BELNR_FI Journal Entry BELNR
docln Ledger Journal Entry Item DOCLN6
ryear Ledger Fiscal Year GJAHR
aworg Reference Document Context AWORG
awref Reference document number AWREF
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
rebzg Invoice Reference BELNR
rebzj Invoice Reference Fiscal Year GJAHR
rebzz Invoice Item Reference BUZEI
rebzt Follow-On Document Type REBZT
augbl Clearing Journal Entry BELNR
auggj Fiscal Year of Clearing Journal Entry GJAHR
fiscyearper Fiscal Year Period FIS_JAHRPER_CONV
ktosl Transaction Key CHAR3
zuonr Assignment Reference ZUONR
kalnr Cost Estimate CK_KALNR
sobkz Inventory Special Stock Type SOBKZ
mat_kdauf Sales Document Number of Valuated Special Inventory VBELN
mat_kdpos Sales Document Item Number of Valuated Special Inventory POSNR
mat_lifnr Supplier of Inventory Special Stock LIFNR
kdpos Sales Order Item POSNR
mat_ps_posid WBS Element (external) of Valuated Special Inventory PS_POSID
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
ps_pspid Project definition PS_PSPID
awitem Reference Document Line Item NUMC6
awitgrp Group of Reference Document Line Items NUMC6
racct_sender Sender G/L Account CHAR10
accas_sender Account Assignment in Sender System ACCAS
aworg_rev Reversal: Reference Organizations of Document to Be Reversed AWORG
awref_rev Reversal: Reference Document No. of Document to Be Reversed AWREF
ppaobjnr Partner profitability segment number (CO-PA) RKEOBJNR
vorgn Transaction Type for General Ledger VORGN
cpudt null
cputm null
AKTBO Current profitability segment (CO-PA) CHAR1
PASUBNR Profitability Segment Changes (CO-PA) RKESUBNR
BRSCH Industry key BRSCH
BZIRK Sales District BZIRK
KMVKBU Sales office VKBUR
KMVTNR Sales Employee PERNR
VKGRP Sales group VKGRP
KMWNHG Main Material Group RKESKMWNHG
Master Data Relations Join Conditions
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • P_COPA_DOC2.ANBWA == TABW.BWASL
  • P_COPA_DOC2.MANDT == TABW.MANDT
Group Asset Subnumber
  • Group Asset
  • ?
  • Group Asset Subnumber
  • Client
  • P_COPA_DOC2.ANLGR == ANLA.ANLN1
  • P_COPA_DOC2.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_COPA_DOC2.ANLGR2 == ANLA.ANLN2
  • P_COPA_DOC2.MANDT == ANLA.MANDT
Asset Subnumber
  • Asset Subnumber
  • ?
  • Fixed Asset
  • Client
  • P_COPA_DOC2.ANLN2 == ANLA.ANLN2
  • P_COPA_DOC2.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_COPA_DOC2.ANLN1 == ANLA.ANLN1
  • P_COPA_DOC2.MANDT == ANLA.MANDT
Product Sold
  • Product Sold
  • Client
  • P_COPA_DOC2.ARTNR == MARA.MATNR
  • P_COPA_DOC2.MANDT == MARA.MANDT
Order ID
  • Order ID
  • Client
  • P_COPA_DOC2.AUFNR_ORI == AUFK.AUFNR
  • P_COPA_DOC2.MANDT == AUFK.MANDT
Logical System of Reference Document P_COPA_DOC2.AWSYS == TBDLS.LOGSYS
Reference Document Type P_COPA_DOC2.AWTYP == TTYP.AWTYP
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_COPA_DOC2.BLART == T003.BLART
  • P_COPA_DOC2.MANDT == T003.MANDT
Posting Key
  • Posting Key
  • Client
  • P_COPA_DOC2.BSCHL == TBSL.BSCHL
  • P_COPA_DOC2.MANDT == TBSL.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
Budget Period
  • ?
  • Fund
  • Budget Period
  • Client
Company Code
  • Company Code
  • Client
  • P_COPA_DOC2.BUKRS == T001.BUKRS
  • P_COPA_DOC2.MANDT == T001.MANDT
Valuation area
  • Valuation area
  • Client
  • P_COPA_DOC2.BWKEY == T001K.BWKEY
  • P_COPA_DOC2.MANDT == T001K.MANDT
Valuation Type
  • Valuation Type
  • Client
  • P_COPA_DOC2.BWTAR == T149D.BWTAR
  • P_COPA_DOC2.MANDT == T149D.MANDT
Partner profit center for elimination of internal business
  • ?
  • Partner profit center for elimination of internal business
  • Controlling Area
  • Client
  • P_COPA_DOC2.[column in domain "DATBI"] == CEPC.DATBI
  • P_COPA_DOC2.EPRCTR == CEPC.PRCTR
  • P_COPA_DOC2.KOKRS == CEPC.KOKRS
  • P_COPA_DOC2.MANDT == CEPC.MANDT
Operating concern
  • Operating concern
  • Client
  • P_COPA_DOC2.ERKRS == TKEB.ERKRS
  • P_COPA_DOC2.MANDT == TKEB.MANDT
Billing Type
  • Billing Type
  • Client
  • P_COPA_DOC2.FKART == TVFK.FKART
  • P_COPA_DOC2.MANDT == TVFK.MANDT
Functional Area
  • Functional Area
  • Client
  • P_COPA_DOC2.FKBER == TFKB.FKBER
  • P_COPA_DOC2.MANDT == TFKB.MANDT
Fund
  • ?
  • Fund
  • Client
Business Area
  • Business Area
  • Client
  • P_COPA_DOC2.GSBER == TGSB.GSBER
  • P_COPA_DOC2.MANDT == TGSB.MANDT
House Bank Key
  • House Bank Key
  • ?
  • Client
  • P_COPA_DOC2.HBKID == T012.HBKID
  • P_COPA_DOC2.[column in domain "BUKRS"] == T012.BUKRS
  • P_COPA_DOC2.MANDT == T012.MANDT
Origin Group as Subdivision of Cost Element
  • ?
  • Origin Group as Subdivision of Cost Element
  • Controlling Area
  • Client
  • P_COPA_DOC2.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_COPA_DOC2.HKGRP == TKKH1.HRKFT
  • P_COPA_DOC2.KOKRS == TKKH1.KOKRS
  • P_COPA_DOC2.MANDT == TKKH1.MANDT
House Bank Account
  • House Bank Key
  • House Bank Account
  • ?
  • Client
  • P_COPA_DOC2.HBKID == T012K.HBKID
  • P_COPA_DOC2.HKTID == T012K.HKTID
  • P_COPA_DOC2.[column in domain "BUKRS"] == T012K.BUKRS
  • P_COPA_DOC2.MANDT == T012K.MANDT
CO key subnumber
  • CO key subnumber
  • Client
  • P_COPA_DOC2.HRKFT == COKEY.HRKFT
  • P_COPA_DOC2.MANDT == COKEY.MANDT
Customer Group
  • Customer Group
  • Client
  • P_COPA_DOC2.KDGRP == T151.KDGRP
  • P_COPA_DOC2.MANDT == T151.MANDT
Customer Number
  • Customer Number
  • Client
  • P_COPA_DOC2.KNDNR == KNA1.KUNNR
  • P_COPA_DOC2.MANDT == KNA1.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_COPA_DOC2.KOKRS == TKA01.KOKRS
  • P_COPA_DOC2.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC2.KOSTL_ORI == CSKS.KOSTL
  • P_COPA_DOC2.[column in domain "DATBI"] == CSKS.DATBI
  • P_COPA_DOC2.KOKRS == CSKS.KOKRS
  • P_COPA_DOC2.MANDT == CSKS.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_COPA_DOC2.KSTAR == SKB1.SAKNR
  • P_COPA_DOC2.BUKRS == SKB1.BUKRS
  • P_COPA_DOC2.MANDT == SKB1.MANDT
Cost Object
  • Cost Object
  • ?
  • Client
  • P_COPA_DOC2.KSTRG == CKPH.KSTRG
  • P_COPA_DOC2.[column in domain "DATBI"] == CKPH.DATBI
  • P_COPA_DOC2.MANDT == CKPH.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_COPA_DOC2.KTOP2 == T004.KTOPL
  • P_COPA_DOC2.MANDT == T004.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_COPA_DOC2.KTOPL == T004.KTOPL
  • P_COPA_DOC2.MANDT == T004.MANDT
Controlling area currency
  • Client
  • Controlling area currency
  • P_COPA_DOC2.MANDT == TCURC.MANDT
  • P_COPA_DOC2.KWAER == TCURC.WAERS
Supplier
  • Supplier
  • Client
  • P_COPA_DOC2.LIFNR == LFA1.LIFNR
  • P_COPA_DOC2.MANDT == LFA1.MANDT
Logical System P_COPA_DOC2.LOGSYSO == TBDLS.LOGSYS
Partner Logical System P_COPA_DOC2.LOGSYSP == TBDLS.LOGSYS
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • Client
  • P_COPA_DOC2.KTOP2 == SKA1.KTOPL
  • P_COPA_DOC2.LOKKT == SKA1.SAKNR
  • P_COPA_DOC2.MANDT == SKA1.MANDT
Activity Type
  • ?
  • Activity Type
  • Controlling Area
  • Client
  • P_COPA_DOC2.[column in domain "DATBI"] == CSLA.DATBI
  • P_COPA_DOC2.LSTAR_ORI == CSLA.LSTAR
  • P_COPA_DOC2.KOKRS == CSLA.KOKRS
  • P_COPA_DOC2.MANDT == CSLA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • P_COPA_DOC2.MATKL == T023.MATKL
  • P_COPA_DOC2.MANDT == T023.MANDT
Material Number
  • Material Number
  • Client
  • P_COPA_DOC2.MATNR == MARA.MATNR
  • P_COPA_DOC2.MANDT == MARA.MANDT
Unit of entry
  • Unit of entry
  • Client
  • P_COPA_DOC2.MEINB == T006.MSEHI
  • P_COPA_DOC2.MANDT == T006.MANDT
Unit of Measure
  • Client
  • Unit of Measure
  • P_COPA_DOC2.MANDT == T006.MANDT
  • P_COPA_DOC2.MEINH == T006.MSEHI
Transaction Type Category P_COPA_DOC2.MOVCAT == FAAI_MOVCAT.MOVCAT
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • ?
  • Client
  • P_COPA_DOC2.MWSKZ == T007A.MWSKZ
  • P_COPA_DOC2.[column in domain "KALSM_D"] == T007A.KALSM
  • P_COPA_DOC2.MANDT == T007A.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • P_COPA_DOC2.PARGB == TGSB.GSBER
  • P_COPA_DOC2.MANDT == TGSB.MANDT
Partner Order
  • Partner Order
  • Client
  • P_COPA_DOC2.PAUFNR == AUFK.AUFNR
  • P_COPA_DOC2.MANDT == AUFK.MANDT
FM: Partner Budget Period
  • ?
  • Partner Fund
  • FM: Partner Budget Period
  • Client
  • P_COPA_DOC2.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • P_COPA_DOC2.PGEBER == FMFUNDBPD.FINCODE
  • P_COPA_DOC2.PBUDGET_PD == FMFUNDBPD.BUDGET_PD
  • P_COPA_DOC2.MANDT == FMFUNDBPD.MANDT
Company Code of Partner
  • Company Code of Partner
  • Client
  • P_COPA_DOC2.PBUKRS == T001.BUKRS
  • P_COPA_DOC2.MANDT == T001.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_COPA_DOC2.PERIV == T009.PERIV
  • P_COPA_DOC2.MANDT == T009.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_COPA_DOC2.PFKBER == TFKB.FKBER
  • P_COPA_DOC2.MANDT == TFKB.MANDT
Partner Fund
  • ?
  • Partner Fund
  • Client
  • P_COPA_DOC2.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_COPA_DOC2.PGEBER == FMFINCODE.FINCODE
  • P_COPA_DOC2.MANDT == FMFINCODE.MANDT
Partner Cost Center
  • Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC2.PKOSTL == CSKS.KOSTL
  • P_COPA_DOC2.[column in domain "DATBI"] == CSKS.DATBI
  • P_COPA_DOC2.KOKRS == CSKS.KOKRS
  • P_COPA_DOC2.MANDT == CSKS.MANDT
Partner Cost Object
  • Partner Cost Object
  • ?
  • Client
  • P_COPA_DOC2.PKSTRG == CKPH.KSTRG
  • P_COPA_DOC2.[column in domain "DATBI"] == CKPH.DATBI
  • P_COPA_DOC2.MANDT == CKPH.MANDT
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC2.PLSTAR == CSLA.LSTAR
  • P_COPA_DOC2.[column in domain "DATBI"] == CSLA.DATBI
  • P_COPA_DOC2.KOKRS == CSLA.KOKRS
  • P_COPA_DOC2.MANDT == CSLA.MANDT
Partner Profit Center
  • ?
  • Partner Profit Center
  • Controlling Area
  • Client
  • P_COPA_DOC2.[column in domain "DATBI"] == CEPC.DATBI
  • P_COPA_DOC2.PPRCT == CEPC.PRCTR
  • P_COPA_DOC2.KOKRS == CEPC.KOKRS
  • P_COPA_DOC2.MANDT == CEPC.MANDT
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • P_COPA_DOC2.[column in domain "DATBI"] == CEPC.DATBI
  • P_COPA_DOC2.PRCTR == CEPC.PRCTR
  • P_COPA_DOC2.KOKRS == CEPC.KOKRS
  • P_COPA_DOC2.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
Additional Unit of Measure 1
  • Additional Unit of Measure 1
  • Client
  • P_COPA_DOC2.QUNIT1 == T006.MSEHI
  • P_COPA_DOC2.MANDT == T006.MANDT
Additional Unit of Measure 2
  • Additional Unit of Measure 2
  • Client
  • P_COPA_DOC2.QUNIT2 == T006.MSEHI
  • P_COPA_DOC2.MANDT == T006.MANDT
Additional Unit of Measure 3
  • Additional Unit of Measure 3
  • Client
  • P_COPA_DOC2.QUNIT3 == T006.MSEHI
  • P_COPA_DOC2.MANDT == T006.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_COPA_DOC2.RMVCT == T856.TRTYP
  • P_COPA_DOC2.MANDT == T856.MANDT
Cost Analysis Resource
  • ?
  • Controlling Area
  • Client
  • Cost Analysis Resource
  • P_COPA_DOC2.[column in domain "DATBI"] == CSKR.DATBI
  • P_COPA_DOC2.KOKRS == CSKR.KOKRS
  • P_COPA_DOC2.MANDT == CSKR.MANDT
  • P_COPA_DOC2.RSRCE == CSKR.RESRC
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Subledger-Specific Line Item Type P_COPA_DOC2.SLALITTYPE == FINSTS_SLALITTY.SLALITTYPE
Division
  • Division
  • Client
  • P_COPA_DOC2.SPART == TSPA.SPART
  • P_COPA_DOC2.MANDT == TSPA.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_COPA_DOC2.TWAER == TCURC.WAERS
  • P_COPA_DOC2.MANDT == TCURC.MANDT
Origin cost center
  • ?
  • Origin cost center
  • Controlling Area
  • Client
  • P_COPA_DOC2.[column in domain "DATBI"] == CSKS.DATBI
  • P_COPA_DOC2.UKOSTL == CSKS.KOSTL
  • P_COPA_DOC2.KOKRS == CSKS.KOKRS
  • P_COPA_DOC2.MANDT == CSKS.MANDT
Activity Type of the Origin Cost Center
  • ?
  • Activity Type of the Origin Cost Center
  • Controlling Area
  • Client
  • P_COPA_DOC2.[column in domain "DATBI"] == CSLA.DATBI
  • P_COPA_DOC2.ULSTAR == CSLA.LSTAR
  • P_COPA_DOC2.KOKRS == CSLA.KOKRS
  • P_COPA_DOC2.MANDT == CSLA.MANDT
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • P_COPA_DOC2.KOART == T074U.KOART
  • P_COPA_DOC2.UMSKZ == T074U.UMSKZ
  • P_COPA_DOC2.MANDT == T074U.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_COPA_DOC2.VBUND == T880.RCOMP
  • P_COPA_DOC2.MANDT == T880.MANDT
Sales Organization
  • Client
  • Sales Organization
  • P_COPA_DOC2.MANDT == TVKO.MANDT
  • P_COPA_DOC2.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • P_COPA_DOC2.MANDT == TVTW.MANDT
  • P_COPA_DOC2.VTWEG == TVTW.VTWEG
Plant
  • Plant
  • Client
  • P_COPA_DOC2.WERKS == T001W.WERKS
  • P_COPA_DOC2.MANDT == T001W.MANDT