P_RU_IMPORTNOTIFHEADERWITHBPG

CDS View

P_RU_IMPORTNOTIFHEADERWITHBPG is a CDS View in S/4HANA. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_ImportNotificationHdrTP view from COMPOSITE
P_RU_ImportNotificationHdrTP view union_all COMPOSITE

Fields (24)

KeyField CDS FieldsUsed in Views
KEY RU_ImprtNotifInternalNumber RU_ImprtNotifInternalNumber 1
AssignmentReference AssignmentReference 1
ChangedDateTime ChangedDateTime 1
CompanyCode CompanyCode 1
Consignee Consignee 1
ConsigneeAuthorizationGroup ConsigneeAuthorizationGroup 1
ConsigneeCountry ConsigneeCountry 1
ConsigneeName ConsigneeName 1
CreatedByUserName CreatedByUserName 1
CreationDateTime CreationDateTime 1
Customer Customer 1
CustomerAuthznGrp CustomerAuthznGrp 1
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup 1
CustomerCountry CustomerCountry 1
CustomerName CustomerName 1
ExportConfirmationDate ExportConfirmationDate 1
LastChangedByUserName LastChangedByUserName 1
RU_AgentOrganizationINN RU_AgentOrganizationINN 1
RU_CustomerINN RU_CustomerINN 1
RU_ImportNotifHasFollowUpDoc RU_ImportNotifHasFollowUpDoc 1
RU_ImportNotificationIsMock RU_ImportNotificationIsMock 1
RU_ImportNotifSellerSection RU_ImportNotifSellerSection 1
RU_ImprtNotifExternalNumber RU_ImprtNotifExternalNumber 1
RU_ImprtNotifRegistrationDate RU_ImprtNotifRegistrationDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_IMPORTNOTIFHEADERWITHBPG (
    RU_IMPRTNOTIFINTERNALNUMBER,
    ASSIGNMENTREFERENCE,
    CHANGEDDATETIME,
    COMPANYCODE,
    CONSIGNEE,
    CONSIGNEEAUTHORIZATIONGROUP,
    CONSIGNEECOUNTRY,
    CONSIGNEENAME,
    CREATEDBYUSERNAME,
    CREATIONDATETIME,
    CUSTOMER,
    CUSTOMERAUTHZNGRP,
    CUSTOMERCOMPANYAUTHZNGROUP,
    CUSTOMERCOUNTRY,
    CUSTOMERNAME,
    EXPORTCONFIRMATIONDATE,
    LASTCHANGEDBYUSERNAME,
    RU_AGENTORGANIZATIONINN,
    RU_CUSTOMERINN,
    RU_IMPORTNOTIFHASFOLLOWUPDOC,
    RU_IMPORTNOTIFICATIONISMOCK,
    RU_IMPORTNOTIFSELLERSECTION,
    RU_IMPRTNOTIFEXTERNALNUMBER,
    RU_IMPRTNOTIFREGISTRATIONDATE,
    PRIMARY KEY (RU_IMPRTNOTIFINTERNALNUMBER)
);