Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_MY_BillingDocumentItemCube

DDL: I_MY_BILLINGDOCUMENTITEMCUBE SQL: IMYBILLGDOCCUBE Type: view COMPOSITE
34 Fields 1 Data Sources 4 Associations

Billing Document Item Cube for MY GAF

I_MY_BillingDocumentItemCube is a Composite CDS View (Cube) that provides data about "Billing Document Item Cube for MY GAF" in SAP S/4HANA. It reads from 1 data source (P_MY_BillingDocItmWthTaxAmt) and exposes 34 fields with key fields CompanyCode, BillingDocument, BillingDocumentItem, TaxItemGroupingVersion, TaxCode. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_MY_BillingDocItmWthTaxAmt P_MY_BillingDocItmWthTaxAmt from

Parameters (1)

NameTypeDefault
P_RelevantAmountPosition relevantamountposition

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_Currency _ReportingCurrency $projection.ReportingCurrency = _ReportingCurrency.Currency
[0..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency
[0..1] I_Currency _DocumentCurrency $projection.DocumentCurrency = _DocumentCurrency.Currency

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMYBILLGDOCCUBE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label Billing Document Item Cube for MY GAF view
Metadata.allowExtensions true view
VDM.lifecycle.status #DEPRECATED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY BillingDocument BillingDocument SD Document
KEY BillingDocumentItem BillingDocumentItem Item
KEY TaxItemGroupingVersion Tax Grping Ver.
KEY TaxCode TaxCode Tax Code
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY DebitCreditCode DebitCreditCode Single-Character Flag
PostingDate PostingDate Posting Date for GR
TaxReportingDate TaxReportingDate Tax Reporting Date
ReportingDate ReportingDate
ExchangeRate ExchangeRate Exchange rate
CustomerName CustomerName Name of Customer
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
CustomerSupplierAddress CustomerSupplierAddress
VATRegistration VATRegistration VAT Registration No.
ReportingCountry ReportingCountry
TaxNumber1 TaxNumber1 VAT Reg. No.
OrganizationBPName4 Name 4
AuthorizationGroup AuthorizationGroup AuthorizGroup
BillingDocumentDate BillingDocumentDate Billing Date
BillingDocumentItemText BillingDocumentItemText Item Descr.
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ReportingCurrency ReportingCurrency Currency
MY_IndustryCode MY_IndustryCode
CountryName CountryName Country
TransactionCurrency Transaction Currency
DocumentCurrency DocumentCurrency Document Currency
ItemNetAmount ItemNetAmount Tot. val. rel.
TaxAmountInAdditionalCurrency1 _Bill TaxAmountInAdditionalCurrency1 LC 2 Tax
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
_CompanyCodeCurrency _CompanyCodeCurrency
_ReportingCurrency _ReportingCurrency
_TransactionCurrency _TransactionCurrency
_DocumentCurrency _DocumentCurrency

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_MY_BillingDocumentItemCube.
-- 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: IMYBILLGDOCCUBE
-- Parameters: P_RelevantAmountPosition : relevantamountposition

CREATE VIEW I_MY_BillingDocumentItemCube AS
SELECT
  CompanyCode,
  BillingDocument,
  BillingDocumentItem,
  cast(TaxItemGroupingVersion as verstax) AS TaxItemGroupingVersion,
  TaxCode,
  TransactionTypeDetermination,
  DebitCreditCode,
  PostingDate,
  TaxReportingDate,
  ReportingDate,
  ExchangeRate,
  CustomerName,
  BusinessPartnerCountry,
  CustomerSupplierAddress,
  VATRegistration,
  ReportingCountry,
  TaxNumber1,
  cast(OrganizationBPName4 as fiph_brn2) AS OrganizationBPName4,
  AuthorizationGroup,
  BillingDocumentDate,
  BillingDocumentItemText,
  CompanyCodeCurrency,
  ReportingCurrency,
  MY_IndustryCode,
  CountryName,
  cast(TransactionCurrency as j_3r_for_cur) AS TransactionCurrency,
  DocumentCurrency,
  ItemNetAmount,
  _Bill.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  AccountingDocumentHeaderText
FROM P_MY_BillingDocItmWthTaxAmt
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
;

Learn More