FARR_D_INB_COPA

Postponed RAIs - COPA data | #transactional | Component: Revenue Accounting
Column Name Description
CLIENT Client
SRCDOC_COMP Sender Component of Source Item
SRCDOC_LOGSYS Logical System of the Source Item
SRCDOC_TYPE Source Document Item Type
SRCDOC_ID Source Item ID
TIMESTAMP_UTC Timestamp UTC for Revenue Accounting Item
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
COPACRIT_DUMMY Dummy function in length 1 DUMMY
KDPOS Sales Document Item POSNR
COPA_KOSTL Cost center KOSTL
KSTRG Cost Object KSTRG
PRCTR Profit Center PRCTR
PPRCTR Partner Profit Center PRCTR
SOLUTION_ORDER_ID Solution Order ID CRM_OBJECT_ID
SOLUTION_ORDER_ITEM_ID Solution Order Item ID CRMS4_NUMBER_INT
COPA_PRZNR Business Process CO_PRZNR
KMVTNR Sales employee PERNR
SAISJ Season Year FSH_CJAHR
CRMCSTY CRM Cost Element KSTAR
DUMMY_MRKT_SGMNT_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Base Unit
  • FARR_D_INB_COPA.CLIENT == T006.MANDT
  • FARR_D_INB_COPA.ABSMG_ME == T006.MSEHI
Product
  • Product number
  • Client
  • FARR_D_INB_COPA.ARTNR == MARA.MATNR
  • FARR_D_INB_COPA.CLIENT == MARA.MANDT
Generic Article
  • Generic Article
  • Client
  • FARR_D_INB_COPA.ARTNRG == MARA.MATNR
  • FARR_D_INB_COPA.CLIENT == MARA.MANDT
Vol. Rebate Grp
  • Volume rebate group
  • Client
  • FARR_D_INB_COPA.BONUS == TVBO.BONUS
  • FARR_D_INB_COPA.CLIENT == TVBO.MANDT
Industry
  • Industry key
  • Client
  • FARR_D_INB_COPA.BRSCH == T016.BRSCH
  • FARR_D_INB_COPA.CLIENT == T016.MANDT
Company Code
  • FARR_D_INB_COPA.CLIENT == T001.MANDT
  • FARR_D_INB_COPA.BUKRS == T001.BUKRS
Sales District
  • FARR_D_INB_COPA.CLIENT == T171.MANDT
  • FARR_D_INB_COPA.BZIRK == T171.BZIRK
Collection
  • Season Year
  • Season
  • Client
  • Fashion Collection
Billing Type
  • FARR_D_INB_COPA.CLIENT == TVFK.MANDT
  • FARR_D_INB_COPA.FKART == TVFK.FKART
Functional Area
  • FARR_D_INB_COPA.CLIENT == TFKB.MANDT
  • FARR_D_INB_COPA.FKBER == TFKB.FKBER
Business Area
  • FARR_D_INB_COPA.CLIENT == TGSB.MANDT
  • FARR_D_INB_COPA.GSBER == TGSB.GSBER
Customer Group
  • Customer Group
  • Client
  • FARR_D_INB_COPA.KDGRP == T151.KDGRP
  • FARR_D_INB_COPA.CLIENT == T151.MANDT
Brand
  • Brand
  • Client
  • FARR_D_INB_COPA.KMBRND == T2249.KMBRND
  • FARR_D_INB_COPA.CLIENT == T2249.MANDT
Business field
  • FARR_D_INB_COPA.CLIENT == T2248.MANDT
  • FARR_D_INB_COPA.KMCATG == T2248.KMCATG
Destination
  • Destination
  • Client
  • FARR_D_INB_COPA.KMDEST == T2211.KMDEST
  • FARR_D_INB_COPA.CLIENT == T2211.MANDT
CustomerHierarchy01
  • FARR_D_INB_COPA.CLIENT == KNA1.MANDT
  • FARR_D_INB_COPA.KMHI01 == KNA1.KUNNR
CustomerHierarchy02
  • FARR_D_INB_COPA.CLIENT == KNA1.MANDT
  • FARR_D_INB_COPA.KMHI02 == KNA1.KUNNR
CustomerHierarchy03
  • FARR_D_INB_COPA.CLIENT == KNA1.MANDT
  • FARR_D_INB_COPA.KMHI03 == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • FARR_D_INB_COPA.KMKDGR == T151.KDGRP
  • FARR_D_INB_COPA.CLIENT == T151.MANDT
Country
  • Country/Region Key
  • Client
  • FARR_D_INB_COPA.KMLAND == T005.LAND1
  • FARR_D_INB_COPA.CLIENT == T005.MANDT
Material Group
  • FARR_D_INB_COPA.CLIENT == T023.MANDT
  • FARR_D_INB_COPA.KMMAKL == T023.MATKL
Nielsen Indicator
  • FARR_D_INB_COPA.CLIENT == TNLS.MANDT
  • FARR_D_INB_COPA.KMNIEL == TNLS.NIELS
Strategic Business Unit
  • Strategic Business Unit
  • Client
  • FARR_D_INB_COPA.KMSTGE == T2247.KMSTGE
  • FARR_D_INB_COPA.CLIENT == T2247.MANDT
Sales Office
  • Sales office
  • Client
  • FARR_D_INB_COPA.KMVKBU == TVBUR.VKBUR
  • FARR_D_INB_COPA.CLIENT == TVBUR.MANDT
Sales Group
  • FARR_D_INB_COPA.CLIENT == TVKGR.MANDT
  • FARR_D_INB_COPA.KMVKGR == TVKGR.VKGRP
Main Material Group
  • Main Material Group
  • Client
  • FARR_D_INB_COPA.KMWNHG == T2246.KMWNHG
  • FARR_D_INB_COPA.CLIENT == T2246.MANDT
Customer
  • FARR_D_INB_COPA.CLIENT == KNA1.MANDT
  • FARR_D_INB_COPA.KNDNR == KNA1.KUNNR
CO Area
  • FARR_D_INB_COPA.CLIENT == TKA01.MANDT
  • FARR_D_INB_COPA.KOKRS == TKA01.KOKRS
Bill-to party
  • FARR_D_INB_COPA.CLIENT == KNA1.MANDT
  • FARR_D_INB_COPA.KUNRE == KNA1.KUNNR
Ship-to party
  • FARR_D_INB_COPA.CLIENT == KNA1.MANDT
  • FARR_D_INB_COPA.KUNWE == KNA1.KUNNR
Base Unit of Measure
  • FARR_D_INB_COPA.CLIENT == T006.MANDT
  • FARR_D_INB_COPA.KWSVME_ME == T006.MSEHI
Country
  • Country/Region Key
  • Client
  • FARR_D_INB_COPA.LAND1 == T005.LAND1
  • FARR_D_INB_COPA.CLIENT == T005.MANDT
Material Group
  • FARR_D_INB_COPA.CLIENT == T023.MANDT
  • FARR_D_INB_COPA.MATKL == T023.MATKL
Order
  • Order Number
  • Client
  • FARR_D_INB_COPA.RKAUFNR == AUFK.AUFNR
  • FARR_D_INB_COPA.CLIENT == AUFK.MANDT
Season
  • Season Year
  • Season
Segment
Service Document Item ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • FARR_D_INB_COPA.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FARR_D_INB_COPA.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FARR_D_INB_COPA.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FARR_D_INB_COPA.CLIENT == FCO_SRVDOC.MANDT
Service Document Type
Division
  • FARR_D_INB_COPA.CLIENT == TSPA.MANDT
  • FARR_D_INB_COPA.SPART == TSPA.SPART
Sales office
  • Sales office
  • Client
  • FARR_D_INB_COPA.VKBUR == TVBUR.VKBUR
  • FARR_D_INB_COPA.CLIENT == TVBUR.MANDT
Sales group
  • FARR_D_INB_COPA.CLIENT == TVKGR.MANDT
  • FARR_D_INB_COPA.VKGRP == TVKGR.VKGRP
Sales Org.
  • FARR_D_INB_COPA.CLIENT == TVKO.MANDT
  • FARR_D_INB_COPA.VKORG == TVKO.VKORG
Contract
Contract Item
  • Identification of a Provider Contract
  • Contract: Item Number
Distr. Channel
  • Distribution Channel
  • Client
  • FARR_D_INB_COPA.VTWEG == TVTW.VTWEG
  • FARR_D_INB_COPA.CLIENT == TVTW.MANDT
Plant
  • FARR_D_INB_COPA.CLIENT == T001W.MANDT
  • FARR_D_INB_COPA.WERKS == T001W.WERKS