P_Copa_Doc1

P_COPA_DOC1 | view: PFICOPADOC1 | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, FINSC_LD_CMP, FINSC_LEDGER_REP
Column Name Description
Column Name Description
💲 Balance Transaction Currency (rtcur):
tsl Amount in Balance Transaction Currency
💲 Company Code Currency (rhcur):
hsl Amount in Company Code Currency
💲 Global Currency (KWAER):
WKGBTR Amount in Global Currency
WKFBTR Fixed Amount in Global Currency
PAGBTR Total Price Variance in Global Currency
PAFBTR Fixed Price Variance in Global Currency
💲 Freely Defined Currency 1 (rocur):
osl Amount in Freely Defined Currency 1
💲 Transaction Currency (TWAER):
WTGBTR Amount in Transaction Currency
💲 CO Object Currency (rco_ocur):
co_osl Amount in CO Object Currency
WOGBTR Amount in CO Object Currency
Column Name Description
📏 Base Unit of Measure (MEINB):
MBGBTR Quantity
MBFBTR Fixed quantity
📏 Cost Source Unit (MEINH):
MEGBTR Valuation quantity
MEFBTR Fixed valuation quantity
📏 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
budat Posting Date
augdt Clearing Date
bzdat Asset Value Date
bldat Journal Entry Date
dabrz Reference Date for Settlement
prodper Production Month (Date to find period and year)
Column Name Description
drcrk Debit/Credit Code Show values
koart Account Type Show values
rhoart Type of Origin Object Show values
rbest Category of Reference Purchase Order Show values
beltp Debit Type Show values
gkoar Offsetting Account Type Show values
erlkz Indicator: Line Item is Completed Show values
scope Object Class Show values
pscope Partner object class Show values
AUTYP_ORI Order category Show values
pautyp Partner 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
bwstrat Strategy for Determining an Allocation Price Show values
MVFLG Indicator: Quantity Is Incomplete Show values
bstat Journal Entry Category Show values
BEKNZ CO Debit/Credit Indicator Show values
Column Name Description Domain name
BELNR Document Number CO_BELNR
BUZEI Posting Row BUZEI
LEDNR null
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
PERIO Fiscal Period POPER
REFBZ_FI Journal Entry Posting View Item BUZEI
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
zekkn Sequential Number of Account Assignment NUM02
sgtxt Item Text TEXT50
augbl Clearing Journal Entry BELNR
auggj Fiscal Year of Clearing Journal Entry GJAHR
gkont Offsetting Account GKONT
pernr Personnel Number PERNR
accas Account Assignment ACCAS
paccas Partner Account Assignment ACCAS
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_psp_pnr WBS Element PS_POSNR
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
ps_pspid Project definition PS_PSPID
PPSPNR Partner WBS Element PS_POSID
PPSPID Partner Project 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
co_belnr Document Number CO_BELNR
co_buzei Posting Row BUZEI
work_item_id Work Item ID /CPD/PFP_WORKITEM_ID
paobjnr Profitability Segment Number (CO-PA) RKEOBJNR
ppaobjnr Partner profitability segment number (CO-PA) RKEOBJNR
vorgn Transaction Type for General Ledger VORGN
KOSTL Cost Center KOSTL
LSTAR Activity Type LSTAR
AUFNR Order ID AUFNR
AUTYP null
PSPNR Work Breakdown Structure Element (WBS Element) PS_POSID
PSPID Project definition PS_PSPID
VBELN Sales Order VBELN
VBPOSNR null
refbz Reference Document Line Item NUMC6
ZLENR null
POSNR null
AWKEY null
CE4KEY null
PCE4KEY null
PAROB null
BW_REFBZ Posting Row BUZEI
BTRKL null
GRANT_NBR Grant GM_GRANT_NBR
PGRANT_NBR Partner Grant GM_GRANT_NBR
HANA_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WRTTP null
PKSTAR null
AKTBO null
PASUBNR null
UNUSED_CE3 null
CE4_BRSCH null
CE4_BZIRK null
CE4_KMVKBU null
CE4_KMVTNR null
CE4_VKGRP null
CE4_KMWNHG null
CE4_KNT_FRM_KZ null
Master Data Relations Join Conditions
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • P_COPA_DOC1.ANBWA == TABW.BWASL
  • P_COPA_DOC1.MANDT == TABW.MANDT
Group Asset Subnumber
  • Group Asset Subnumber
  • ?
  • Group Asset
  • Client
  • P_COPA_DOC1.ANLGR2 == ANLA.ANLN2
  • P_COPA_DOC1.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_COPA_DOC1.ANLGR == ANLA.ANLN1
  • P_COPA_DOC1.MANDT == ANLA.MANDT
Asset Subnumber
  • Fixed Asset
  • Asset Subnumber
  • ?
  • Client
  • P_COPA_DOC1.ANLN1 == ANLA.ANLN1
  • P_COPA_DOC1.ANLN2 == ANLA.ANLN2
  • P_COPA_DOC1.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_COPA_DOC1.MANDT == ANLA.MANDT
Product Sold
  • Product Sold
  • Client
  • P_COPA_DOC1.ARTNR == MARA.MATNR
  • P_COPA_DOC1.MANDT == MARA.MANDT
Order ID
  • Order ID
  • Client
  • P_COPA_DOC1.AUFNR_ORI == AUFK.AUFNR
  • P_COPA_DOC1.MANDT == AUFK.MANDT
Logical System P_COPA_DOC1.AWSYS == TBDLS.LOGSYS
Reference Document Type P_COPA_DOC1.AWTYP == TTYP.AWTYP
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_COPA_DOC1.BLART == T003.BLART
  • P_COPA_DOC1.MANDT == T003.MANDT
Posting Key
  • Posting Key
  • Client
  • P_COPA_DOC1.BSCHL == TBSL.BSCHL
  • P_COPA_DOC1.MANDT == TBSL.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
Budget Period
  • Fund
  • ?
  • Budget Period
  • Client
Company Code
  • Company Code
  • Client
  • P_COPA_DOC1.BUKRS == T001.BUKRS
  • P_COPA_DOC1.MANDT == T001.MANDT
Valuation area
  • Valuation area
  • Client
  • P_COPA_DOC1.BWKEY == T001K.BWKEY
  • P_COPA_DOC1.MANDT == T001K.MANDT
Valuation Type
  • Valuation Type
  • Client
  • P_COPA_DOC1.BWTAR == T149D.BWTAR
  • P_COPA_DOC1.MANDT == T149D.MANDT
Partner profit center for elimination of internal business
  • ?
  • Partner profit center for elimination of internal business
  • Controlling Area
  • Client
  • P_COPA_DOC1.[column in domain "DATBI"] == CEPC.DATBI
  • P_COPA_DOC1.EPRCTR == CEPC.PRCTR
  • P_COPA_DOC1.KOKRS == CEPC.KOKRS
  • P_COPA_DOC1.MANDT == CEPC.MANDT
Operating concern
  • Operating concern
  • Client
  • P_COPA_DOC1.ERKRS == TKEB.ERKRS
  • P_COPA_DOC1.MANDT == TKEB.MANDT
Billing Type
  • Billing Type
  • Client
  • P_COPA_DOC1.FKART == TVFK.FKART
  • P_COPA_DOC1.MANDT == TVFK.MANDT
Functional Area
  • Functional Area
  • Client
  • P_COPA_DOC1.FKBER == TFKB.FKBER
  • P_COPA_DOC1.MANDT == TFKB.MANDT
Fund
  • Fund
  • ?
  • Client
Business Area
  • Business Area
  • Client
  • P_COPA_DOC1.GSBER == TGSB.GSBER
  • P_COPA_DOC1.MANDT == TGSB.MANDT
House Bank Key
  • House Bank Key
  • ?
  • Client
  • P_COPA_DOC1.HBKID == T012.HBKID
  • P_COPA_DOC1.[column in domain "BUKRS"] == T012.BUKRS
  • P_COPA_DOC1.MANDT == T012.MANDT
Origin Group as Subdivision of Cost Element
  • ?
  • Controlling Area
  • Origin Group as Subdivision of Cost Element
  • Client
  • P_COPA_DOC1.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_COPA_DOC1.KOKRS == TKKH1.KOKRS
  • P_COPA_DOC1.HKGRP == TKKH1.HRKFT
  • P_COPA_DOC1.MANDT == TKKH1.MANDT
House Bank Account
  • House Bank Key
  • House Bank Account
  • ?
  • Client
  • P_COPA_DOC1.HBKID == T012K.HBKID
  • P_COPA_DOC1.HKTID == T012K.HKTID
  • P_COPA_DOC1.[column in domain "BUKRS"] == T012K.BUKRS
  • P_COPA_DOC1.MANDT == T012K.MANDT
CO key subnumber
  • CO key subnumber
  • Client
  • P_COPA_DOC1.HRKFT == COKEY.HRKFT
  • P_COPA_DOC1.MANDT == COKEY.MANDT
Customer Group
  • Customer Group
  • Client
  • P_COPA_DOC1.KDGRP == T151.KDGRP
  • P_COPA_DOC1.MANDT == T151.MANDT
Customer Number
  • Customer Number
  • Client
  • P_COPA_DOC1.KNDNR == KNA1.KUNNR
  • P_COPA_DOC1.MANDT == KNA1.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_COPA_DOC1.KOKRS == TKA01.KOKRS
  • P_COPA_DOC1.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC1.KOSTL_ORI == CSKS.KOSTL
  • P_COPA_DOC1.[column in domain "DATBI"] == CSKS.DATBI
  • P_COPA_DOC1.KOKRS == CSKS.KOKRS
  • P_COPA_DOC1.MANDT == CSKS.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_COPA_DOC1.KSTAR == SKB1.SAKNR
  • P_COPA_DOC1.BUKRS == SKB1.BUKRS
  • P_COPA_DOC1.MANDT == SKB1.MANDT
Cost Object
  • ?
  • Cost Object
  • Client
  • P_COPA_DOC1.[column in domain "DATBI"] == CKPH.DATBI
  • P_COPA_DOC1.KSTRG == CKPH.KSTRG
  • P_COPA_DOC1.MANDT == CKPH.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_COPA_DOC1.KTOP2 == T004.KTOPL
  • P_COPA_DOC1.MANDT == T004.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_COPA_DOC1.KTOPL == T004.KTOPL
  • P_COPA_DOC1.MANDT == T004.MANDT
Global Currency
  • Global Currency
  • Client
  • P_COPA_DOC1.KWAER == TCURC.WAERS
  • P_COPA_DOC1.MANDT == TCURC.MANDT
Supplier
  • Supplier
  • Client
  • P_COPA_DOC1.LIFNR == LFA1.LIFNR
  • P_COPA_DOC1.MANDT == LFA1.MANDT
Logical System of Object P_COPA_DOC1.LOGSYSO == TBDLS.LOGSYS
Logical system of partner object P_COPA_DOC1.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_DOC1.KTOP2 == SKA1.KTOPL
  • P_COPA_DOC1.LOKKT == SKA1.SAKNR
  • P_COPA_DOC1.MANDT == SKA1.MANDT
Activity Type
  • Activity Type
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC1.LSTAR_ORI == CSLA.LSTAR
  • P_COPA_DOC1.[column in domain "DATBI"] == CSLA.DATBI
  • P_COPA_DOC1.KOKRS == CSLA.KOKRS
  • P_COPA_DOC1.MANDT == CSLA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • P_COPA_DOC1.MATKL == T023.MATKL
  • P_COPA_DOC1.MANDT == T023.MANDT
Material Number
  • Material Number
  • Client
  • P_COPA_DOC1.MATNR == MARA.MATNR
  • P_COPA_DOC1.MANDT == MARA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_COPA_DOC1.MEINB == T006.MSEHI
  • P_COPA_DOC1.MANDT == T006.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • P_COPA_DOC1.MEINH == T006.MSEHI
  • P_COPA_DOC1.MANDT == T006.MANDT
Transaction Type Category P_COPA_DOC1.MOVCAT == FAAI_MOVCAT.MOVCAT
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • ?
  • Client
  • P_COPA_DOC1.MWSKZ == T007A.MWSKZ
  • P_COPA_DOC1.[column in domain "KALSM_D"] == T007A.KALSM
  • P_COPA_DOC1.MANDT == T007A.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • P_COPA_DOC1.PARGB == TGSB.GSBER
  • P_COPA_DOC1.MANDT == TGSB.MANDT
Partner Order
  • Partner Order
  • Client
  • P_COPA_DOC1.PAUFNR == AUFK.AUFNR
  • P_COPA_DOC1.MANDT == AUFK.MANDT
FM: Partner Budget Period
  • Partner Fund
  • ?
  • Client
  • FM: Partner Budget Period
  • P_COPA_DOC1.PGEBER == FMFUNDBPD.FINCODE
  • P_COPA_DOC1.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • P_COPA_DOC1.MANDT == FMFUNDBPD.MANDT
  • P_COPA_DOC1.PBUDGET_PD == FMFUNDBPD.BUDGET_PD
Company Code of Partner
  • Company Code of Partner
  • Client
  • P_COPA_DOC1.PBUKRS == T001.BUKRS
  • P_COPA_DOC1.MANDT == T001.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_COPA_DOC1.PERIV == T009.PERIV
  • P_COPA_DOC1.MANDT == T009.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_COPA_DOC1.PFKBER == TFKB.FKBER
  • P_COPA_DOC1.MANDT == TFKB.MANDT
Partner Fund
  • Partner Fund
  • ?
  • Client
  • P_COPA_DOC1.PGEBER == FMFINCODE.FINCODE
  • P_COPA_DOC1.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_COPA_DOC1.MANDT == FMFINCODE.MANDT
Partner Cost Center
  • Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC1.PKOSTL == CSKS.KOSTL
  • P_COPA_DOC1.[column in domain "DATBI"] == CSKS.DATBI
  • P_COPA_DOC1.KOKRS == CSKS.KOKRS
  • P_COPA_DOC1.MANDT == CSKS.MANDT
Partner Cost Object
  • Partner Cost Object
  • ?
  • Client
  • P_COPA_DOC1.PKSTRG == CKPH.KSTRG
  • P_COPA_DOC1.[column in domain "DATBI"] == CKPH.DATBI
  • P_COPA_DOC1.MANDT == CKPH.MANDT
Partner Cost Center Activity Type
  • ?
  • Controlling Area
  • Partner Cost Center Activity Type
  • Client
  • P_COPA_DOC1.[column in domain "DATBI"] == CSLA.DATBI
  • P_COPA_DOC1.KOKRS == CSLA.KOKRS
  • P_COPA_DOC1.PLSTAR == CSLA.LSTAR
  • P_COPA_DOC1.MANDT == CSLA.MANDT
Partner Profit Center
  • Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC1.PPRCT == CEPC.PRCTR
  • P_COPA_DOC1.[column in domain "DATBI"] == CEPC.DATBI
  • P_COPA_DOC1.KOKRS == CEPC.KOKRS
  • P_COPA_DOC1.MANDT == CEPC.MANDT
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC1.PRCTR == CEPC.PRCTR
  • P_COPA_DOC1.[column in domain "DATBI"] == CEPC.DATBI
  • P_COPA_DOC1.KOKRS == CEPC.KOKRS
  • P_COPA_DOC1.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_DOC1.QUNIT1 == T006.MSEHI
  • P_COPA_DOC1.MANDT == T006.MANDT
Additional Unit of Measure 2
  • Additional Unit of Measure 2
  • Client
  • P_COPA_DOC1.QUNIT2 == T006.MSEHI
  • P_COPA_DOC1.MANDT == T006.MANDT
Additional Unit of Measure 3
  • Additional Unit of Measure 3
  • Client
  • P_COPA_DOC1.QUNIT3 == T006.MSEHI
  • P_COPA_DOC1.MANDT == T006.MANDT
CO Object Currency
  • CO Object Currency
  • Client
  • P_COPA_DOC1.RCO_OCUR == TCURC.WAERS
  • P_COPA_DOC1.MANDT == TCURC.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_COPA_DOC1.RHCUR == TCURC.WAERS
  • P_COPA_DOC1.MANDT == TCURC.MANDT
Ledger
  • Client
  • Source Ledger
  • Ledger
Source Ledger
  • Source Ledger
  • Ledger
  • Client
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_COPA_DOC1.RMVCT == T856.TRTYP
  • P_COPA_DOC1.MANDT == T856.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_COPA_DOC1.MANDT == TCURC.MANDT
  • P_COPA_DOC1.ROCUR == TCURC.WAERS
Cost Analysis Resource
  • Cost Analysis Resource
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC1.RSRCE == CSKR.RESRC
  • P_COPA_DOC1.[column in domain "DATBI"] == CSKR.DATBI
  • P_COPA_DOC1.KOKRS == CSKR.KOKRS
  • P_COPA_DOC1.MANDT == CSKR.MANDT
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_COPA_DOC1.RTCUR == TCURC.WAERS
  • P_COPA_DOC1.MANDT == TCURC.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Subledger-Specific Line Item Type P_COPA_DOC1.SLALITTYPE == FINSTS_SLALITTY.SLALITTYPE
Division
  • Division
  • Client
  • P_COPA_DOC1.SPART == TSPA.SPART
  • P_COPA_DOC1.MANDT == TSPA.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_COPA_DOC1.TWAER == TCURC.WAERS
  • P_COPA_DOC1.MANDT == TCURC.MANDT
Origin cost center
  • ?
  • Controlling Area
  • Client
  • Origin cost center
  • P_COPA_DOC1.[column in domain "DATBI"] == CSKS.DATBI
  • P_COPA_DOC1.KOKRS == CSKS.KOKRS
  • P_COPA_DOC1.MANDT == CSKS.MANDT
  • P_COPA_DOC1.UKOSTL == CSKS.KOSTL
Activity Type of the Origin Cost Center
  • Activity Type of the Origin Cost Center
  • ?
  • Controlling Area
  • Client
  • P_COPA_DOC1.ULSTAR == CSLA.LSTAR
  • P_COPA_DOC1.[column in domain "DATBI"] == CSLA.DATBI
  • P_COPA_DOC1.KOKRS == CSLA.KOKRS
  • P_COPA_DOC1.MANDT == CSLA.MANDT
Special G/L Indicator
  • Special G/L Indicator
  • Account Type
  • Client
  • P_COPA_DOC1.UMSKZ == T074U.UMSKZ
  • P_COPA_DOC1.KOART == T074U.KOART
  • P_COPA_DOC1.MANDT == T074U.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_COPA_DOC1.VBUND == T880.RCOMP
  • P_COPA_DOC1.MANDT == T880.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_COPA_DOC1.VKORG == TVKO.VKORG
  • P_COPA_DOC1.MANDT == TVKO.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_COPA_DOC1.VTWEG == TVTW.VTWEG
  • P_COPA_DOC1.MANDT == TVTW.MANDT
Plant
  • Plant
  • Client
  • P_COPA_DOC1.WERKS == T001W.WERKS
  • P_COPA_DOC1.MANDT == T001W.MANDT