R_PURCHASEORDERITEMNOTE

CDS View
8 Fields 3 CDS Views

Purchase Order Item Notes

R_PURCHASEORDERITEMNOTE is a CDS View in S/4HANA. Purchase Order Item Notes. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_PurchaseOrderItemNote view from COMPOSITE Item Notes
C_PurOrderItemFactSheetNote view from CONSUMPTION Item Notes for Purchase Order
I_PurchaseOrderItemNoteTP view from TRANSACTIONAL Notes for Purchase Order Item

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ArchitecturalObjectNumber ArchObjectNumber,ArchObjectNumberForEdit 2
KEY DocumentText DocumentText,DocumentTextForEdit 2
KEY Language Language,LanguageForEdit 2
KEY PurchaseOrder PurchaseOrder 2
KEY PurchaseOrderItem PurchaseOrderItem 2
KEY TechnicalObjectType TechnicalObjectType,TechnicalObjectTypeForEdit 2
FixedIndicator FixedIndicator 2
NoteDescription NoteDescription 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.

-- Purchase Order Item Notes
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PURCHASEORDERITEMNOTE (
    ARCHITECTURALOBJECTNUMBER,
    DOCUMENTTEXT,
    LANGUAGE,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    TECHNICALOBJECTTYPE,
    FIXEDINDICATOR,
    NOTEDESCRIPTION,
    PRIMARY KEY (ARCHITECTURALOBJECTNUMBER, DOCUMENTTEXT, LANGUAGE, PURCHASEORDER, PURCHASEORDERITEM, TECHNICALOBJECTTYPE)
);

Learn More