C_RU_ImportNotifRegisterC

DDL: C_RU_IMPORTNOTIFREGISTERC SQL: CRURINCUBE Type: view CONSUMPTION
29 Fields 1 Data Sources 1 Associations

Register of Import Notifications Cube

C_RU_ImportNotifRegisterC is a Consumption CDS View (Cube) that provides data about "Register of Import Notifications Cube" in SAP S/4HANA. It reads from 1 data source (I_RU_ImportNotifRegRptItem) and exposes 29 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_RU_ImportNotifRegRptItem RegisterItems from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductDescription _MaterialDescription $projection.Material = _MaterialDescription.Product and _MaterialDescription.Language = $session.system_language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CRURINCUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
EndUserText.label Register of Import Notifications Cube view

Fields (29)

KeyFieldSource TableSource FieldDescription
VATReturnOperation VATReturnOperation Operation Code
CompanyCode TaxItem CompanyCode Receiver Company Code
TaxTransferDocument TaxItem AccountingDocument Journal Entry
FiscalYear TaxItem FiscalYear G/L Fiscal Year
TaxItem TaxItem TaxItem Tax Item
TaxCode TaxItem TaxCode Tax Code
RU_ImprtNotifExternalNumber INHeaderData RU_ImprtNotifExternalNumber
RU_ImprtNotifInternalNumber INHeaderData RU_ImprtNotifInternalNumber
RU_ImprtNotifRegistrationDate INHeaderData RU_ImprtNotifRegistrationDate
RU_ImportNotifSellerSection INHeaderData RU_ImportNotifSellerSection
AssignmentReference INHeaderData AssignmentReference Assignment Reference
ExternalContractNumber Contract ExternalContractNumber
ExternalContractDate Contract ExternalContractDate
Customer INHeaderData Customer Sold-to Party
CustomerName Customer CustomerName Name of Customer
RU_PartnerOrganizationINN Customer RU_PartnerOrganizationINN BP INN
AuthorizationGroup Customer AuthorizationGroup AuthorizGroup
CountryThreeDigitISOCode CustomerCountry CountryThreeDigitISOCode
RU_ImportNotificationItem INItemData RU_ImportNotificationItem
BillingDocument INItemData BillingDocument SD Document
BillingDocumentItem INItemData BillingDocumentItem Item
DeliveryDocument INItemData DeliveryDocument Outbound Delivery
DeliveryDocumentItem INItemData DeliveryDocumentItem Outb. Delivery Item
Material INItemData Material Vehicle Model
MaterialDesc _MaterialDescription ProductDescription Description
Quantity INItemData Quantity Value
UnitOfMeasure INItemData UnitOfMeasure Unit Protected Qty
TaxBaseAmountInCoCodeCrcy TaxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
CompanyCodeCurrency TaxItem CompanyCodeCurrency Local Currency

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 C_RU_ImportNotifRegisterC.
-- 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: CRURINCUBE
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_RU_ImportNotifRegisterC AS
SELECT
  VATReturnOperation,
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS TaxTransferDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxCode AS TaxCode,
  INHeaderData.RU_ImprtNotifExternalNumber AS RU_ImprtNotifExternalNumber,
  INHeaderData.RU_ImprtNotifInternalNumber AS RU_ImprtNotifInternalNumber,
  INHeaderData.RU_ImprtNotifRegistrationDate AS RU_ImprtNotifRegistrationDate,
  INHeaderData.RU_ImportNotifSellerSection AS RU_ImportNotifSellerSection,
  INHeaderData.AssignmentReference AS AssignmentReference,
  Contract.ExternalContractNumber AS ExternalContractNumber,
  Contract.ExternalContractDate AS ExternalContractDate,
  INHeaderData.Customer AS Customer,
  Customer.CustomerName AS CustomerName,
  Customer.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  Customer.AuthorizationGroup AS AuthorizationGroup,
  CustomerCountry.CountryThreeDigitISOCode AS CountryThreeDigitISOCode,
  INItemData.RU_ImportNotificationItem AS RU_ImportNotificationItem,
  INItemData.BillingDocument AS BillingDocument,
  INItemData.BillingDocumentItem AS BillingDocumentItem,
  INItemData.DeliveryDocument AS DeliveryDocument,
  INItemData.DeliveryDocumentItem AS DeliveryDocumentItem,
  INItemData.Material AS Material,
  _MaterialDescription.ProductDescription AS MaterialDesc,
  INItemData.Quantity AS Quantity,
  INItemData.UnitOfMeasure AS UnitOfMeasure,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_RU_ImportNotifRegRptItem AS RegisterItems
LEFT OUTER JOIN I_ProductDescription AS _MaterialDescription ON Material = _MaterialDescription.Product AND _MaterialDescription.Language = $session.system_language  -- association [0..1]
;

Learn More