What is C_FinPlanningDeleteItem in SAP S/4HANA?

C_FinPlanningDeleteItem is a consumption CDS view in SAP S/4HANA. Consumption View for Basic View I_FinPlanningDeleteItem It contains 100 fields.

Which tables does C_FinPlanningDeleteItem read from?

C_FinPlanningDeleteItem reads data from: I_FinPlanningDeleteItem.

What VDM layer is C_FinPlanningDeleteItem?

C_FinPlanningDeleteItem is classified as a Consumption view optimized for specific business scenarios and reporting.

C_FinPlanningDeleteItem

DDL: C_FINPLANNINGDELETEITEM SQL: CFINPLNDELITEM Type: view CONSUMPTION

100 Fields 1 Data Sources 1 Associations

Consumption View for Basic View I_FinPlanningDeleteItem

C_FinPlanningDeleteItem is a Consumption CDS View that provides data about "Consumption View for Basic View I_FinPlanningDeleteItem" in SAP S/4HANA. It reads from 1 data source (I_FinPlanningDeleteItem) and exposes 100 fields with key fields PlanDataUploadProcessUUID, PlanDataUploadProcessItem. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_FinPlanningDeleteItem	I_FinPlanningDeleteItem	from

Parameters (1)

Name	Type	Default
P_PlanDataUploadProcessUUID	fins_plan_uuid

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	E_FinPlanningDeleteItem	_Extension	`$projection.PlanDataUploadProcessUUID = _Extension.PlanDataUploadProcessUUID and $projection.PlanDataUploadProcessItem = _Extension.PlanDataUploadProcessItem`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	CFINPLNDELITEM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Consumption View for Basic View I_FinPlanningDeleteItem	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	M	view
ObjectModel.usageType.serviceQuality	D	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (100)

Key	Field	Source Field	Description
KEY	PlanDataUploadProcessUUID	PlanDataUploadProcessUUID	Waste Partner UUID
KEY	PlanDataUploadProcessItem	PlanDataUploadProcessItem	Table position
	LedgerFiscalYear	LedgerFiscalYear	Ref. Year1
	Ledger	Ledger	Ledger
	GLAccount	GLAccount	General Ledger
	CompanyCode	CompanyCode	Receiver Company Code
	PlanningCategory	PlanningCategory	Plan Category
	PlanPriceInGlobalCurrency	PlanPriceInGlobalCurrency	Price in Gl. Crcy
	PlanPriceInCompanyCodeCurrency	PlanPriceInCompanyCodeCurrency	Price in CompCd Crcy
	PlanPriceInTransactionCurrency	PlanPriceInTransactionCurrency	Price in Trans. Crcy
	FinancialTransactionType	FinancialTransactionType	Transact. Type
	ReferenceDocumentContext	ReferenceDocumentContext	Reference Document Context
	ReferenceDocument	ReferenceDocument	Reference Document
	TransactionCurrency	TransactionCurrency	Transaction Currency
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	GlobalCurrency	GlobalCurrency	GM Billing Element: Global Currency
	FreeDefinedCurrency1	FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2	FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3	FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4	FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5	FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6	FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7	FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8	FreeDefinedCurrency8	Freely Defined Currency 8
	ControllingObjectCurrency	ControllingObjectCurrency	CO Object Currency
	CostSourceUnit	CostSourceUnit	Valuation UoM
	CostCenter	CostCenter	Cost Center
	ProfitCenter	ProfitCenter	Profit Center
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	BusinessArea	BusinessArea	Business Area
	ControllingArea	ControllingArea	Controlling Area
	Segment	Segment	Segment number
	PartnerCostCenter	PartnerCostCenter	Sender Cost Ctr
	PartnerProfitCenter	PartnerProfitCenter	Profit Center
	PartnerFunctionalArea	PartnerFunctionalArea	Rec. Fntcl Area
	PartnerBusinessArea	PartnerBusinessArea	Trdg Part.BA
	PartnerCompany	PartnerCompany	Trading Partner
	PartnerSegment	PartnerSegment	Partner Segment
	AmountInTransactionCurrency	AmountInTransactionCurrency	Pt Crcy Amt
	AmountInGlobalCurrency	AmountInGlobalCurrency	Amount in Global Currency
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Local Crcy Amt
	AmountInFreeDefinedCurrency1	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	AmountInFreeDefinedCurrency2	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	AmountInFreeDefinedCurrency3	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	AmountInFreeDefinedCurrency4	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	AmountInFreeDefinedCurrency5	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	AmountInFreeDefinedCurrency6	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	AmountInFreeDefinedCurrency7	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	AmountInFreeDefinedCurrency8	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	ValuationQuantity	ValuationQuantity	Val. quantity
	AmountInObjectCurrency	AmountInObjectCurrency	Amount in Obj Crcy
	FiscalPeriod	FiscalPeriod	Tax period
	PostingDate	PostingDate	Posting Date for GR
	FiscalYearVariant	FiscalYearVariant	FY Variant
	FiscalYearPeriod		Period/Year
	ChartOfAccounts	ChartOfAccounts	Node Class
	SalesOrder	SalesOrder	SD Document
	SalesOrderItem	SalesOrderItem	Sales Order Item
	Material	Material	Vehicle Model
	Plant	Plant	Valuation Area
	Customer	Customer	Sold-to Party
	ControllingDebitCreditCode	ControllingDebitCreditCode	Dr/Cr ind. CO
	PersonnelNumber	PersonnelNumber	Personnel No.
	WBSElementInternalID	WBSElementInternalID	WBS Internal ID
	WBSElement	WBSElement	WBS Internal ID
	Project	Project	WBS Element
	PartnerCompanyCode	PartnerCompanyCode	Partner Company Code
	AccountAssignmentType	AccountAssignmentType	Sndr AcctAssgmt Type
	CostCtrActivityType	CostCtrActivityType	Activity Type
	OrderID	OrderID	Order ID
	CostAnalysisResource	CostAnalysisResource	Resource
	PartnerOrder	PartnerOrder	Partner Order
	PartnerCostCtrActivityType	PartnerCostCtrActivityType	Partner Cost Center Activity Type
	PartnerWBSElement	PartnerWBSElement	WBS Element
	PartnerProject	PartnerProject	Part. Proj. Def
	WorkItem	WorkItem	Work Item ID
	BillableControl	BillableControl	Billable Control
	IsLotSizeIndependent	IsLotSizeIndependent	LotSzIndep.Ind.
	BillingDocumentType	BillingDocumentType	Billing Type
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	OrganizationDivision	Org. Division
	SoldMaterial	SoldMaterial	Product Sold
	MaterialGroup	MaterialGroup	Product Group
	CustomerGroup	CustomerGroup	Customer Group
	CustomerSupplierCountry	CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry	CustomerSupplierIndustry	Industry
	SalesDistrict	SalesDistrict	Sales District
	BillToParty	BillToParty	Inv. Recipient
	ShipToParty	ShipToParty	Ship-To Party (obsolete)
	CustomerSupplierCorporateGroup	CustomerSupplierCorporateGroup	Group
	FinancialManagementArea	FinancialManagementArea	FM Area
	Fund	Fund	Sender Fund
	GrantID	GrantID	Sender Grant
	BudgetPeriod	BudgetPeriod	Budget Period
	BudgetProcess	BudgetProcess	Budget Process Type
	BudgetingType	BudgetingType	Budget Type
	StatisticalKeyFigure	StatisticalKeyFigure	Statistical Key Figure
	StatisticalKeyFigureQuantity	StatisticalKeyFigureQuantity	Stat. KeyFig. Qty
	StatisticalKeyFigQtyUnit	StatisticalKeyFigQtyUnit	Unit/Area

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FinPlanningDeleteItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFINPLNDELITEM
-- Parameters: P_PlanDataUploadProcessUUID : fins_plan_uuid

CREATE VIEW C_FinPlanningDeleteItem AS
SELECT
  PlanDataUploadProcessUUID,
  PlanDataUploadProcessItem,
  LedgerFiscalYear,
  Ledger,
  GLAccount,
  CompanyCode,
  PlanningCategory,
  PlanPriceInGlobalCurrency,
  PlanPriceInCompanyCodeCurrency,
  PlanPriceInTransactionCurrency,
  FinancialTransactionType,
  ReferenceDocumentContext,
  ReferenceDocument,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  ControllingObjectCurrency,
  CostSourceUnit,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  AmountInTransactionCurrency,
  AmountInGlobalCurrency,
  AmountInCompanyCodeCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  ValuationQuantity,
  AmountInObjectCurrency,
  FiscalPeriod,
  PostingDate,
  FiscalYearVariant,
  cast( cast(FiscalYearPeriod as abap.char(7)) as fis_jahrper_c preserving type ) AS FiscalYearPeriod,
  ChartOfAccounts,
  SalesOrder,
  SalesOrderItem,
  Material,
  Plant,
  Customer,
  ControllingDebitCreditCode,
  PersonnelNumber,
  WBSElementInternalID,
  WBSElement,
  Project,
  PartnerCompanyCode,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  CostAnalysisResource,
  PartnerOrder,
  PartnerCostCtrActivityType,
  PartnerWBSElement,
  PartnerProject,
  WorkItem,
  BillableControl,
  IsLotSizeIndependent,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  FinancialManagementArea,
  Fund,
  GrantID,
  BudgetPeriod,
  BudgetProcess,
  BudgetingType,
  StatisticalKeyFigure,
  StatisticalKeyFigureQuantity,
  StatisticalKeyFigQtyUnit
FROM I_FinPlanningDeleteItem
LEFT OUTER JOIN E_FinPlanningDeleteItem AS _Extension ON PlanDataUploadProcessUUID = _Extension.PlanDataUploadProcessUUID AND PlanDataUploadProcessItem = _Extension.PlanDataUploadProcessItem  -- association [1..1]
;

Depth:

C_FinPlanningDeleteItem view

I_FinPlanningDeleteItem view