P_GteeMIndrctCostLbltyActLItem

DDL: P_GTEEMINDRCTCOSTLBLTYACTLITEM SQL: PGMIDCLBLTYACTL Type: view COMPOSITE
202 Fields 2 Data Sources

P_GteeMIndrctCostLbltyActLItem is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PubSecCmtmtActlItemCube, P_GteeMIndrctCostLiabilityItem) and exposes 202 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
I_PubSecCmtmtActlItemCube I_PubSecCmtmtActlItemCube from
P_GteeMIndrctCostLiabilityItem P_GteeMIndrctCostLiabilityItem union_all

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PGMIDCLBLTYACTL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (202)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY SplitInformationSequenceNumber Sequence Number
LedgerFiscalYear LedgerFiscalYear
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant FiscalYearVariant FY Variant
LogicalSystem LogicalSystem Logical System
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
AccountingDocumentType AccountingDocumentType Journal Entry Type
SourceLogicalSystem SourceLogicalSystem
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt
SourceReferenceDocument SourceReferenceDocument Reference Doc.
SourceReferenceDocumentItem SourceReferenceDocumentItem Ref. Doc. Item
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
LastChangeDateTime LastChangeDateTime Timestamp
CreationDateTime CreationDateTime Timestamp
CreationDate CreationDate Time Stamp
PostingDate PostingDate Posting Date for GR
PubSecBudgetCnsmpnDate PubSecBudgetCnsmpnDate
ChartOfAccounts ChartOfAccounts Node Class
GLAccountType GLAccountType G/L Account Type
BusinessTransactionType BusinessTransactionType Bus.transaction
FinancialTransactionType FinancialTransactionType Transact. Type
ControllingArea ControllingArea Controlling Area
FinancialManagementArea FinancialManagementArea FM Area
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType Budget Consumption Type
GLAccount GLAccount General Ledger
GrantID GrantID Sender Grant
SponsoredProgram SponsoredProgram Sponsored Program
SponsoredClass SponsoredClass Sponsored Class
Fund Fund Sender Fund
BudgetPeriod BudgetPeriod Budget Period
FunctionalArea FunctionalArea Sendr Fctl Area
CostCenter CostCenter Cost Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProfitCenter ProfitCenter Profit Center
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
Product Product Product Sold
BusinessArea BusinessArea Business Area
OrderID OrderID Order ID
Segment Segment Segment number
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode Company Code for Budget Account
PubSecBudgetAccount PubSecBudgetAccount Budget Account
CashLedgerCompanyCode CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount CashLedgerAccount Cash Origin Account
TaxCode TaxCode Tax Code
DebitCreditCode DebitCreditCode Single-Character Flag
PostingKey PostingKey Posting Key
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
_Ledger _Ledger
_SourceLedger _SourceLedger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_FiscalYearVariant _FiscalYearVariant
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant
_ChartOfAccounts _ChartOfAccounts
_ControllingArea _ControllingArea
_FinancialTransactionType _FinancialTransactionType
_BusinessTransactionType _BusinessTransactionType
_AccountingDocumentType _AccountingDocumentType
_AccountingDocumentCategory _AccountingDocumentCategory
_GLAccountType _GLAccountType
_PubSecBdgtCnsmpnType _PubSecBdgtCnsmpnType
_FinancialManagementArea _FinancialManagementArea
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_GLAccountInCompanyCode _GLAccountInCompanyCode
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_FunctionalArea _FunctionalArea
_BusinessArea _BusinessArea
_Segment _Segment
_Order _Order
_WBSElementBasicData _WBSElementBasicData
_Fund _Fund
_BudgetPeriod _BudgetPeriod
_BudgetAccountInChtAccts _BudgetAccountInChtAccts
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_CashLedgerCompanyCode _CashLedgerCompanyCode
_CashLedgerAccount _CashLedgerAccount
_Product _Product
_Grant _Grant
_SponsoredProgram _SponsoredProgram
_SponsoredClass _SponsoredClass
_DebitCreditCode _DebitCreditCode
_PostingKey _PostingKey
_TransactionCurrency _TransactionCurrency
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem Journal Entry Item
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY SplitInformationSequenceNumber SplitInformationSequenceNumber Sequence Number
LedgerFiscalYear LedgerFiscalYear
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant FiscalYearVariant FY Variant
LogicalSystem LogicalSystem Logical System
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
AccountingDocumentType AccountingDocumentType Journal Entry Type
SourceLogicalSystem SourceLogicalSystem
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt
SourceReferenceDocument SourceReferenceDocument Reference Doc.
SourceReferenceDocumentItem SourceReferenceDocumentItem Ref. Doc. Item
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
LastChangeDateTime LastChangeDateTime Timestamp
CreationDateTime CreationDateTime Timestamp
CreationDate CreationDate Time Stamp
PostingDate PostingDate Posting Date for GR
PubSecBudgetCnsmpnDate PubSecBudgetCnsmpnDate
ChartOfAccounts ChartOfAccounts Node Class
GLAccountType GLAccountType G/L Account Type
BusinessTransactionType BusinessTransactionType Bus.transaction
FinancialTransactionType FinancialTransactionType Transact. Type
ControllingArea ControllingArea Controlling Area
FinancialManagementArea FinancialManagementArea FM Area
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType Budget Consumption Type
GLAccount GLAccount General Ledger
GrantID GrantID Sender Grant
SponsoredProgram SponsoredProgram Sponsored Program
SponsoredClass SponsoredClass Sponsored Class
Fund Fund Sender Fund
BudgetPeriod BudgetPeriod Budget Period
FunctionalArea FunctionalArea Sendr Fctl Area
CostCenter CostCenter Cost Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProfitCenter ProfitCenter Profit Center
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
Product Product Product Sold
BusinessArea BusinessArea Business Area
OrderID OrderID Order ID
Segment Segment Segment number
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode Company Code for Budget Account
PubSecBudgetAccount PubSecBudgetAccount Budget Account
CashLedgerCompanyCode CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount CashLedgerAccount Cash Origin Account
TaxCode TaxCode Tax Code
DebitCreditCode DebitCreditCode Single-Character Flag
PostingKey PostingKey Posting Key
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
_Ledger _Ledger
_SourceLedger _SourceLedger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_FiscalYearVariant _FiscalYearVariant
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant
_ChartOfAccounts _ChartOfAccounts
_ControllingArea _ControllingArea
_FinancialTransactionType _FinancialTransactionType
_BusinessTransactionType _BusinessTransactionType
_AccountingDocumentType _AccountingDocumentType
_AccountingDocumentCategory _AccountingDocumentCategory
_GLAccountType _GLAccountType
_PubSecBdgtCnsmpnType _PubSecBdgtCnsmpnType
_FinancialManagementArea _FinancialManagementArea
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_GLAccountInCompanyCode _GLAccountInCompanyCode
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_FunctionalArea _FunctionalArea
_BusinessArea _BusinessArea
_Segment _Segment
_Order _Order
_WBSElementBasicData _WBSElementBasicData
_Fund _Fund
_BudgetPeriod _BudgetPeriod
_BudgetAccountInChtAccts _BudgetAccountInChtAccts
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_CashLedgerCompanyCode _CashLedgerCompanyCode
_CashLedgerAccount _CashLedgerAccount
_Product _Product
_Grant _Grant
_SponsoredProgram _SponsoredProgram
_SponsoredClass _SponsoredClass
_DebitCreditCode _DebitCreditCode
_PostingKey _PostingKey
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency

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_GteeMIndrctCostLbltyActLItem.
-- 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: PGMIDCLBLTYACTL

CREATE VIEW P_GteeMIndrctCostLbltyActLItem AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  cast ( '' as fagl_index ) AS SplitInformationSequenceNumber,
  LedgerFiscalYear,
  FiscalYearPeriod,
  FiscalYearVariant,
  LogicalSystem,
  AccountingDocumentCategory,
  AccountingDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  IsReversal,
  IsReversed,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  CreationDate,
  PostingDate,
  PubSecBudgetCnsmpnDate,
  ChartOfAccounts,
  GLAccountType,
  BusinessTransactionType,
  FinancialTransactionType,
  ControllingArea,
  FinancialManagementArea,
  PubSecBudgetCnsmpnType,
  GLAccount,
  GrantID,
  SponsoredProgram,
  SponsoredClass,
  Fund,
  BudgetPeriod,
  FunctionalArea,
  CostCenter,
  WBSElementInternalID,
  ProfitCenter,
  MasterFixedAsset,
  FixedAsset,
  Product,
  BusinessArea,
  OrderID,
  Segment,
  PubSecBudgetAccountCoCode,
  PubSecBudgetAccount,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  TaxCode,
  DebitCreditCode,
  PostingKey,
  AmountInTransactionCurrency,
  TransactionCurrency,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency
FROM I_PubSecCmtmtActlItemCube
-- UNION ALL with additional select branch(es): P_GteeMIndrctCostLiabilityItem
;

Learn More