P_GrssMargPlanLineItemSemTag_2

DDL: P_GRSSMARGPLANLINEITEMSEMTAG_2 Type: view_entity COMPOSITE Package: ODATA_GROSSMARGIN
183 Fields 1 Data Sources

Gross Margin Plan Item Sem Tag

P_GrssMargPlanLineItemSemTag_2 is a Composite CDS View that provides data about "Gross Margin Plan Item Sem Tag" in SAP S/4HANA. It reads from 1 data source (P_GrssMargPlnItemSemTagUnion) and exposes 183 fields with key fields FinancialPlanningReqTransSqnc, FinancialPlanningDataPacket, FinancialPlanningEntryItem, GLAccountHierarchy, SemanticTag. Part of development package ODATA_GROSSMARGIN.

Data Sources (1)

SourceAliasJoin Type
P_GrssMargPlnItemSemTagUnion P_GrssMargPlnItemSemTagUnion from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Gross Margin Plan Item Sem Tag view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (183)

KeyFieldSource TableSource FieldDescription
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem
KEY GLAccountHierarchy GLAccountHierarchy
KEY SemanticTag SemanticTag Semantic Tag
KEY ValidityStartDate ValidityStartDate Validity Start Date
KEY ValidityEndDate ValidityEndDate ValidTo
IsFunctionalAreaPermitted IsFunctionalAreaPermitted
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
Ledger Ledger Ledger
GLAccount GLAccount General Ledger
ChartOfAccounts ChartOfAccounts Node Class
FiscalYear FiscalYear G/L Fiscal Year
LedgerFiscalYear LedgerFiscalYear
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
ProjectInternalID ProjectInternalID Project Def.
PartnerProjectInternalID PartnerProjectInternalID
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
WorkPackage WorkPackage Plan Item
WorkItem WorkItem Work Item ID
BillableControl BillableControl Billable Control
IsLotSizeIndependent IsLotSizeIndependent
PartnerCompanyCode PartnerCompanyCode Partner Company Code
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
PartnerSegment PartnerSegment Partner Segment
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
OrderID OrderID Order ID
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
CostSourceUnit CostSourceUnit
ValuationQuantity ValuationQuantity
FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant FiscalYearVariant FY Variant
PostingDate PostingDate Posting Date for GR
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
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
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
AssetDepreciationArea AssetDepreciationArea Deprec. Area
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.
AssetClass AssetClass Asset Class
_Ledger _Ledger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_LedgerFiscalYear _LedgerFiscalYear
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_FiscalPeriod _FiscalPeriod
_FiscalPeriodForVariant _FiscalPeriodForVariant
_FiscalYearVariant _FiscalYearVariant
_CalendarDate _CalendarDate
_FiscalCalendarDate _FiscalCalendarDate
_ControllingArea _ControllingArea
_GLAccountInCompanyCode _GLAccountInCompanyCode
_GLAccountInChartOfAccounts _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
_CostSourceUnit _CostSourceUnit
_Segment _Segment
_ProfitCenter _ProfitCenter
_CurrentProfitCenter _CurrentProfitCenter
_CostCenter _CostCenter
_CurrentCostCenter _CurrentCostCenter
_BusinessArea _BusinessArea
_FunctionalArea _FunctionalArea
_WBSElementByInternalKey _WBSElementByInternalKey
_WBSElementBasicData _WBSElementBasicData
_PartnerWBSElementBasicData _PartnerWBSElementBasicData
_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
_PartnerSegment _PartnerSegment
_PartnerProfitCenter _PartnerProfitCenter
_PartnerCostCenter _PartnerCostCenter
_PartnerBusinessArea _PartnerBusinessArea
_PartnerFunctionalArea _PartnerFunctionalArea
_PartnerCostCtrActivityType _PartnerCostCtrActivityType
_PartnerOrder_2 _PartnerOrder_2
_ChartOfAccounts _ChartOfAccounts
_ControllingDebitCreditCode _ControllingDebitCreditCode
_Customer _Customer
_CustomerGroup _CustomerGroup
_Material _Material
_MaterialGroup _MaterialGroup
_ProductGroup _ProductGroup
_Plant _Plant
_BillingDocumentType _BillingDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SoldMaterial _SoldMaterial
_CustomerSupplierCountry _CustomerSupplierCountry
_SalesDistrict _SalesDistrict
_BillToParty _BillToParty
_ShipToParty _ShipToParty
_PlanningCategory _PlanningCategory
_SemanticTag _SemanticTag

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_GrssMargPlanLineItemSemTag_2.
-- 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.

CREATE VIEW P_GrssMargPlanLineItemSemTag_2 AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  IsFunctionalAreaPermitted,
  ControllingArea,
  CompanyCode,
  Ledger,
  GLAccount,
  ChartOfAccounts,
  FiscalYear,
  LedgerFiscalYear,
  BusinessArea,
  ProfitCenter,
  CostCenter,
  ProjectInternalID,
  PartnerProjectInternalID,
  WBSElementInternalID,
  PartnerWBSElementInternalID,
  FunctionalArea,
  Segment,
  CostCtrActivityType,
  CostAnalysisResource,
  WorkPackage,
  WorkItem,
  BillableControl,
  IsLotSizeIndependent,
  PartnerCompanyCode,
  PartnerBusinessArea,
  PartnerSegment,
  PartnerProfitCenter,
  PartnerCostCenter,
  PartnerFunctionalArea,
  PartnerCostCtrActivityType,
  OrderID,
  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,
  CostSourceUnit,
  ValuationQuantity,
  FiscalPeriod,
  FiscalYearPeriod,
  FiscalYearVariant,
  PostingDate,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  Plant,
  Material,
  Customer,
  PlanningCategory,
  AccountAssignmentType,
  ControllingDebitCreditCode,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  Division,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetAcctTransClassfctn,
  AssetClass
FROM P_GrssMargPlnItemSemTagUnion
;

Learn More