P_PlanLineItemSemTagGLAcc

DDL: P_PLANLINEITEMSEMTAGGLACC SQL: PFIPLANLITSTGL Type: view COMPOSITE Package: FINS_FI_SEM_TAG
209 Fields 2 Data Sources 2 Associations

Plan Line Item with Semantic Tag for G/L Acc

P_PlanLineItemSemTagGLAcc is a Composite CDS View that provides data about "Plan Line Item with Semantic Tag for G/L Acc" in SAP S/4HANA. It reads from 2 data sources (I_FinancialPlanningEntryItem, I_SemTagGLAccount) and exposes 209 fields with key fields FinancialPlanningReqTransSqnc, FinancialPlanningDataPacket, FinancialPlanningEntryItem, GLAccountHierarchy, SemanticTag. It has 2 associations to related views. Part of development package FINS_FI_SEM_TAG.

Data Sources (2)

SourceAliasJoin Type
I_FinancialPlanningEntryItem I_FinancialPlanningEntryItem from
I_SemTagGLAccount I_SemTagGLAccount inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SemanticTag _SemanticTag $projection.SemanticTag = _SemanticTag.SemanticTag
[0..*] I_GLAccountHierarchy _Hierarchy $projection.GLAccountHierarchy = _Hierarchy.GLAccountHierarchy

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIPLANLITSTGL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (209)

KeyFieldSource TableSource FieldDescription
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem Object GUID
KEY GLAccountHierarchy I_SemTagGLAccount GLAccountHierarchy
KEY SemanticTag I_SemTagGLAccount SemanticTag Semantic Tag
KEY ValidityStartDate I_SemTagGLAccount ValidityStartDate Validity Start Date
KEY ValidityEndDate I_SemTagGLAccount ValidityEndDate ValidTo
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
Ledger Ledger Ledger
GLAccount I_FinancialPlanningEntryItem GLAccount General Ledger
ChartOfAccounts I_FinancialPlanningEntryItem ChartOfAccounts Node Class
FiscalYear FiscalYear G/L Fiscal Year
LedgerFiscalYear LedgerFiscalYear Ref. Year1
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
Project Project WBS Element
ProjectInternalID ProjectInternalID Project Def.
PartnerProjectInternalID PartnerProjectInternalID Partner Project Def.
WBSElement WBSElement WBS Internal ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
PartnerWBSElementInternalID PartnerWBSElementInternalID Partner WBS Element Internal ID
FunctionalArea FunctionalArea Sendr Fctl Area
Segment Segment Segment number
CostCtrActivityType CostCtrActivityType Activity Type
CostAnalysisResource CostAnalysisResource Resource
WorkPackage WorkPackage Plan Item
WorkItem WorkItem Work Item ID
BillableControl BillableControl Billable Control
IsLotSizeIndependent IsLotSizeIndependent LotSzIndep.Ind.
PartnerCompanyCode PartnerCompanyCode Partner Company Code
OriginCostCtrActivityType OriginCostCtrActivityType OrigAct.
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
PartnerSegment PartnerSegment Partner Segment
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerProject PartnerProject Part. Proj. Def
PartnerWBSElement PartnerWBSElement WBS Element
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
OrderID OrderID Order ID
PartnerOrder PartnerOrder Partner Order
PartnerOrder_2 PartnerOrder_2
PartnerCompany PartnerCompany Trading Partner
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocument ReferenceDocument Reference Document
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
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
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
FunctionalCurrency FunctionalCurrency Functional Currency
AmountInFunctionalCurrency AmountInFunctionalCurrency Amount in Functional Currency
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy Fixed Amnt in GC
CostSourceUnit CostSourceUnit Valuation UoM
ValuationQuantity ValuationQuantity Val. quantity
FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant FiscalYearVariant FY Variant
PostingDate PostingDate Posting Date for GR
SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
Plant Plant Valuation Area
Material Material Vehicle Model
Customer Customer Sold-to Party
PlanningCategory PlanningCategory Plan Category
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
PersonnelNumber PersonnelNumber Personnel No.
IsStatisticalOrder IsStatisticalOrder Statistical Order
IsStatisticalCostCenter IsStatisticalCostCenter Cost Center Is Stat.
IsStatisticalSalesDocument IsStatisticalSalesDocument
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
BillingDocumentType BillingDocumentType Billing Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
OrganizationDivision OrganizationDivision Org. Division
SoldMaterial SoldMaterial Product Sold
SoldProduct SoldProduct Product Sold
MaterialGroup MaterialGroup Product Group
ProductGroup ProductGroup Product Sold 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
AssetClass AssetClass Asset Class
_Ledger _Ledger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_LedgerFiscalYear _LedgerFiscalYear
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_FiscalPeriod _FiscalPeriod
_FiscalPeriodForVariant _FiscalPeriodForVariant
_SubLedgerAccLineItemType _SubLedgerAccLineItemType
_FiscalYearVariant _FiscalYearVariant
_CalendarDate _CalendarDate
_FiscalCalendarDate _FiscalCalendarDate
_ControllingArea _ControllingArea
_GLAccountInCompanyCode _GLAccountInCompanyCode
_GLAccountInChartOfAccounts I_FinancialPlanningEntryItem _GLAccountInChartOfAccounts
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_FreeDefinedCurrency1 _FreeDefinedCurrency1
_FreeDefinedCurrency2 _FreeDefinedCurrency2
_FreeDefinedCurrency3 _FreeDefinedCurrency3
_FreeDefinedCurrency4 _FreeDefinedCurrency4
_FreeDefinedCurrency5 _FreeDefinedCurrency5
_FreeDefinedCurrency6 _FreeDefinedCurrency6
_FreeDefinedCurrency7 _FreeDefinedCurrency7
_FreeDefinedCurrency8 _FreeDefinedCurrency8
_ControllingObjectCurrency _ControllingObjectCurrency
_FunctionalCurrency _FunctionalCurrency
_CostSourceUnit _CostSourceUnit
_Segment _Segment
_ProfitCenter _ProfitCenter
_CurrentProfitCenter _CurrentProfitCenter
_CostCenter _CostCenter
_CurrentCostCenter _CurrentCostCenter
_BusinessArea _BusinessArea
_FunctionalArea I_FinancialPlanningEntryItem _FunctionalArea
_WBSElement _WBSElement
_WBSElementByInternalKey _WBSElementByInternalKey
_WBSElementBasicData _WBSElementBasicData
_PartnerWBSElementBasicData _PartnerWBSElementBasicData
_Project _Project
_ProjectBasicData _ProjectBasicData
_PartnerProjectBasicData _PartnerProjectBasicData
_CostCtrActivityType _CostCtrActivityType
_CostAnalysisResource _CostAnalysisResource
_WorkPackageWorkItem _WorkPackageWorkItem
_WorkPackage _WorkPackage
_InternalOrder _InternalOrder
_Order _Order
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_PartnerCompany _PartnerCompany
_PartnerCompanyCode _PartnerCompanyCode
_OriginCostCtrActivityType _OriginCostCtrActivityType
_PartnerSegment _PartnerSegment
_PartnerProfitCenter _PartnerProfitCenter
_PartnerCostCenter _PartnerCostCenter
_PartnerBusinessArea _PartnerBusinessArea
_PartnerFunctionalArea _PartnerFunctionalArea
_PartnerWBSElement _PartnerWBSElement
_PartnerProject _PartnerProject
_PartnerCostCtrActivityType _PartnerCostCtrActivityType
_PartnerOrder _PartnerOrder
_PartnerOrder_2 _PartnerOrder_2
_ChartOfAccounts I_FinancialPlanningEntryItem _ChartOfAccounts
_ControllingDebitCreditCode _ControllingDebitCreditCode
_Employment _Employment
_Customer _Customer
_CustomerGroup _CustomerGroup
_Material _Material
_MaterialGroup _MaterialGroup
_ProductGroup _ProductGroup
_Plant _Plant
_BillingDocumentType _BillingDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SoldMaterial _SoldMaterial
_SoldProduct _SoldProduct
_CustomerSupplierCountry _CustomerSupplierCountry
_SalesDistrict _SalesDistrict
_BillToParty _BillToParty
_ShipToParty _ShipToParty
_PlanningCategory _PlanningCategory
_SemanticTag _SemanticTag
_Hierarchy _Hierarchy
GLAccountAuthorizationGroup GLAccountAuthorizationGroup
CustomerBasicAuthorizationGrp CustomerBasicAuthorizationGrp
OrderType OrderType Order Type
SalesOrderType SalesOrderType Sales Order Type
AssetDepreciationArea AssetDepreciationArea Deprec. Area
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.

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 P_PlanLineItemSemTagGLAcc.
-- 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: PFIPLANLITSTGL

CREATE VIEW P_PlanLineItemSemTagGLAcc AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  I_SemTagGLAccount.GLAccountHierarchy AS GLAccountHierarchy,
  I_SemTagGLAccount.SemanticTag AS SemanticTag,
  I_SemTagGLAccount.ValidityStartDate AS ValidityStartDate,
  I_SemTagGLAccount.ValidityEndDate AS ValidityEndDate,
  ControllingArea,
  CompanyCode,
  Ledger,
  I_FinancialPlanningEntryItem.GLAccount AS GLAccount,
  I_FinancialPlanningEntryItem.ChartOfAccounts AS ChartOfAccounts,
  FiscalYear,
  LedgerFiscalYear,
  BusinessArea,
  ProfitCenter,
  CostCenter,
  Project,
  ProjectInternalID,
  PartnerProjectInternalID,
  WBSElement,
  WBSElementInternalID,
  PartnerWBSElementInternalID,
  FunctionalArea,
  Segment,
  CostCtrActivityType,
  CostAnalysisResource,
  WorkPackage,
  WorkItem,
  BillableControl,
  IsLotSizeIndependent,
  PartnerCompanyCode,
  OriginCostCtrActivityType,
  PartnerBusinessArea,
  PartnerSegment,
  PartnerProfitCenter,
  PartnerCostCenter,
  PartnerProject,
  PartnerWBSElement,
  PartnerFunctionalArea,
  PartnerCostCtrActivityType,
  OrderID,
  PartnerOrder,
  PartnerOrder_2,
  PartnerCompany,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReferenceDocument,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  FixedAmountInGlobalCrcy,
  CostSourceUnit,
  ValuationQuantity,
  FiscalPeriod,
  FiscalYearPeriod,
  FiscalYearVariant,
  PostingDate,
  SubLedgerAcctLineItemType,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  Plant,
  Material,
  Customer,
  PlanningCategory,
  AccountAssignmentType,
  ControllingDebitCreditCode,
  PersonnelNumber,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  Division,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  MaterialGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  AssetClass,
  I_FinancialPlanningEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_FinancialPlanningEntryItem._FunctionalArea AS _FunctionalArea,
  I_FinancialPlanningEntryItem._ChartOfAccounts AS _ChartOfAccounts,
  GLAccountAuthorizationGroup,
  CustomerBasicAuthorizationGrp,
  OrderType,
  SalesOrderType,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetAcctTransClassfctn
FROM I_FinancialPlanningEntryItem
INNER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SemanticTag AS _SemanticTag ON SemanticTag = _SemanticTag.SemanticTag  -- association [0..1]
LEFT OUTER JOIN I_GLAccountHierarchy AS _Hierarchy ON GLAccountHierarchy = _Hierarchy.GLAccountHierarchy  -- association [0..*]
;

Learn More