FINS_PLAN_DELSC

Table for delete scope | #fiori | Component: Planning
Column Name Description
MANDT Client
UUID UUID
POS null
Column Name Description
💲 Global Currency (ACDOCP.RKCUR):
KPRICE Price in Global Currency
KSL Amount in Global Currency
KFSL Fixed Amount in Global Currency
💲 Company Code Currency (ACDOCP.RHCUR):
HPRICE Price in Company Code Currency
HSL Amount in Company Code Currency
💲 Transaction Currency (ACDOCP.RWCUR):
WPRICE Price in Transaction Currency
WSL Amount in Transaction 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
💲 CO Object Currency (RCO_OCUR):
CO_OSL Amount in CO Object Currency
Column Name Description
📏 Unit of Measure for Valuation Quantity (RVUNIT):
VMSL Valuation quantity
SCRAP_QTY Scrap Quantity
COMP_SCRAP_QTY Component Scrap Quantity
📏 Statistical Key Figure Quantity Unit (RUNIT):
MSL Quantity
📏 Lot Size Unit of Measure (ACDOCP.LSUNIT):
LOSGR Lot Size for Product Costing
Column Name Description
BUDAT Posting Date in the Document
PRODPER Production Month (Date to find period and year)
DABRZ Reference date for settlement
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
PLKNZ Maintenance order planning indicator Show values
SCOPE Object Class Show values
AUTYP Order category 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
VORNR Operation/Activity Number VORNR
AUFPS Order item number CO_POSNR
UVORN Suboperation VORNR
PAUFPS Partner Order Item Number CO_POSNR
FISCYEARPER8 External view fiscal year period
NPLNR_VORGN Network activity VORNR
ASSL_SCRAP_PCT Assembly scrap in percent DEC3_2
SCRAP_FACTOR Scrap Factor DEC3_3
Master Data Relations Join Conditions
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • FINS_PLAN_DELSC.ARBID == CRID.OBJID
  • FINS_PLAN_DELSC.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • FINS_PLAN_DELSC.MANDT == CRID.MANDT
Generic Article
  • Generic Article
  • Client
  • FINS_PLAN_DELSC.ARTNRG_PA == MARA.MATNR
  • FINS_PLAN_DELSC.MANDT == MARA.MANDT
Priority Type
  • FINS_PLAN_DELSC.MANDT == T356A.MANDT
  • FINS_PLAN_DELSC.ARTPR == T356A.ARTPR
Activity Number
  • FINS_PLAN_DELSC.MANDT == ASMD.MANDT
  • FINS_PLAN_DELSC.ASNUM == ASMD.ASNUM
Vol. Rebate Grp
  • Volume rebate group
  • Client
  • FINS_PLAN_DELSC.BONUS_PA == TVBO.BONUS
  • FINS_PLAN_DELSC.MANDT == TVBO.MANDT
Industry key
  • Industry key
  • Client
  • FINS_PLAN_DELSC.BRSCH == T016.BRSCH
  • FINS_PLAN_DELSC.MANDT == T016.MANDT
Business Transaction Category
Budget Process Type
Budget Type (Subcategory)
Sales District
  • FINS_PLAN_DELSC.MANDT == T171.MANDT
  • FINS_PLAN_DELSC.BZIRK == T171.BZIRK
Plan Category
Collection
  • Season Year
  • Season
  • Client
  • Fashion Collection
Equity group
  • Joint venture
  • Client
  • Equity group
  • Company Code
  • FINS_PLAN_DELSC.VNAME == T8JF.VNAME
  • FINS_PLAN_DELSC.MANDT == T8JF.MANDT
  • FINS_PLAN_DELSC.EGRUP == T8JF.EGRUP
  • FINS_PLAN_DELSC.RBUKRS == T8JF.BUKRS
Purchasing organization
  • FINS_PLAN_DELSC.MANDT == T024E.MANDT
  • FINS_PLAN_DELSC.EKORG == T024E.EKORG
Equipment Number
  • Equipment Number
  • Client
  • FINS_PLAN_DELSC.EQUNR == EQUI.EQUNR
  • FINS_PLAN_DELSC.MANDT == EQUI.MANDT
Financial Management Area
  • FINS_PLAN_DELSC.MANDT == FM01.MANDT
  • FINS_PLAN_DELSC.FIKRS == FM01.FIKRS
Billing Type
  • FINS_PLAN_DELSC.MANDT == TVFK.MANDT
  • FINS_PLAN_DELSC.FKART == TVFK.FKART
Origin Group as Subdivision of Cost Element
  • Origin Group as Subdivision of Cost Element
  • Client
  • Controlling Area
  • ?
  • FINS_PLAN_DELSC.HKGRP == TKKH1.HRKFT
  • FINS_PLAN_DELSC.MANDT == TKKH1.MANDT
  • FINS_PLAN_DELSC.KOKRS == TKKH1.KOKRS
  • FINS_PLAN_DELSC.[column in domain "HRKTYP"] == TKKH1.KOATY
Maintenance activity type
  • FINS_PLAN_DELSC.MANDT == T353I.MANDT
  • FINS_PLAN_DELSC.ILART == T353I.ILART
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • FINS_PLAN_DELSC.INFNR == EINA.INFNR
  • FINS_PLAN_DELSC.MANDT == EINA.MANDT
Assembly
  • Assembly
  • Client
  • FINS_PLAN_DELSC.ISTRU == MARA.MATNR
  • FINS_PLAN_DELSC.MANDT == MARA.MANDT
Customer Group
  • Customer Group
  • Client
  • FINS_PLAN_DELSC.KDGRP == T151.KDGRP
  • FINS_PLAN_DELSC.MANDT == T151.MANDT
Brand
  • Brand
  • Client
  • FINS_PLAN_DELSC.KMBRND_PA == T2249.KMBRND
  • FINS_PLAN_DELSC.MANDT == T2249.MANDT
Destination
  • Destination
  • Client
  • FINS_PLAN_DELSC.KMDEST_PA == T2211.KMDEST
  • FINS_PLAN_DELSC.MANDT == T2211.MANDT
Material Group
  • FINS_PLAN_DELSC.MANDT == T023.MANDT
  • FINS_PLAN_DELSC.KMMAKL_PA == T023.MATKL
Strategic Business Unit
  • Strategic Business Unit
  • Client
  • FINS_PLAN_DELSC.KMSTGE_PA == T2247.KMSTGE
  • FINS_PLAN_DELSC.MANDT == T2247.MANDT
Sales office
  • Sales office
  • Client
  • FINS_PLAN_DELSC.KMVKBU_PA == TVBUR.VKBUR
  • FINS_PLAN_DELSC.MANDT == TVBUR.MANDT
Sales group
  • FINS_PLAN_DELSC.MANDT == TVKGR.MANDT
  • FINS_PLAN_DELSC.KMVKGR_PA == TVKGR.VKGRP
Main Material Group
  • Main Material Group
  • Client
  • FINS_PLAN_DELSC.KMWNHG_PA == T2246.KMWNHG
  • FINS_PLAN_DELSC.MANDT == T2246.MANDT
Controlling Area
  • FINS_PLAN_DELSC.MANDT == TKA01.MANDT
  • FINS_PLAN_DELSC.KOKRS == TKA01.KOKRS
Cost Object
  • Cost Object
  • ?
  • Client
  • FINS_PLAN_DELSC.KSTRG == CKPH.KSTRG
  • FINS_PLAN_DELSC.[column in domain "DATBI"] == CKPH.DATBI
  • FINS_PLAN_DELSC.MANDT == CKPH.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • FINS_PLAN_DELSC.KTOPL == T004.KTOPL
  • FINS_PLAN_DELSC.MANDT == T004.MANDT
Customer Number
  • FINS_PLAN_DELSC.MANDT == KNA1.MANDT
  • FINS_PLAN_DELSC.KUNNR == KNA1.KUNNR
Bill-to Party
  • FINS_PLAN_DELSC.MANDT == KNA1.MANDT
  • FINS_PLAN_DELSC.KUNRE == KNA1.KUNNR
Ship-to Party
  • FINS_PLAN_DELSC.MANDT == KNA1.MANDT
  • FINS_PLAN_DELSC.KUNWE == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • FINS_PLAN_DELSC.LAND1 == T005.LAND1
  • FINS_PLAN_DELSC.MANDT == T005.MANDT
Account Number of Supplier
  • FINS_PLAN_DELSC.MANDT == LFA1.MANDT
  • FINS_PLAN_DELSC.LIFNR == LFA1.LIFNR
Product Sold Group
  • FINS_PLAN_DELSC.MANDT == T023.MANDT
  • FINS_PLAN_DELSC.MATKL == T023.MATKL
Material Group
  • FINS_PLAN_DELSC.MANDT == T023.MANDT
  • FINS_PLAN_DELSC.MATKL_MM == T023.MATKL
Material Number
  • Material Number
  • Client
  • FINS_PLAN_DELSC.MATNR == MARA.MATNR
  • FINS_PLAN_DELSC.MANDT == MARA.MANDT
Product Sold
  • Product Sold
  • Client
  • FINS_PLAN_DELSC.MATNR_COPA == MARA.MATNR
  • FINS_PLAN_DELSC.MANDT == MARA.MANDT
Number of Superior Order
  • Number of Superior Order
  • Client
  • FINS_PLAN_DELSC.MAUFNR == AUFK.AUFNR
  • FINS_PLAN_DELSC.MANDT == AUFK.MANDT
Transaction Type Category FINS_PLAN_DELSC.MOVCAT == FAAI_MOVCAT.MOVCAT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • FINS_PLAN_DELSC.NPLNR == AUFK.AUFNR
  • FINS_PLAN_DELSC.MANDT == AUFK.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • FINS_PLAN_DELSC.MANDT == CEPC.MANDT
  • FINS_PLAN_DELSC.[column in domain "DATBI"] == CEPC.DATBI
  • FINS_PLAN_DELSC.KOKRS == CEPC.KOKRS
  • FINS_PLAN_DELSC.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • FINS_PLAN_DELSC.MANDT == CEPC.MANDT
  • FINS_PLAN_DELSC.[column in domain "DATBI"] == CEPC.DATBI
  • FINS_PLAN_DELSC.KOKRS == CEPC.KOKRS
  • FINS_PLAN_DELSC.PRCTR == CEPC.PRCTR
Priority
  • Priority Type
  • Client
  • Priority
  • FINS_PLAN_DELSC.ARTPR == T356.ARTPR
  • FINS_PLAN_DELSC.MANDT == T356.MANDT
  • FINS_PLAN_DELSC.PRIOK == T356.PRIOK
Partner Segment for Segmental Reporting
Company ID of Trading Partner
  • FINS_PLAN_DELSC.MANDT == T880.MANDT
  • FINS_PLAN_DELSC.RASSC == T880.RCOMP
Budget Validity Number
  • ?
  • Budget Validity Number
  • Client
  • Grant
  • ?
Budget Period
  • Budget Period
  • Client
Business Area
  • FINS_PLAN_DELSC.MANDT == TGSB.MANDT
  • FINS_PLAN_DELSC.RBUSA == TGSB.GSBER
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • FINS_PLAN_DELSC.MANDT == CSKS.MANDT
  • FINS_PLAN_DELSC.[column in domain "DATBI"] == CSKS.DATBI
  • FINS_PLAN_DELSC.RCNTR == CSKS.KOSTL
  • FINS_PLAN_DELSC.KOKRS == CSKS.KOKRS
Recovery Indicator
  • Company Code
  • Recovery Indicator
  • FINS_PLAN_DELSC.MANDT == T8JJ.MANDT
  • FINS_PLAN_DELSC.RBUKRS == T8JJ.BUKRS
  • FINS_PLAN_DELSC.RECID == T8JJ.RECID
Functional Area
  • FINS_PLAN_DELSC.MANDT == TFKB.MANDT
  • FINS_PLAN_DELSC.RFAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Fund
  • Client
Grant
  • FINS_PLAN_DELSC.MANDT == GMGR.CLIENT
  • FINS_PLAN_DELSC.RGRANT_NBR == GMGR.GRANT_NBR
Transaction type
  • FINS_PLAN_DELSC.MANDT == T856.MANDT
  • FINS_PLAN_DELSC.RMVCT == T856.TRTYP
Sponsored Class
  • Sponsored Class
  • Client
  • FINS_PLAN_DELSC.RSPONSORED_CLASS == GMSPCLASS.SPONSORED_CLASS
  • FINS_PLAN_DELSC.MANDT == GMSPCLASS.CLIENT
Sponsored Program
Season
  • Season Year
  • Season
Trading partner's business area
  • FINS_PLAN_DELSC.MANDT == TGSB.MANDT
  • FINS_PLAN_DELSC.SBUSA == TGSB.GSBER
Sender cost center
  • ?
  • Sender cost center
  • Controlling Area
  • FINS_PLAN_DELSC.MANDT == CSKS.MANDT
  • FINS_PLAN_DELSC.[column in domain "DATBI"] == CSKS.DATBI
  • FINS_PLAN_DELSC.SCNTR == CSKS.KOSTL
  • FINS_PLAN_DELSC.KOKRS == CSKS.KOKRS
Segment for Segmental Reporting
Service Contract ID
  • Service Contract Item ID
  • Service Contract Type
  • Service Contract ID
  • Client
  • FINS_PLAN_DELSC.SERVICE_CONTRACT_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FINS_PLAN_DELSC.SERVICE_CONTRACT_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FINS_PLAN_DELSC.SERVICE_CONTRACT_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FINS_PLAN_DELSC.MANDT == FCO_SRVDOC.MANDT
Service Contract Item ID
  • Service Contract Item ID
  • Service Contract Type
  • Service Contract ID
  • Client
  • FINS_PLAN_DELSC.SERVICE_CONTRACT_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FINS_PLAN_DELSC.SERVICE_CONTRACT_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FINS_PLAN_DELSC.SERVICE_CONTRACT_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FINS_PLAN_DELSC.MANDT == FCO_SRVDOC.MANDT
Service Contract Type
Service Document ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • FINS_PLAN_DELSC.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FINS_PLAN_DELSC.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FINS_PLAN_DELSC.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FINS_PLAN_DELSC.MANDT == FCO_SRVDOC.MANDT
Service Document Item ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • FINS_PLAN_DELSC.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FINS_PLAN_DELSC.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • FINS_PLAN_DELSC.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • FINS_PLAN_DELSC.MANDT == FCO_SRVDOC.MANDT
Service Document Type
Partner Functional Area
  • FINS_PLAN_DELSC.MANDT == TFKB.MANDT
  • FINS_PLAN_DELSC.SFAREA == TFKB.FKBER
Subledger-Specific Line Item Type FINS_PLAN_DELSC.SLALITTYPE == FINSTS_SLALITTY.SLALITTYPE
Division
  • FINS_PLAN_DELSC.MANDT == TSPA.MANDT
  • FINS_PLAN_DELSC.SPART == TSPA.SPART
Statistical key figure
  • Controlling Area
  • Statistical key figure
  • Client
  • FINS_PLAN_DELSC.KOKRS == TKA03.KOKRS
  • FINS_PLAN_DELSC.STAGR == TKA03.STAGR
  • FINS_PLAN_DELSC.MANDT == TKA03.MANDT
Functional Location
  • FINS_PLAN_DELSC.MANDT == IFLOT.MANDT
  • FINS_PLAN_DELSC.TPLNR == IFLOT.TPLNR
Origin cost center
  • ?
  • Origin cost center
  • Controlling Area
  • FINS_PLAN_DELSC.MANDT == CSKS.MANDT
  • FINS_PLAN_DELSC.[column in domain "DATBI"] == CSKS.DATBI
  • FINS_PLAN_DELSC.UKOSTL == CSKS.KOSTL
  • FINS_PLAN_DELSC.KOKRS == CSKS.KOKRS
Origin activity
  • Controlling Area
  • Origin activity
  • ?
  • FINS_PLAN_DELSC.MANDT == CSLA.MANDT
  • FINS_PLAN_DELSC.KOKRS == CSLA.KOKRS
  • FINS_PLAN_DELSC.ULSTAR == CSLA.LSTAR
  • FINS_PLAN_DELSC.[column in domain "DATBI"] == CSLA.DATBI
Sales office
  • Sales office
  • Client
  • FINS_PLAN_DELSC.VKBUR_PA == TVBUR.VKBUR
  • FINS_PLAN_DELSC.MANDT == TVBUR.MANDT
Sales group
  • FINS_PLAN_DELSC.MANDT == TVKGR.MANDT
  • FINS_PLAN_DELSC.VKGRP_PA == TVKGR.VKGRP
Sales Organization
  • FINS_PLAN_DELSC.MANDT == TVKO.MANDT
  • FINS_PLAN_DELSC.VKORG == TVKO.VKORG
Joint venture
  • Company Code
  • Joint venture
  • Client
  • FINS_PLAN_DELSC.RBUKRS == T8JV.BUKRS
  • FINS_PLAN_DELSC.VNAME == T8JV.VNAME
  • FINS_PLAN_DELSC.MANDT == T8JV.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • FINS_PLAN_DELSC.VTWEG == TVTW.VTWEG
  • FINS_PLAN_DELSC.MANDT == TVTW.MANDT
Plant
  • FINS_PLAN_DELSC.MANDT == T001W.MANDT
  • FINS_PLAN_DELSC.WERKS == T001W.WERKS