I_DOCUMENTPRTBYINTERNALKEY

CDS View
11 Fields 7 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. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_OpActyInstceDocPRT view_entity inner CONSUMPTION Planned Documents at Operation Activity
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
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 6
KEY DocumentType DocumentType 6
KEY DocumentVersion DocumentVersion 6
_DocumentInfoRecord _DocumentInfoRecord 2
_DocumentNumber _DocumentNumber 2
_DocumentType _DocumentType 2
_DocumentVersion _DocumentVersion 2
_ProductionResourceType _ProductionResourceType 1
DocumentPart DocumentPart 5
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