C_RU_ImportNotificationHdrTP

DDL: C_RU_IMPORTNOTIFICATIONHDRTP Type: view_entity CONSUMPTION
60 Fields 1 Data Sources

C_RU_ImportNotificationHdrTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (R_RU_ImportNotificationHdrTP) and exposes 60 fields with key field RU_ImprtNotifInternalNumber.

Data Sources (1)

SourceAliasJoin Type
R_RU_ImportNotificationHdrTP R_RU_ImportNotificationHdrTP projection

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY RU_ImprtNotifInternalNumber RU_ImprtNotifInternalNumber
RU_ImprtNotifExternalNumber RU_ImprtNotifExternalNumber
RU_ImprtNotifRegistrationDate RU_ImprtNotifRegistrationDate
ExportConfirmationDate ExportConfirmationDate
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
Customer Customer Sold-to Party
RU_CustomerINN RU_CustomerINN
CustomerName CustomerName Name of Customer
CustomerCountry CustomerCountry
CustomerAuthznGrp CustomerAuthznGrp
CustomerAccountGroup CustomerAccountGroup Account group
CustomerIsBusPrpsCmpltd CustomerIsBusPrpsCmpltd
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup Authorization
CustCoIsBusPrpsCmpltd CustCoIsBusPrpsCmpltd
ConsigneeAuthorizationGroup ConsigneeAuthorizationGroup
ConsigneeAccountGroup ConsigneeAccountGroup
ConsigneeIsBusPrpsCmpltd ConsigneeIsBusPrpsCmpltd
Consignee Consignee Customer
RU_AgentOrganizationINN RU_AgentOrganizationINN Agent INN
ConsigneeName ConsigneeName
ConsigneeCountry ConsigneeCountry
AssignmentReference AssignmentReference Assignment Reference
ExternalContractNumber ExternalContractNumber
ExternalContractDate ExternalContractDate
RU_ImportNotifSellerSection RU_ImportNotifSellerSection
RU_ImportNotificationIsMock RU_ImportNotificationIsMock
RU_ImportNotifHasFollowUpDoc RU_ImportNotifHasFollowUpDoc
RU_LateExportConfStatus RU_LateExportConfStatus
CreatedByUserName CreatedByUserName Person Resp.
CreationDateTime CreationDateTime Timestamp
LastChangedByUserName LastChangedByUserName User Name
ChangedDateTime ChangedDateTime Time Stamp
virtualBillingDocumentvbeln_vf
virtualDeliveryDocumentvbeln_vl
virtualIssueDatej_3rs_imnt_issue_date
virtualMaterialmatnr
BP1DataControllerSet BP1DataControllerSet
BP1DataController1 BP1DataController1
BP1DataController2 BP1DataController2
BP1DataController3 BP1DataController3
BP1DataController4 BP1DataController4
BP1DataController5 BP1DataController5
BP1DataController6 BP1DataController6
BP1DataController7 BP1DataController7
BP1DataController8 BP1DataController8
BP1DataController9 BP1DataController9
BP1DataController10 BP1DataController10
BP2DataControllerSet BP2DataControllerSet
BP2DataController1 BP2DataController1
BP2DataController2 BP2DataController2
BP2DataController3 BP2DataController3
BP2DataController4 BP2DataController4
BP2DataController5 BP2DataController5
BP2DataController6 BP2DataController6
BP2DataController7 BP2DataController7
BP2DataController8 BP2DataController8
BP2DataController9 BP2DataController9
BP2DataController10 BP2DataController10

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_ImportNotificationHdrTP.
-- 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 C_RU_ImportNotificationHdrTP AS
SELECT
  RU_ImprtNotifInternalNumber,
  RU_ImprtNotifExternalNumber,
  RU_ImprtNotifRegistrationDate,
  ExportConfirmationDate,
  CompanyCode,
  CompanyCodeName,
  CompanyCodeCountry,
  Customer,
  RU_CustomerINN,
  CustomerName,
  CustomerCountry,
  CustomerAuthznGrp,
  CustomerAccountGroup,
  CustomerIsBusPrpsCmpltd,
  CustomerCompanyAuthznGroup,
  CustCoIsBusPrpsCmpltd,
  ConsigneeAuthorizationGroup,
  ConsigneeAccountGroup,
  ConsigneeIsBusPrpsCmpltd,
  Consignee,
  RU_AgentOrganizationINN,
  ConsigneeName,
  ConsigneeCountry,
  AssignmentReference,
  ExternalContractNumber,
  ExternalContractDate,
  RU_ImportNotifSellerSection,
  RU_ImportNotificationIsMock,
  RU_ImportNotifHasFollowUpDoc,
  RU_LateExportConfStatus,
  CreatedByUserName,
  CreationDateTime,
  LastChangedByUserName,
  ChangedDateTime,
  virtual BillingDocument : vbeln_vf AS virtualBillingDocumentvbeln_vf,
  virtual DeliveryDocument : vbeln_vl AS virtualDeliveryDocumentvbeln_vl,
  virtual IssueDate : j_3rs_imnt_issue_date AS virtualIssueDatej_3rs_imnt_issue_date,
  virtual Material : matnr AS virtualMaterialmatnr,
  BP1DataControllerSet,
  BP1DataController1,
  BP1DataController2,
  BP1DataController3,
  BP1DataController4,
  BP1DataController5,
  BP1DataController6,
  BP1DataController7,
  BP1DataController8,
  BP1DataController9,
  BP1DataController10,
  BP2DataControllerSet,
  BP2DataController1,
  BP2DataController2,
  BP2DataController3,
  BP2DataController4,
  BP2DataController5,
  BP2DataController6,
  BP2DataController7,
  BP2DataController8,
  BP2DataController9,
  BP2DataController10
FROM R_RU_ImportNotificationHdrTP
;

Learn More