I_DOCUMENTPRTBYINTERNALKEY

CDS View
11 Fields 6 CDS Views

Document PRT by internal key

I_DOCUMENTPRTBYINTERNALKEY is a CDS View in S/4HANA. Document PRT by internal key. It contains 11 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_BOOOpDocumentPRTChangeState view inner COMPOSITE BOO Operation Document Production Resource/Tool Change State
I_DocumentProdnRsceTool view from BASIC Document Production Resource Tool
I_MfgWorkInstructionPRTDocLink view inner BASIC Documents linked to a PRT assigned to OA
P_MstrRcpOpDocPRTAssgmt view_entity inner COMPOSITE Document PRT Assignment
R_ProdnRtgOpDocPRTAssgmtTP view_entity inner TRANSACTIONAL Document PRT Assignment
R_ProdnRtgOpDocPRTAssgmtTP_2 view_entity inner TRANSACTIONAL Document PRT Assignment

Fields (11)

KeyField CDS FieldsUsed in Views
KEY DocumentInfoRecord DocumentInfoRecord,DocumentInfoRecordDocNumber 5
KEY DocumentType DocumentType 5
KEY DocumentVersion DocumentVersion 5
_DocumentInfoRecord _DocumentInfoRecord 1
_DocumentNumber _DocumentNumber 1
_DocumentType _DocumentType 1
_DocumentVersion _DocumentVersion 1
_ProductionResourceType _ProductionResourceType 1
DocumentPart DocumentPart 4
ProductionResourceInternalID ProductionResourceInternalID 1
ProductionResourceType ProductionResourceType 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.

-- Document PRT by internal key
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DOCUMENTPRTBYINTERNALKEY (
    DOCUMENTINFORECORD,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    _DOCUMENTINFORECORD,
    _DOCUMENTNUMBER,
    _DOCUMENTTYPE,
    _DOCUMENTVERSION,
    _PRODUCTIONRESOURCETYPE,
    DOCUMENTPART,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    PRIMARY KEY (DOCUMENTINFORECORD, DOCUMENTTYPE, DOCUMENTVERSION)
);

Learn More