I_IntcoBillgTrackerForCtrlgC

DDL: I_INTCOBILLGTRACKERFORCTRLGC Type: view_entity COMPOSITE Package: FIN_CO_ICO_BILLING_TRACKER
79 Fields 2 Associations

Intercompany Billing Tracker - Cube

I_IntcoBillgTrackerForCtrlgC is a Composite CDS View (Cube) that provides data about "Intercompany Billing Tracker - Cube" in SAP S/4HANA. It has 2 associations to related views. Part of development package FIN_CO_ICO_BILLING_TRACKER.

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_IntcoBillingStatusText _BillingStatusText $projection.InvoiceStatus = _BillingStatusText.InvoiceStatus
[0..1] I_BillingDocumentItem _BillingDocumentItem $projection.BillingDocument = _BillingDocumentItem.BillingDocument and $projection.BillingDocumentItem = _BillingDocumentItem.BillingDocumentItem

Annotations (12)

NameValueLevelField
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Intercompany Billing Tracker - Cube view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument AccountingDocument Journal Entry
_JournalEntry _JournalEntry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY CompanyCode CompanyCode Receiver Company Code
_CompanyCode _CompanyCode
KEY FiscalYear FiscalYear G/L Fiscal Year
_FiscalYear _FiscalYear
KEY ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID PBE Entry UUID
KEY Ledger Ledger Ledger
Quantity Quantity Value
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
BaseUnit BaseUnit Unit of Measure
Material Material Vehicle Model
BillingDate BillingDate Billing Date
BillingDocument BillingDocument SD Document
_BillingDocument _BillingDocument
BillingDocumentRequest BillingDocumentRequest
CombinedCompanyCode CombinedCompanyCode
PersonnelNumber PersonnelNumber Personnel No.
_PersonWorkAgreement _PersonWorkAgreement
FunctionalArea FunctionalArea Sendr Fctl Area
GLAccount GLAccount General Ledger
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
SalesDocument SalesDocument SD Document
_SalesOrder _SalesOrder
InvoiceStatusText
InvoiceStatus InvoiceStatus
BillingDocumentItem BillingDocumentItem Item
_BillingDocumentItem _BillingDocumentItem
BillingDocumentItemText BillingDocumentItemText Item Descr.
RECEIVERDATAFiscalPeriod
_FiscalPeriodForVariant _FiscalPeriodForVariant
PostingDate PostingDate Posting Date for GR
ProjectBillingRequest ProjectBillingRequest PBR
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
ProfitCenter ProfitCenter Profit Center
ProjectExternalID ProjectExternalID Project def.
_ProjectByExternalID _ProjectByExternalID
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentType ServiceDocumentType Transaction Type
WBSElementExternalID WBSElementExternalID WBS Element External ID
_WBSElementByExternalID _WBSElementByExternalID
ReferenceDocument ReferenceDocument Reference Document
SENDERDATAPartnerCompanyCode
_PartnerCompanyCode _PartnerCompanyCode
SenderCompanyCode SenderCompanyCode Sender Company Code
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
SenderJournalEntry SenderJournalEntry
SenderJournalEntryItem SenderJournalEntryItem
SenderFiscalYear SenderFiscalYear Sender FiscalYr
_SenderFiscalYear _SenderFiscalYear
PartnerFiscalYear PartnerFiscalYear
SenderFiscalPeriod SenderFiscalPeriod
SenderLedgerFiscalYear SenderLedgerFiscalYear
SenderFiscalYearVariant SenderFiscalYearVariant
SenderPostingDate SenderPostingDate
SenderProfitAndLossAccount SenderProfitAndLossAccount
SenderChartOfAccounts SenderChartOfAccounts
SenderProfitCenter SenderProfitCenter
PartnerProfitCenter PartnerProfitCenter Profit Center
ReceiverJournalEntry ReceiverJournalEntry
ReceiverJournalEntryItem ReceiverJournalEntryItem
ReceiverProfitAndLossAccount ReceiverProfitAndLossAccount
WBSElementInternalID WBSElementInternalID WBS Internal ID
FiscalYearVariant FiscalYearVariant FY Variant
_FiscalYearVariant _FiscalYearVariant
LedgerFiscalYear LedgerFiscalYear
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
ProjectInternalID ProjectInternalID Project Def.
CostCenter CostCenter Cost Center
_CostCenter _CostCenter
ControllingArea ControllingArea Controlling Area
_ControllingArea _ControllingArea
ChartOfAccounts ChartOfAccounts Node Class
_ChartOfAccounts _ChartOfAccounts

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 I_IntcoBillgTrackerForCtrlgC.
-- 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 I_IntcoBillgTrackerForCtrlgC AS
SELECT
  AccountingDocument,
  LedgerGLLineItem,
  CompanyCode,
  FiscalYear,
  ProjBillgElmntEntrItmUUID,
  Ledger,
  Quantity,
  AmountInTransactionCurrency,
  TransactionCurrency,
  AmountInGlobalCurrency,
  GlobalCurrency,
  PartnerCostCtrActivityType,
  BaseUnit,
  Material,
  BillingDate,
  BillingDocument,
  BillingDocumentRequest,
  CombinedCompanyCode,
  PersonnelNumber,
  FunctionalArea,
  GLAccount,
  SalesDocument,
  _BillingStatusText[1:Language = $session.system_language].InvoiceStatusText AS InvoiceStatusText,
  InvoiceStatus,
  BillingDocumentItem,
  BillingDocumentItemText,
  PostingDate,
  ProjectBillingRequest,
  AccountAssignmentType,
  ProfitCenter,
  ProjectExternalID,
  ServiceDocument,
  ServiceDocumentType,
  WBSElementExternalID,
  ReferenceDocument,
  SenderCompanyCode,
  PartnerCostCenter,
  SenderJournalEntry,
  SenderJournalEntryItem,
  SenderFiscalYear,
  PartnerFiscalYear,
  SenderFiscalPeriod,
  SenderLedgerFiscalYear,
  SenderFiscalYearVariant,
  SenderPostingDate,
  SenderProfitAndLossAccount,
  SenderChartOfAccounts,
  SenderProfitCenter,
  PartnerProfitCenter,
  ReceiverJournalEntry,
  ReceiverJournalEntryItem,
  ReceiverProfitAndLossAccount,
  WBSElementInternalID,
  FiscalYearVariant,
  LedgerFiscalYear,
  ProjectInternalID,
  CostCenter,
  ControllingArea,
  ChartOfAccounts
LEFT OUTER JOIN I_IntcoBillingStatusText AS _BillingStatusText ON InvoiceStatus = _BillingStatusText.InvoiceStatus  -- association [0..*]
LEFT OUTER JOIN I_BillingDocumentItem AS _BillingDocumentItem ON BillingDocument = _BillingDocumentItem.BillingDocument AND BillingDocumentItem = _BillingDocumentItem.BillingDocumentItem  -- association [0..1]
;

Learn More