I_EXTERNALREFFORPURGDOC

CDS View

I-View to Display External Links for Purchasing Documents

I_EXTERNALREFFORPURGDOC is a CDS View in S/4HANA. I-View to Display External Links for Purchasing Documents. It contains 5 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_ExternalRefForPurReqnItm view union BASIC Purchase Reqn Item External Reference
I_ExtReferencesForPurReqnItm view from BASIC External References of PR Item
I_PurContrItemExtReference view from BASIC External References of Pur Contract Item
P_CntrlProcmtMtrgPurReqnExtRef view_entity from COMPOSITE CP: Private View for External Reference of Central Pur Reqn
P_ExtReferencesForPurReqnItm view from COMPOSITE External References of PR Item
R_PurOrdExternalReference view_entity from BASIC PO External References
R_PurOrdItemExternalReference view_entity from BASIC PO Item External References

Fields (5)

KeyField CDS FieldsUsed in Views
KEY LinkType LinkType 2
KEY SequenceNumber PurgExtRefSequenceNumber 2
PurgDocExternalReference PurgDocExternalReference 2
PurgDocExternalSystem PurgDocExternalSystem 2
PurgDocExtReferenceNodeType PurgDocExtReferenceNodeType 2

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.

-- I-View to Display External Links for Purchasing Documents
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EXTERNALREFFORPURGDOC (
    LINKTYPE,
    SEQUENCENUMBER,
    PURGDOCEXTERNALREFERENCE,
    PURGDOCEXTERNALSYSTEM,
    PURGDOCEXTREFERENCENODETYPE,
    PRIMARY KEY (LINKTYPE, SEQUENCENUMBER)
);