Arberp_V_Int_Ord_View

Fieldglass: Relevant Cost Centers | view: ARBERP_V_INT_ORD | Extraction: Not supported | Component: Ariba Integration with S/4HANA Financial Accounting
Tables used: JEST, AUFK
Column Name Description
Column Name Description
Column Name Description
Column Name Description
erdat Created On
aedat Change Date for Order Master
stdat Date of Last Status Change
pdat1 Planned release date
pdat2 Planned completion date
pdat3 Planned closing date
idat1 Release Date
idat2 Technical Completion Date
idat3 Close Date
Column Name Description
autyp Order category Show values
ltext Long Text Exists Show values
astkz Identifier for Statistical Order Show values
phas0 Phase "Order Created" Show values
phas1 Phase "Order Released" Show values
phas2 Phase "Order Completed" Show values
phas3 Phase "Order Closed" Show values
loekz Deletion Flag Show values
plgkz Identifier for Planning with Line Items Show values
scope Object Class Show values
plint Indicator for Integrated Planning Show values
Column Name Description Domain name
aufnr Order Number AUFNR
ernam Entered By USNAM
aenam Last Changed By USNAM
ktext Description TEXT40
cckey Cost Collector Key CCKEY
astnr Order Status AUFSTNR
objid Object ID CHAR1
zschl Overhead key CHAR6
kdauf Sales Order Number VBELN
kdpos Item number in Sales Order NUM06
aufex External order number AUFEX
Master Data Relations Join Conditions
Results Analysis Key
  • Results Analysis Key
  • Client
  • ARBERP_V_INT_ORD_VIEW.ABGSL == TKKAA.ABGSL
  • ARBERP_V_INT_ORD_VIEW.MANDT == TKKAA.MANDT
Order Type
  • Order Type
  • Client
  • ARBERP_V_INT_ORD_VIEW.AUART == T003O.AUART
  • ARBERP_V_INT_ORD_VIEW.MANDT == T003O.CLIENT
Variance Key
  • Variance Key
  • ?
  • Client
  • ARBERP_V_INT_ORD_VIEW.AWSLS == TKV01.AWSLS
  • ARBERP_V_INT_ORD_VIEW.[column in domain "AWOBA"] == TKV01.AWOBA
  • ARBERP_V_INT_ORD_VIEW.MANDT == TKV01.MANDT
Company Code
  • Company Code
  • Client
  • ARBERP_V_INT_ORD_VIEW.BUKRS == T001.BUKRS
  • ARBERP_V_INT_ORD_VIEW.MANDT == T001.MANDT
Status Reached so Far
  • Order Type
  • Client
  • Status Reached so Far
  • ARBERP_V_INT_ORD_VIEW.AUART == TKO03.ART
  • ARBERP_V_INT_ORD_VIEW.MANDT == TKO03.CLIENT
  • ARBERP_V_INT_ORD_VIEW.ESTNR == TKO03.ASTNR
Functional Area
  • Functional Area
  • Client
  • ARBERP_V_INT_ORD_VIEW.FUNC_AREA == TFKB.FKBER
  • ARBERP_V_INT_ORD_VIEW.MANDT == TFKB.MANDT
Business Area
  • Business Area
  • Client
  • ARBERP_V_INT_ORD_VIEW.GSBER == TGSB.GSBER
  • ARBERP_V_INT_ORD_VIEW.MANDT == TGSB.MANDT
Investment Measure Profile
  • Investment Measure Profile
  • Client
  • ARBERP_V_INT_ORD_VIEW.IVPRO == TAPRF.IVPRO
  • ARBERP_V_INT_ORD_VIEW.MANDT == TAPRF.MANDT
Costing Sheet
  • ?
  • ?
  • Client
  • Costing Sheet
  • ARBERP_V_INT_ORD_VIEW.[column in domain "KAPPL"] == T683.KAPPL
  • ARBERP_V_INT_ORD_VIEW.[column in domain "KVEWE"] == T683.KVEWE
  • ARBERP_V_INT_ORD_VIEW.MANDT == T683.MANDT
  • ARBERP_V_INT_ORD_VIEW.KALSM == T683.KALSM
Controlling Area
  • Controlling Area
  • Client
  • ARBERP_V_INT_ORD_VIEW.KOKRS == TKA01.KOKRS
  • ARBERP_V_INT_ORD_VIEW.MANDT == TKA01.MANDT
Responsible cost center
  • Controlling Area
  • Client
  • ?
  • Responsible cost center
  • ARBERP_V_INT_ORD_VIEW.KOKRS == CSKS.KOKRS
  • ARBERP_V_INT_ORD_VIEW.MANDT == CSKS.MANDT
  • ARBERP_V_INT_ORD_VIEW.[column in domain "DATBI"] == CSKS.DATBI
  • ARBERP_V_INT_ORD_VIEW.KOSTV == CSKS.KOSTL
Logical System ARBERP_V_INT_ORD_VIEW.LOGSYSTEM == TBDLS.LOGSYS
Profit Center
  • Controlling Area
  • Profit Center
  • Client
  • ?
  • ARBERP_V_INT_ORD_VIEW.KOKRS == CEPC.KOKRS
  • ARBERP_V_INT_ORD_VIEW.PRCTR == CEPC.PRCTR
  • ARBERP_V_INT_ORD_VIEW.MANDT == CEPC.MANDT
  • ARBERP_V_INT_ORD_VIEW.[column in domain "DATBI"] == CEPC.DATBI
Reference Order Number
  • Client
  • Reference Order Number
  • ARBERP_V_INT_ORD_VIEW.MANDT == AUFK.MANDT
  • ARBERP_V_INT_ORD_VIEW.REFNR == AUFK.AUFNR
Location Plant
  • Client
  • Location Plant
  • ARBERP_V_INT_ORD_VIEW.MANDT == T001W.MANDT
  • ARBERP_V_INT_ORD_VIEW.SOWRK == T001W.WERKS
Location
  • Location
  • Client
  • Location Plant
  • ARBERP_V_INT_ORD_VIEW.STORT == T499S.STAND
  • ARBERP_V_INT_ORD_VIEW.MANDT == T499S.MANDT
  • ARBERP_V_INT_ORD_VIEW.SOWRK == T499S.WERKS
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • ARBERP_V_INT_ORD_VIEW.MANDT == TTXJ.MANDT
  • ARBERP_V_INT_ORD_VIEW.TXJCD == TTXJ.TXJCD
  • ARBERP_V_INT_ORD_VIEW.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Order Currency
  • Client
  • Order Currency
  • ARBERP_V_INT_ORD_VIEW.MANDT == TCURC.MANDT
  • ARBERP_V_INT_ORD_VIEW.WAERS == TCURC.WAERS
Plant
  • Plant
  • Client
  • ARBERP_V_INT_ORD_VIEW.WERKS == T001W.WERKS
  • ARBERP_V_INT_ORD_VIEW.MANDT == T001W.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Group of Disallowed Transactions
  • Object ID
  • Client
  • Group of Disallowed Transactions
  • ?
  • ARBERP_V_INT_ORD_VIEW.OBJID == TKAVG.OBJID
  • ARBERP_V_INT_ORD_VIEW.MANDT == TKAVG.MANDT
  • ARBERP_V_INT_ORD_VIEW.VOGRP == TKAVG.GRUPPE
  • ARBERP_V_INT_ORD_VIEW.[column in domain "ACTI1"] == TKAVG.ACTIVITY