I_PURCHASEREQNHEADERNOTES

CDS View

Purchase Requisition Header Note Basic

I_PURCHASEREQNHEADERNOTES is a CDS View in S/4HANA. Purchase Requisition Header Note Basic. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PurReqnFactSheetHeaderText view from CONSUMPTION Purchase Requisition Header Note - Text
I_PurchaseReqnHeaderNotesTP view from TRANSACTIONAL Purchase Requisition Header Notes - TP
I_SSPPurchaseReqnHdrNotesTP view from TRANSACTIONAL SSP Modernization Header Notes - TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ArchitecturalObjectNumber ArchObjectNumber,ArchObjectNumberForEdit 3
KEY DocumentText DocumentText,DocumentTextForEdit 3
KEY Language Language,LanguageForEdit 3
KEY PurchaseRequisition PurchaseRequisition 3
KEY TechnicalObjectType TechnicalObjectType,TechnicalObjectTypeForEdit 3
DisplayModeOfTextTypeInPurg DisplayModeOfTextTypeInPurg 2
FixedIndicator FixedIndicator 2
NoteDescription NoteDescription 3
TextIsAdoptedFromReference TextIsAdoptedFromReference 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 Requisition Header Note Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEREQNHEADERNOTES (
    ARCHITECTURALOBJECTNUMBER,
    DOCUMENTTEXT,
    LANGUAGE,
    PURCHASEREQUISITION,
    TECHNICALOBJECTTYPE,
    DISPLAYMODEOFTEXTTYPEINPURG,
    FIXEDINDICATOR,
    NOTEDESCRIPTION,
    TEXTISADOPTEDFROMREFERENCE,
    PRIMARY KEY (ARCHITECTURALOBJECTNUMBER, DOCUMENTTEXT, LANGUAGE, PURCHASEREQUISITION, TECHNICALOBJECTTYPE)
);