Fins_Plan_Delscope_Cds

View for delete scope | view: FINSPLANDELSCOPE | TRAN | Extraction: Not supported | Component: Planning
Tables used: FINS_PLAN_DELSC
Column Name Description
uuid UUID
pos null
Column Name Description
💲 Freely Defined Currency 3 (rbcur):
bsl Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (rccur):
csl Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (rdcur):
dsl Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (recur):
esl Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (rfcur):
fsl Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (rgcur):
gsl Amount in Freely Defined Currency 8
hprice Price in Company Code Currency
kprice Price in Global Currency
wprice Price in Transaction Currency
💲 Company Code Currency (rhcur):
hsl Amount in Company Code Currency
💲 Global Currency (rkcur):
ksl Amount in Global Currency
💲 Freely Defined Currency 1 (rocur):
osl Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (rvcur):
vsl Amount in Freely Defined Currency 2
💲 Transaction Currency (rwcur):
wsl Amount in Transaction Currency
Column Name Description
📏 Unit of Measure for Valuation Quantity (rvunit):
vmsl Valuation quantity
Column Name Description
Column Name Description
co_belkz CO Debit/Credit Indicator Show values
Column Name Description Domain name
aworg Reference Organizational Units AWORG
awref Reference document number AWREF
awtyp Reference procedure AWTYP
createdat UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
fiscyearper Period/Year JAHRPER
kdauf Sales Order Number VBELN
kdpos Item number in Sales Order NUM06
konzs Group key KONZS
periv Fiscal Year Variant PERIV
pernr Personnel Number PERNR
poper Posting period POPER
pps_posid Partner Work Breakdown Structure Element PS_POSID
pps_pspid Partner Project PS_PSPID
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
ps_psp_pnr Work Breakdown Structure Element (WBS Element) PS_POSNR
ps_pspid Project definition PS_PSPID
racct Account Number SAKNR
rbukrs Company Code BUKRS
rldnr Ledger in General Ledger Accounting FINS_LEDGER
ryear General Ledger Fiscal Year GJAHR
usnam User Name XUBNAME
work_item_id Work Item ID /CPD/PFP_WORKITEM_ID
Master Data Relations Join Conditions
Industry key
  • Industry key
  • Client
  • FINS_PLAN_DELSCOPE_CDS.BRSCH == T016.BRSCH
  • FINS_PLAN_DELSCOPE_CDS.MANDT == T016.MANDT
Sales District
  • Client
  • Sales District
  • FINS_PLAN_DELSCOPE_CDS.MANDT == T171.MANDT
  • FINS_PLAN_DELSCOPE_CDS.BZIRK == T171.BZIRK
Plan Category
  • Plan Category
  • Client
Billing Type
  • Billing Type
  • Client
  • FINS_PLAN_DELSCOPE_CDS.FKART == TVFK.FKART
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TVFK.MANDT
Customer Group
  • Customer Group
  • Client
  • FINS_PLAN_DELSCOPE_CDS.KDGRP == T151.KDGRP
  • FINS_PLAN_DELSCOPE_CDS.MANDT == T151.MANDT
Controlling Area
  • Controlling Area
  • Client
  • FINS_PLAN_DELSCOPE_CDS.KOKRS == TKA01.KOKRS
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TKA01.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • FINS_PLAN_DELSCOPE_CDS.MANDT == T004.MANDT
  • FINS_PLAN_DELSCOPE_CDS.KTOPL == T004.KTOPL
Customer Number
  • Customer Number
  • Client
  • FINS_PLAN_DELSCOPE_CDS.KUNNR == KNA1.KUNNR
  • FINS_PLAN_DELSCOPE_CDS.MANDT == KNA1.MANDT
Bill-to Party
  • Client
  • Bill-to Party
  • FINS_PLAN_DELSCOPE_CDS.MANDT == KNA1.MANDT
  • FINS_PLAN_DELSCOPE_CDS.KUNRE == KNA1.KUNNR
Ship-to Party
  • Ship-to Party
  • Client
  • FINS_PLAN_DELSCOPE_CDS.KUNWE == KNA1.KUNNR
  • FINS_PLAN_DELSCOPE_CDS.MANDT == KNA1.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • FINS_PLAN_DELSCOPE_CDS.LAND1 == T005.LAND1
  • FINS_PLAN_DELSCOPE_CDS.MANDT == T005.MANDT
Product Sold Group
  • Client
  • Product Sold Group
  • FINS_PLAN_DELSCOPE_CDS.MANDT == T023.MANDT
  • FINS_PLAN_DELSCOPE_CDS.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • FINS_PLAN_DELSCOPE_CDS.MATNR == MARA.MATNR
  • FINS_PLAN_DELSCOPE_CDS.MANDT == MARA.MANDT
Product Sold
  • Product Sold
  • Client
  • FINS_PLAN_DELSCOPE_CDS.MATNR_COPA == MARA.MATNR
  • FINS_PLAN_DELSCOPE_CDS.MANDT == MARA.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • Partner Profit Center
  • FINS_PLAN_DELSCOPE_CDS.[column in domain "DATBI"] == CEPC.DATBI
  • FINS_PLAN_DELSCOPE_CDS.KOKRS == CEPC.KOKRS
  • FINS_PLAN_DELSCOPE_CDS.MANDT == CEPC.MANDT
  • FINS_PLAN_DELSCOPE_CDS.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • FINS_PLAN_DELSCOPE_CDS.[column in domain "DATBI"] == CEPC.DATBI
  • FINS_PLAN_DELSCOPE_CDS.KOKRS == CEPC.KOKRS
  • FINS_PLAN_DELSCOPE_CDS.MANDT == CEPC.MANDT
  • FINS_PLAN_DELSCOPE_CDS.PRCTR == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • FINS_PLAN_DELSCOPE_CDS.PSEGMENT == FAGL_SEGM.SEGMENT
  • FINS_PLAN_DELSCOPE_CDS.MANDT == FAGL_SEGM.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FINS_PLAN_DELSCOPE_CDS.MANDT == T880.MANDT
  • FINS_PLAN_DELSCOPE_CDS.RASSC == T880.RCOMP
Business Area
  • Client
  • Business Area
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TGSB.MANDT
  • FINS_PLAN_DELSCOPE_CDS.RBUSA == TGSB.GSBER
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • FINS_PLAN_DELSCOPE_CDS.[column in domain "DATBI"] == CSKS.DATBI
  • FINS_PLAN_DELSCOPE_CDS.KOKRS == CSKS.KOKRS
  • FINS_PLAN_DELSCOPE_CDS.MANDT == CSKS.MANDT
  • FINS_PLAN_DELSCOPE_CDS.RCNTR == CSKS.KOSTL
Functional Area
  • Client
  • Functional Area
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TFKB.MANDT
  • FINS_PLAN_DELSCOPE_CDS.RFAREA == TFKB.FKBER
Trading partner's business area
  • Trading partner's business area
  • Client
  • FINS_PLAN_DELSCOPE_CDS.SBUSA == TGSB.GSBER
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TGSB.MANDT
Sender cost center
  • ?
  • Controlling Area
  • Client
  • Sender cost center
  • FINS_PLAN_DELSCOPE_CDS.[column in domain "DATBI"] == CSKS.DATBI
  • FINS_PLAN_DELSCOPE_CDS.KOKRS == CSKS.KOKRS
  • FINS_PLAN_DELSCOPE_CDS.MANDT == CSKS.MANDT
  • FINS_PLAN_DELSCOPE_CDS.SCNTR == CSKS.KOSTL
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • FINS_PLAN_DELSCOPE_CDS.SEGMENT == FAGL_SEGM.SEGMENT
  • FINS_PLAN_DELSCOPE_CDS.MANDT == FAGL_SEGM.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • FINS_PLAN_DELSCOPE_CDS.SFAREA == TFKB.FKBER
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TFKB.MANDT
Division
  • Division
  • Client
  • FINS_PLAN_DELSCOPE_CDS.SPART == TSPA.SPART
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TSPA.MANDT
Sales Organization
  • Client
  • Sales Organization
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TVKO.MANDT
  • FINS_PLAN_DELSCOPE_CDS.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • FINS_PLAN_DELSCOPE_CDS.MANDT == TVTW.MANDT
  • FINS_PLAN_DELSCOPE_CDS.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • FINS_PLAN_DELSCOPE_CDS.MANDT == T001W.MANDT
  • FINS_PLAN_DELSCOPE_CDS.WERKS == T001W.WERKS