I_RO_SAFTMATERIALDOCUMENTITEM

CDS View
18 Fields 2 CDS Views

RO SAFT Material Document Item

I_RO_SAFTMATERIALDOCUMENTITEM is a CDS View in S/4HANA. RO SAFT Material Document Item. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RO_SAFTMatlDocLineItem view_entity from COMPOSITE RO SAFT Matl Doc Lines
I_RO_SAFTStockMovementLine view inner COMPOSITE Stock Movement Line Items

Fields (18)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY MaterialDocument MaterialDocument 1
KEY MaterialDocumentItem MaterialDocumentItem 1
KEY MaterialDocumentLine MaterialDocumentLine 1
KEY MaterialDocumentYear MaterialDocumentYear 1
AccountingDocumentType AccountingDocumentType 1
AlternativeUnit MaterialBaseUnit 1
Batch Batch 2
CompanyCodeCurrency CompanyCodeCurrency 1
CreatedByUser CreatedByUser 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
GoodsMovementStkAmtInCCCrcy GoodsMovementStkAmtInCCCrcy 1
GoodsMovementType GoodsMovementType 2
MaterialDocumentItemText MaterialDocumentItemText 2
Plant Plant 1
PostingDate PostingDate 1
Product Product 1

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.

-- RO SAFT Material Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RO_SAFTMATERIALDOCUMENTITEM (
    COMPANYCODE,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTLINE,
    MATERIALDOCUMENTYEAR,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEUNIT,
    BATCH,
    COMPANYCODECURRENCY,
    CREATEDBYUSER,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    GOODSMOVEMENTSTKAMTINCCCRCY,
    GOODSMOVEMENTTYPE,
    MATERIALDOCUMENTITEMTEXT,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PRIMARY KEY (COMPANYCODE, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTLINE, MATERIALDOCUMENTYEAR)
);

Learn More