FINS_PLAN_PREV

Table for delete scope | #fiori | Component: Planning
Column Name Description
MANDT Client
UUID UUID
POS null
Column Name Description
💲 Transaction Currency (RWCUR):
WSL Amount in Transaction Currency
WPRICE Price in Transaction Currency
💲 Company Code Currency (RHCUR):
HSL Amount in Company Code Currency
HPRICE Price in Company Code Currency
💲 Global Currency (RKCUR):
KSL Amount in Global Currency
KPRICE Price 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
💲 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
Column Name Description
📏 Unit of Measure for Valuation Quantity (RVUNIT):
VMSL Valuation quantity
SCRAP_QTY Scrap Quantity
COMP_SCRAP_QTY Component Scrap Quantity
📏 Lot Size Unit of Measure (ACDOCP.LSUNIT):
LOSGR Lot Size for Product Costing
Column Name Description
BUDAT Posting Date in the Document
COSTG_FROM_DATE Costing Date From
COSTG_TO_DATE Costing Date To
Column Name Description
CO_BELKZ CO Debit/Credit Indicator Show values
PSKNZ Is Lot Size Independent Show values
ASSL_SCRAP_INCLD Assembly/Operation Scrap Included Show values
ESOKZ Purchasing info record category Show values
TYPPS Item Category Show values
STRAT Valuation Strategy used for Costing Item Show values
Column Name Description Domain name
RYEAR General Ledger Fiscal Year GJAHR
RLDNR Ledger in General Ledger Accounting FINS_LEDGER
RACCT Account Number SAKNR
RBUKRS Company Code BUKRS
AWTYP Reference procedure AWTYP
USNAM User Name XUBNAME
CREATEDAT UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
AWORG Reference Organizational Units AWORG
AWREF Reference document number AWREF
POPER Posting period POPER
PERIV Fiscal Year Variant PERIV
FISCYEARPER Period/Year JAHRPER
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
SGTXT Item Text TEXT50
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
PS_PSPID Project definition PS_PSPID
PERNR Personnel Number PERNR
PPS_POSID Partner Work Breakdown Structure Element PS_POSID
PPS_PSPID Partner Project PS_PSPID
WORK_ITEM_ID Work Item ID /CPD/PFP_WORKITEM_ID
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
PPS_PSP_PNR Partner Work Breakdown Structure Element (internal ID) PS_POSNR
ACDOC_EEW_DUMMY Custom Fields: Dummy for Use in Extension Includes
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes
KONZS Group key KONZS
ACDOC_COPA_EEW_DUMMY_PA Dummy function in length 1 DUMMY
SAISJ_PA Season Year FSH_CJAHR
CRMCSTY_PA CRM Cost Element KSTAR
KMVTNR_PA Sales employee PERNR
DUMMY_MRKT_SGMNT_EEW_PS Custom Fields: Dummy for Use in Extension Includes
FISCYEARPER8 External view fiscal year period
ASSL_SCRAP_PCT Assembly scrap in percent DEC3_2
SCRAP_FACTOR Scrap Factor DEC3_3
Master Data Relations Join Conditions
Generic Article
  • Generic Article
  • Client
  • FINS_PLAN_PREV.ARTNRG_PA == MARA.MATNR
  • FINS_PLAN_PREV.MANDT == MARA.MANDT
Activity Number
  • FINS_PLAN_PREV.MANDT == ASMD.MANDT
  • FINS_PLAN_PREV.ASNUM == ASMD.ASNUM
Vol. Rebate Grp
  • Volume rebate group
  • Client
  • FINS_PLAN_PREV.BONUS_PA == TVBO.BONUS
  • FINS_PLAN_PREV.MANDT == TVBO.MANDT
Industry key
  • Industry key
  • Client
  • FINS_PLAN_PREV.BRSCH == T016.BRSCH
  • FINS_PLAN_PREV.MANDT == T016.MANDT
Business Transaction Category
Sales District
  • FINS_PLAN_PREV.MANDT == T171.MANDT
  • FINS_PLAN_PREV.BZIRK == T171.BZIRK
Plan Category
Collection
  • Season Year
  • Season
  • Client
  • Fashion Collection
Purchasing organization
  • FINS_PLAN_PREV.MANDT == T024E.MANDT
  • FINS_PLAN_PREV.EKORG == T024E.EKORG
Billing Type
  • FINS_PLAN_PREV.MANDT == TVFK.MANDT
  • FINS_PLAN_PREV.FKART == TVFK.FKART
Origin Group as Subdivision of Cost Element
  • Origin Group as Subdivision of Cost Element
  • Client
  • Controlling Area
  • ?
  • FINS_PLAN_PREV.HKGRP == TKKH1.HRKFT
  • FINS_PLAN_PREV.MANDT == TKKH1.MANDT
  • FINS_PLAN_PREV.KOKRS == TKKH1.KOKRS
  • FINS_PLAN_PREV.[column in domain "HRKTYP"] == TKKH1.KOATY
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • FINS_PLAN_PREV.INFNR == EINA.INFNR
  • FINS_PLAN_PREV.MANDT == EINA.MANDT
Customer Group
  • Customer Group
  • Client
  • FINS_PLAN_PREV.KDGRP == T151.KDGRP
  • FINS_PLAN_PREV.MANDT == T151.MANDT
Brand
  • Brand
  • Client
  • FINS_PLAN_PREV.KMBRND_PA == T2249.KMBRND
  • FINS_PLAN_PREV.MANDT == T2249.MANDT
Destination
  • Destination
  • Client
  • FINS_PLAN_PREV.KMDEST_PA == T2211.KMDEST
  • FINS_PLAN_PREV.MANDT == T2211.MANDT
Material Group
  • FINS_PLAN_PREV.MANDT == T023.MANDT
  • FINS_PLAN_PREV.KMMAKL_PA == T023.MATKL
Strategic Business Unit
  • Strategic Business Unit
  • Client
  • FINS_PLAN_PREV.KMSTGE_PA == T2247.KMSTGE
  • FINS_PLAN_PREV.MANDT == T2247.MANDT
Sales office
  • Sales office
  • Client
  • FINS_PLAN_PREV.KMVKBU_PA == TVBUR.VKBUR
  • FINS_PLAN_PREV.MANDT == TVBUR.MANDT
Sales group
  • FINS_PLAN_PREV.MANDT == TVKGR.MANDT
  • FINS_PLAN_PREV.KMVKGR_PA == TVKGR.VKGRP
Main Material Group
  • Main Material Group
  • Client
  • FINS_PLAN_PREV.KMWNHG_PA == T2246.KMWNHG
  • FINS_PLAN_PREV.MANDT == T2246.MANDT
Controlling Area
  • FINS_PLAN_PREV.MANDT == TKA01.MANDT
  • FINS_PLAN_PREV.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • FINS_PLAN_PREV.KTOPL == T004.KTOPL
  • FINS_PLAN_PREV.MANDT == T004.MANDT
Customer Number
  • FINS_PLAN_PREV.MANDT == KNA1.MANDT
  • FINS_PLAN_PREV.KUNNR == KNA1.KUNNR
Bill-to Party
  • FINS_PLAN_PREV.MANDT == KNA1.MANDT
  • FINS_PLAN_PREV.KUNRE == KNA1.KUNNR
Ship-to Party
  • FINS_PLAN_PREV.MANDT == KNA1.MANDT
  • FINS_PLAN_PREV.KUNWE == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • FINS_PLAN_PREV.LAND1 == T005.LAND1
  • FINS_PLAN_PREV.MANDT == T005.MANDT
Account Number of Supplier
  • FINS_PLAN_PREV.MANDT == LFA1.MANDT
  • FINS_PLAN_PREV.LIFNR == LFA1.LIFNR
Product Sold Group
  • FINS_PLAN_PREV.MANDT == T023.MANDT
  • FINS_PLAN_PREV.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • FINS_PLAN_PREV.MATNR == MARA.MATNR
  • FINS_PLAN_PREV.MANDT == MARA.MANDT
Product Sold
  • Product Sold
  • Client
  • FINS_PLAN_PREV.MATNR_COPA == MARA.MATNR
  • FINS_PLAN_PREV.MANDT == MARA.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • FINS_PLAN_PREV.MANDT == CEPC.MANDT
  • FINS_PLAN_PREV.[column in domain "DATBI"] == CEPC.DATBI
  • FINS_PLAN_PREV.KOKRS == CEPC.KOKRS
  • FINS_PLAN_PREV.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • FINS_PLAN_PREV.MANDT == CEPC.MANDT
  • FINS_PLAN_PREV.[column in domain "DATBI"] == CEPC.DATBI
  • FINS_PLAN_PREV.KOKRS == CEPC.KOKRS
  • FINS_PLAN_PREV.PRCTR == CEPC.PRCTR
Partner Segment for Segmental Reporting
Company ID of Trading Partner
  • FINS_PLAN_PREV.MANDT == T880.MANDT
  • FINS_PLAN_PREV.RASSC == T880.RCOMP
Business Area
  • FINS_PLAN_PREV.MANDT == TGSB.MANDT
  • FINS_PLAN_PREV.RBUSA == TGSB.GSBER
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • FINS_PLAN_PREV.MANDT == CSKS.MANDT
  • FINS_PLAN_PREV.[column in domain "DATBI"] == CSKS.DATBI
  • FINS_PLAN_PREV.RCNTR == CSKS.KOSTL
  • FINS_PLAN_PREV.KOKRS == CSKS.KOKRS
Functional Area
  • FINS_PLAN_PREV.MANDT == TFKB.MANDT
  • FINS_PLAN_PREV.RFAREA == TFKB.FKBER
Transaction type
  • FINS_PLAN_PREV.MANDT == T856.MANDT
  • FINS_PLAN_PREV.RMVCT == T856.TRTYP
Season
  • Season Year
  • Season
Trading partner's business area
  • FINS_PLAN_PREV.MANDT == TGSB.MANDT
  • FINS_PLAN_PREV.SBUSA == TGSB.GSBER
Sender cost center
  • ?
  • Sender cost center
  • Controlling Area
  • FINS_PLAN_PREV.MANDT == CSKS.MANDT
  • FINS_PLAN_PREV.[column in domain "DATBI"] == CSKS.DATBI
  • FINS_PLAN_PREV.SCNTR == CSKS.KOSTL
  • FINS_PLAN_PREV.KOKRS == CSKS.KOKRS
Segment for Segmental Reporting
Service Contract ID
  • Service Contract Item ID
  • Service Contract Type
  • Service Contract ID
  • Client
  • FINS_PLAN_PREV.SERVICE_CONTRACT_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FINS_PLAN_PREV.SERVICE_CONTRACT_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FINS_PLAN_PREV.SERVICE_CONTRACT_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FINS_PLAN_PREV.MANDT == FCO_SRVDOC.MANDT
Service Contract Item ID
  • Service Contract Item ID
  • Service Contract Type
  • Service Contract ID
  • Client
  • FINS_PLAN_PREV.SERVICE_CONTRACT_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FINS_PLAN_PREV.SERVICE_CONTRACT_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FINS_PLAN_PREV.SERVICE_CONTRACT_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FINS_PLAN_PREV.MANDT == FCO_SRVDOC.MANDT
Service Contract Type
Service Document ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • FINS_PLAN_PREV.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FINS_PLAN_PREV.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FINS_PLAN_PREV.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FINS_PLAN_PREV.MANDT == FCO_SRVDOC.MANDT
Service Document Item ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • FINS_PLAN_PREV.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FINS_PLAN_PREV.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FINS_PLAN_PREV.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FINS_PLAN_PREV.MANDT == FCO_SRVDOC.MANDT
Service Document Type
Partner Functional Area
  • FINS_PLAN_PREV.MANDT == TFKB.MANDT
  • FINS_PLAN_PREV.SFAREA == TFKB.FKBER
Subledger-Specific Line Item Type FINS_PLAN_PREV.SLALITTYPE == FINSTS_SLALITTY.SLALITTYPE
Division
  • FINS_PLAN_PREV.MANDT == TSPA.MANDT
  • FINS_PLAN_PREV.SPART == TSPA.SPART
Origin cost center
  • ?
  • Origin cost center
  • Controlling Area
  • FINS_PLAN_PREV.MANDT == CSKS.MANDT
  • FINS_PLAN_PREV.[column in domain "DATBI"] == CSKS.DATBI
  • FINS_PLAN_PREV.UKOSTL == CSKS.KOSTL
  • FINS_PLAN_PREV.KOKRS == CSKS.KOKRS
Origin activity
  • Controlling Area
  • Origin activity
  • ?
  • FINS_PLAN_PREV.MANDT == CSLA.MANDT
  • FINS_PLAN_PREV.KOKRS == CSLA.KOKRS
  • FINS_PLAN_PREV.ULSTAR == CSLA.LSTAR
  • FINS_PLAN_PREV.[column in domain "DATBI"] == CSLA.DATBI
Sales office
  • Sales office
  • Client
  • FINS_PLAN_PREV.VKBUR_PA == TVBUR.VKBUR
  • FINS_PLAN_PREV.MANDT == TVBUR.MANDT
Sales group
  • FINS_PLAN_PREV.MANDT == TVKGR.MANDT
  • FINS_PLAN_PREV.VKGRP_PA == TVKGR.VKGRP
Sales Organization
  • FINS_PLAN_PREV.MANDT == TVKO.MANDT
  • FINS_PLAN_PREV.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • FINS_PLAN_PREV.VTWEG == TVTW.VTWEG
  • FINS_PLAN_PREV.MANDT == TVTW.MANDT
Plant
  • FINS_PLAN_PREV.MANDT == T001W.MANDT
  • FINS_PLAN_PREV.WERKS == T001W.WERKS