I_FinPlanningDeleteItem

Financial Planning Delete Items | view: IFINPLNDELITEM | Extraction: Not supported | Component: Planning
Tables used: FINS_PLAN_DELSC
Column Name Description
PlanDataUploadProcessUUID UUID
PlanDataUploadProcessItem null
Column Name Description
PlanPriceInGlobalCurrency Price in Global Currency
PlanPriceInCompanyCodeCurrency Price in Company Code Currency
PlanPriceInTransactionCurrency Price in Transaction Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in CO Object Currency
Column Name Description
📏 Unit of Measure for Valuation Quantity (CostSourceUnit):
ValuationQuantity Valuation quantity
📏 Statistical Key Figure Quantity Unit (StatisticalKeyFigQtyUnit):
StatisticalKeyFigureQuantity Quantity
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
IsLotSizeIndependent Is Lot Size Independent Show values
Column Name Description Domain name
LedgerFiscalYear General Ledger Fiscal Year GJAHR
Ledger Ledger in General Ledger Accounting FINS_LEDGER
GLAccount Account Number SAKNR
CompanyCode Company Code BUKRS
ReferenceDocumentContext Reference Organizational Units AWORG
ReferenceDocument Reference document number AWREF
FiscalPeriod Posting period POPER
FiscalYearVariant Fiscal Year Variant PERIV
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
SalesOrder Sales Order Number VBELN
SalesOrderItem Item number in Sales Order NUM06
PersonnelNumber Personnel Number PERNR
WBSElementInternalID Work Breakdown Structure Element (WBS Element) PS_POSNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Project Project definition PS_PSPID
PartnerWBSElement Partner Work Breakdown Structure Element PS_POSID
PartnerProject Partner Project PS_PSPID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
CustomerSupplierCorporateGroup Group key KONZS
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • I_FINPLANNINGDELETEITEM.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_FINPLANNINGDELETEITEM.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_FINPLANNINGDELETEITEM.BILLTOPARTY == KNA1.KUNNR
  • I_FINPLANNINGDELETEITEM.MANDT == KNA1.MANDT
Budget Type (Subcategory)
  • Budget Type (Subcategory)
  • Client
Budget Period
  • Budget Period
  • Client
  • I_FINPLANNINGDELETEITEM.BUDGETPERIOD == FMBUDGETPD.BUDGET_PD
  • I_FINPLANNINGDELETEITEM.MANDT == FMBUDGETPD.MANDT
Budget Process Type
  • Budget Process Type
  • Client
Business Area
  • Business Area
  • Client
  • I_FINPLANNINGDELETEITEM.BUSINESSAREA == TGSB.GSBER
  • I_FINPLANNINGDELETEITEM.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_FINPLANNINGDELETEITEM.CHARTOFACCOUNTS == T004.KTOPL
  • I_FINPLANNINGDELETEITEM.MANDT == T004.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_FINPLANNINGDELETEITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_FINPLANNINGDELETEITEM.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Cost Center
  • Client
  • I_FINPLANNINGDELETEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • I_FINPLANNINGDELETEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • I_FINPLANNINGDELETEITEM.COSTCENTER == CSKS.KOSTL
  • I_FINPLANNINGDELETEITEM.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • I_FINPLANNINGDELETEITEM.CUSTOMER == KNA1.KUNNR
  • I_FINPLANNINGDELETEITEM.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_FINPLANNINGDELETEITEM.CUSTOMERGROUP == T151.KDGRP
  • I_FINPLANNINGDELETEITEM.MANDT == T151.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_FINPLANNINGDELETEITEM.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_FINPLANNINGDELETEITEM.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • I_FINPLANNINGDELETEITEM.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_FINPLANNINGDELETEITEM.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_FINPLANNINGDELETEITEM.MANDT == TVTW.MANDT
  • I_FINPLANNINGDELETEITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Financial Management Area
  • Financial Management Area
  • Client
  • I_FINPLANNINGDELETEITEM.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_FINPLANNINGDELETEITEM.MANDT == FM01.MANDT
Transaction type
  • Transaction type
  • Client
  • I_FINPLANNINGDELETEITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_FINPLANNINGDELETEITEM.MANDT == T856.MANDT
Functional Area
  • Functional Area
  • Client
  • I_FINPLANNINGDELETEITEM.FUNCTIONALAREA == TFKB.FKBER
  • I_FINPLANNINGDELETEITEM.MANDT == TFKB.MANDT
Fund
  • Fund
  • Financial Management Area
  • Client
  • I_FINPLANNINGDELETEITEM.FUND == FMFINCODE.FINCODE
  • I_FINPLANNINGDELETEITEM.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_FINPLANNINGDELETEITEM.MANDT == FMFINCODE.MANDT
Grant
  • Grant
  • Client
  • I_FINPLANNINGDELETEITEM.GRANTID == GMGR.GRANT_NBR
  • I_FINPLANNINGDELETEITEM.MANDT == GMGR.CLIENT
Material Number
  • Material Number
  • Client
  • I_FINPLANNINGDELETEITEM.MATERIAL == MARA.MATNR
  • I_FINPLANNINGDELETEITEM.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • I_FINPLANNINGDELETEITEM.MATERIALGROUP == T023.MATKL
  • I_FINPLANNINGDELETEITEM.MANDT == T023.MANDT
Division
  • Client
  • Division
  • I_FINPLANNINGDELETEITEM.MANDT == TSPA.MANDT
  • I_FINPLANNINGDELETEITEM.ORGANIZATIONDIVISION == TSPA.SPART
Trading partner's business area
  • Client
  • Trading partner's business area
  • I_FINPLANNINGDELETEITEM.MANDT == TGSB.MANDT
  • I_FINPLANNINGDELETEITEM.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_FINPLANNINGDELETEITEM.PARTNERCOMPANY == T880.RCOMP
  • I_FINPLANNINGDELETEITEM.MANDT == T880.MANDT
Sender cost center
  • ?
  • Controlling Area
  • Client
  • Sender cost center
  • I_FINPLANNINGDELETEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • I_FINPLANNINGDELETEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • I_FINPLANNINGDELETEITEM.MANDT == CSKS.MANDT
  • I_FINPLANNINGDELETEITEM.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Partner Functional Area
  • Client
  • I_FINPLANNINGDELETEITEM.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • I_FINPLANNINGDELETEITEM.MANDT == TFKB.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • Partner Profit Center
  • I_FINPLANNINGDELETEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • I_FINPLANNINGDELETEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • I_FINPLANNINGDELETEITEM.MANDT == CEPC.MANDT
  • I_FINPLANNINGDELETEITEM.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_FINPLANNINGDELETEITEM.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_FINPLANNINGDELETEITEM.MANDT == FAGL_SEGM.MANDT
Plan Category
  • Plan Category
  • Client
Plant
  • Plant
  • Client
  • I_FINPLANNINGDELETEITEM.PLANT == T001W.WERKS
  • I_FINPLANNINGDELETEITEM.MANDT == T001W.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • I_FINPLANNINGDELETEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • I_FINPLANNINGDELETEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • I_FINPLANNINGDELETEITEM.PROFITCENTER == CEPC.PRCTR
  • I_FINPLANNINGDELETEITEM.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • I_FINPLANNINGDELETEITEM.SALESDISTRICT == T171.BZIRK
  • I_FINPLANNINGDELETEITEM.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_FINPLANNINGDELETEITEM.SALESORGANIZATION == TVKO.VKORG
  • I_FINPLANNINGDELETEITEM.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_FINPLANNINGDELETEITEM.SEGMENT == FAGL_SEGM.SEGMENT
  • I_FINPLANNINGDELETEITEM.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • I_FINPLANNINGDELETEITEM.SHIPTOPARTY == KNA1.KUNNR
  • I_FINPLANNINGDELETEITEM.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • I_FINPLANNINGDELETEITEM.SOLDMATERIAL == MARA.MATNR
  • I_FINPLANNINGDELETEITEM.MANDT == MARA.MANDT
Statistical key figure
  • Controlling Area
  • Client
  • Statistical key figure
  • I_FINPLANNINGDELETEITEM.CONTROLLINGAREA == TKA03.KOKRS
  • I_FINPLANNINGDELETEITEM.MANDT == TKA03.MANDT
  • I_FINPLANNINGDELETEITEM.STATISTICALKEYFIGURE == TKA03.STAGR