What is A_FinPlanEntryItemVariableFix in SAP S/4HANA?

A_FinPlanEntryItemVariableFix is a composite CDS view in SAP S/4HANA. API Financial Planning Entry Item Variable and Fixed Amounts It contains 127 fields.

Which tables does A_FinPlanEntryItemVariableFix read from?

A_FinPlanEntryItemVariableFix reads data from: I_FinPlanEntryItemVariableFix.

What VDM layer is A_FinPlanEntryItemVariableFix?

A_FinPlanEntryItemVariableFix is classified as a Composite view that combines data from multiple basic views.

A_FinPlanEntryItemVariableFix

DDL: A_FINPLANENTRYITEMVARIABLEFIX SQL: AFIFINPLANENTVF Type: view COMPOSITE Package: FINS_FIS_FICO

127 Fields 1 Data Sources 1 Associations

API Financial Planning Entry Item Variable and Fixed Amounts

A_FinPlanEntryItemVariableFix is a Composite CDS View that provides data about "API Financial Planning Entry Item Variable and Fixed Amounts" in SAP S/4HANA. It reads from 1 data source (I_FinPlanEntryItemVariableFix) and exposes 127 fields with key fields FinancialPlanningDataPacket, FinancialPlanningEntryItem, FinancialPlanningReqTransSqnc, FixedVariableType. It has 1 association to related views. Part of development package FINS_FIS_FICO.

Data Sources (1)

Source	Alias	Join Type
I_FinPlanEntryItemVariableFix	I_FinPlanEntryItemVariableFix	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	E_FinancialPlanningEntryItem	_Extension	`$projection.FinancialPlanningDataPacket = _Extension.FinancialPlanningDataPacket and $projection.FinancialPlanningEntryItem = _Extension.FinancialPlanningEntryItem and $projection.FinancialPlanningReqTransSqnc = _Extension.FinancialPlanningReqTransSqnc`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	AFIFINPLANENTVF	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	API Financial Planning Entry Item Variable and Fixed Amounts	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (127)

Key	Field	Source Field	Description
KEY	FinancialPlanningDataPacket	FinancialPlanningDataPacket	Data packet number
KEY	FinancialPlanningEntryItem	FinancialPlanningEntryItem
KEY	FinancialPlanningReqTransSqnc	FinancialPlanningReqTransSqnc	Request TSN
KEY	FixedVariableType	FixedVariableType
	Ledger	Ledger	Ledger
	LedgerName	LedgerName	Ledger Name
	PlanningCategory	PlanningCategory	Plan Category
	LedgerFiscalYear	LedgerFiscalYear
	GLAccount	GLAccount	General Ledger
	GLAccountName	GLAccountName	Short Text
	CompanyCode	CompanyCode	Receiver Company Code
	CompanyCodeName	CompanyCodeName	Company Name
	FinancialTransactionType	FinancialTransactionType	Transact. Type
	CostCenter	CostCenter	Cost Center
	CostCenterName	CostCenterName	Name
	ProfitCenter	ProfitCenter	Profit Center
	ProfitCenterName	ProfitCenterName	Profit Center Name
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	FunctionalAreaName	FunctionalAreaName	Long Text
	BusinessArea	BusinessArea	Business Area
	BusinessAreaName	BusinessAreaName	Business Area Name
	ControllingArea	ControllingArea	Controlling Area
	ControllingAreaName	ControllingAreaName	Long Text
	Segment	Segment	Segment number
	SegmentName	SegmentName	Segment Name
	PartnerCostCenter	PartnerCostCenter	Sender Cost Ctr
	PartnerCostCenterName	PartnerCostCenterName
	PartnerProfitCenter	PartnerProfitCenter	Profit Center
	PartnerProfitCenterName	PartnerProfitCenterName
	PartnerFunctionalArea	PartnerFunctionalArea	Rec. Fntcl Area
	PartnerFunctionalAreaName	PartnerFunctionalAreaName
	PartnerBusinessArea	PartnerBusinessArea	Trdg Part.BA
	PartnerBusinessAreaName	PartnerBusinessAreaName
	PartnerCompany	PartnerCompany	Trading Partner
	PartnerCompanyName	PartnerCompanyName
	PartnerSegment	PartnerSegment	Partner Segment
	PartnerSegmentName	PartnerSegmentName
	TransactionCurrency	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	AmountInGlobalCurrency	Amount in Global Currency
	ControllingObjectCurrency	ControllingObjectCurrency	CO Object Currency
	AmountInObjectCurrency	AmountInObjectCurrency	Amount in Obj Crcy
	FunctionalCurrency	FunctionalCurrency	Functional Currency
	AmountInFunctionalCurrency	AmountInFunctionalCurrency	Amount in Functional Currency
	CostSourceUnit	CostSourceUnit
	ValuationQuantity	ValuationQuantity
	ReferenceQuantityUnit	ReferenceQuantityUnit
	ReferenceQuantity	ReferenceQuantity	Comm Refer Quantity
	FreeDefinedCurrency1	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	FiscalPeriod	FiscalPeriod	Tax period
	FiscalYearVariant	FiscalYearVariant	FY Variant
	FiscalYearPeriod		Period/Year
	ChartOfAccounts	ChartOfAccounts	Node Class
	Plant	Plant	Valuation Area
	PlantName	PlantName	Plant Name
	Customer	Customer	Sold-to Party
	CustomerName	CustomerName	Name of Customer
	ControllingDebitCreditCode
	Project	Project	WBS Element
	ProjectDescription	ProjectDescription	Project Name
	WBSElement	WBSElement	WBS Internal ID
	WBSElementDescription	WBSElementDescription	Description
	PartnerCompanyCode	PartnerCompanyCode	Partner Company Code
	PartnerCompanyCodeName	PartnerCompanyCodeName
	CostCtrActivityType	CostCtrActivityType	Activity Type
	CostCtrActivityTypeName	CostCtrActivityTypeName
	OrderID	OrderID	Order ID
	PartnerOrder	PartnerOrder	Partner Order
	PartnerCostCtrActivityType	PartnerCostCtrActivityType	Partner Cost Center Activity Type
	PartnerCostCtrActivityTypeName	PartnerCostCtrActivityTypeName
	PartnerProject	PartnerProject
	PartnerProjectDescription	PartnerProjectDescription
	PartnerWBSElement	PartnerWBSElement	WBS Element
	PartnerWBSElementDescription	PartnerWBSElementDescription
	SalesOrganization	SalesOrganization	Sales Organization
	SalesOrganizationName	SalesOrganizationName	Sales Organization Description
	DistributionChannel	DistributionChannel	RefDistCh-Cust/Mat.
	DistributionChannelName	DistributionChannelName
	Division	Division	Internal Division ID
	DivisionName	DivisionName	Division Description
	SoldMaterial	SoldMaterial	Product Sold
	SoldMaterialName	SoldMaterialName
	MaterialGroup	MaterialGroup	Product Group
	MaterialGroupName	MaterialGroupName	prod Grp Desc.
	CustomerGroup	CustomerGroup	Customer Group
	CustomerGroupName	CustomerGroupName
	CustomerSupplierCountry	CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierCountryName	CustomerSupplierCountryName
	CustomerSupplierIndustry	CustomerSupplierIndustry	Industry
	CustomerSupplierIndustryName	CustomerSupplierIndustryName
	SalesDistrict	SalesDistrict	Sales District
	SalesDistrictName	SalesDistrictName
	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
	SponsoredProgram	SponsoredProgram	Sponsored Program
	SponsoredClass	SponsoredClass	Sponsored Class
	GteeMBudgetValidityNumber	GteeMBudgetValidityNumber	Bdgt Validty No.
	REBusinessEntity	REBusinessEntity	RE Business Entity
	RealEstateBuilding	RealEstateBuilding	Building
	RealEstateProperty	RealEstateProperty	Land
	RERentalObject	RERentalObject
	RealEstateContract	RealEstateContract	Real Estate Contract
	REServiceChargeKey	REServiceChargeKey
	RESettlementUnitID	RESettlementUnitID
	SettlementReferenceDate	SettlementReferenceDate	Reference date

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 A_FinPlanEntryItemVariableFix.
-- 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: AFIFINPLANENTVF

CREATE VIEW A_FinPlanEntryItemVariableFix AS
SELECT
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  FinancialPlanningReqTransSqnc,
  FixedVariableType,
  Ledger,
  LedgerName,
  PlanningCategory,
  LedgerFiscalYear,
  GLAccount,
  GLAccountName,
  CompanyCode,
  CompanyCodeName,
  FinancialTransactionType,
  CostCenter,
  CostCenterName,
  ProfitCenter,
  ProfitCenterName,
  FunctionalArea,
  FunctionalAreaName,
  BusinessArea,
  BusinessAreaName,
  ControllingArea,
  ControllingAreaName,
  Segment,
  SegmentName,
  PartnerCostCenter,
  PartnerCostCenterName,
  PartnerProfitCenter,
  PartnerProfitCenterName,
  PartnerFunctionalArea,
  PartnerFunctionalAreaName,
  PartnerBusinessArea,
  PartnerBusinessAreaName,
  PartnerCompany,
  PartnerCompanyName,
  PartnerSegment,
  PartnerSegmentName,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  CostSourceUnit,
  ValuationQuantity,
  ReferenceQuantityUnit,
  ReferenceQuantity,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FiscalPeriod,
  FiscalYearVariant,
  cast( cast(FiscalYearPeriod as abap.char(7)) as fis_jahrper_c preserving type ) AS FiscalYearPeriod,
  ChartOfAccounts,
  Plant,
  PlantName,
  Customer,
  CustomerName,
  cast( I_FinPlanEntryItemVariableFix.ControllingDebitCreditCode as fins_co_belkz preserving type ) AS ControllingDebitCreditCode,
  Project,
  ProjectDescription,
  WBSElement,
  WBSElementDescription,
  PartnerCompanyCode,
  PartnerCompanyCodeName,
  CostCtrActivityType,
  CostCtrActivityTypeName,
  OrderID,
  PartnerOrder,
  PartnerCostCtrActivityType,
  PartnerCostCtrActivityTypeName,
  PartnerProject,
  PartnerProjectDescription,
  PartnerWBSElement,
  PartnerWBSElementDescription,
  SalesOrganization,
  SalesOrganizationName,
  DistributionChannel,
  DistributionChannelName,
  Division,
  DivisionName,
  SoldMaterial,
  SoldMaterialName,
  MaterialGroup,
  MaterialGroupName,
  CustomerGroup,
  CustomerGroupName,
  CustomerSupplierCountry,
  CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  CustomerSupplierIndustryName,
  SalesDistrict,
  SalesDistrictName,
  FinancialManagementArea,
  Fund,
  GrantID,
  BudgetPeriod,
  BudgetProcess,
  BudgetingType,
  SponsoredProgram,
  SponsoredClass,
  GteeMBudgetValidityNumber,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate
FROM I_FinPlanEntryItemVariableFix
LEFT OUTER JOIN E_FinancialPlanningEntryItem AS _Extension ON FinancialPlanningDataPacket = _Extension.FinancialPlanningDataPacket AND FinancialPlanningEntryItem = _Extension.FinancialPlanningEntryItem AND FinancialPlanningReqTransSqnc = _Extension.FinancialPlanningReqTransSqnc  -- association [1..1]
;

Depth:

A_FinPlanEntryItemVariableFix view

I_FinPlanEntryItemVariableFix view