P_RU_ImportNotificationHdrTP

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_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.
-- SQL view name: PRUIMPRTNOTIFHDR

CREATE VIEW P_RU_ImportNotificationHdrTP AS
SELECT
  Header.RU_ImprtNotifInternalNumber AS RU_ImprtNotifInternalNumber,
  Header.RU_ImprtNotifExternalNumber AS RU_ImprtNotifExternalNumber,
  Header.ExportConfirmationDate AS ExportConfirmationDate,
  Header.RU_ImprtNotifRegistrationDate AS RU_ImprtNotifRegistrationDate,
  Header.CompanyCode AS CompanyCode,
  CompanyCode.Country AS CompanyCodeCountry,
  CompanyCode.CompanyCodeName AS CompanyCodeName,
  Header.Customer AS Customer,
  Header.CustomerCountry AS CustomerCountry,
  Header.RU_CustomerINN AS RU_CustomerINN,
  Header.CustomerName AS CustomerName,
  Header.CustomerAuthznGrp AS CustomerAuthznGrp,
  Header.CustomerAccountGroup AS CustomerAccountGroup,
  Header.CustomerIsBusPrpsCmpltd AS CustomerIsBusPrpsCmpltd,
  Header.CustomerCompanyAuthznGroup AS CustomerCompanyAuthznGroup,
  Header.CustCoIsBusPrpsCmpltd AS CustCoIsBusPrpsCmpltd,
  Header.Consignee AS Consignee,
  Header.RU_AgentOrganizationINN AS RU_AgentOrganizationINN,
  Header.ConsigneeName AS ConsigneeName,
  Header.ConsigneeCountry AS ConsigneeCountry,
  Header.ConsigneeAuthorizationGroup AS ConsigneeAuthorizationGroup,
  Header.ConsigneeAccountGroup AS ConsigneeAccountGroup,
  Header.ConsigneeIsBusPrpsCmpltd AS ConsigneeIsBusPrpsCmpltd,
  Header.AssignmentReference AS AssignmentReference,
  Contract.ExternalContractNumber AS ExternalContractNumber,
  Contract.ExternalContractDate AS ExternalContractDate,
  Header.RU_ImportNotificationIsMock AS RU_ImportNotificationIsMock,
  Header.RU_ImportNotifSellerSection AS RU_ImportNotifSellerSection,
  Header.CreatedByUserName AS CreatedByUserName,
  Header.CreationDateTime AS CreationDateTime,
  Header.LastChangedByUserName AS LastChangedByUserName,
  Header.ChangedDateTime AS ChangedDateTime,
  Header.RU_ImportNotifHasFollowUpDoc AS RU_ImportNotifHasFollowUpDoc,
  Header.BP1DataControllerSet AS BP1DataControllerSet,
  Header.BP1DataController1 AS BP1DataController1,
  Header.BP1DataController2 AS BP1DataController2,
  Header.BP1DataController3 AS BP1DataController3,
  Header.BP1DataController4 AS BP1DataController4,
  Header.BP1DataController5 AS BP1DataController5,
  Header.BP1DataController6 AS BP1DataController6,
  Header.BP1DataController7 AS BP1DataController7,
  Header.BP1DataController8 AS BP1DataController8,
  Header.BP1DataController9 AS BP1DataController9,
  Header.BP1DataController10 AS BP1DataController10,
  Header.BP2DataControllerSet AS BP2DataControllerSet,
  Header.BP2DataController1 AS BP2DataController1,
  Header.BP2DataController2 AS BP2DataController2,
  Header.BP2DataController3 AS BP2DataController3,
  Header.BP2DataController4 AS BP2DataController4,
  Header.BP2DataController5 AS BP2DataController5,
  Header.BP2DataController6 AS BP2DataController6,
  Header.BP2DataController7 AS BP2DataController7,
  Header.BP2DataController8 AS BP2DataController8,
  Header.BP2DataController9 AS BP2DataController9,
  cast('' as j_3rs_imnt_conf_status) AS RU_LateExportConfStatus,
  Header.BP2DataController10 AS BP2DataController10
FROM P_RU_ImportNotifHeaderWithBPG AS Header
-- UNION ALL with additional select branch(es): P_RU_ImportNotifHeaderWithBPG
;