SND_PL_MAG

Transparent Table Application Table
25 Fields 1 CDS Views

SAF-T PL : Material Document Movements for JPK_MAG

SND_PL_MAG is an SAP database table in S/4HANA. SAF-T PL : Material Document Movements for JPK_MAG. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PL_SAFTGoodsMovement view from BASIC SAF-T Goods Movement

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY extraction_id SAFTN_EXTRACTION_ID Extraction ID
KEY mov_cat SAFTN_PL_MOV_CAT Movement Category
KEY werks WERKS_D Plant
KEY lgort LGORT_D Location
KEY mblnr MBLNR Material Doc.
KEY mjahr MJAHR Mat. Doc. Year
KEY zeile MBLPO Mat. Doc.Item
bukrs BUKRS Company Code
lifnr LIFNR Supplier
kunnr KUNNR Customer
matnr MATNR Material
menge MENGE_D Quantity
meins MEINS Base Unit
waers WAERS Currency
bldat BLDAT Document Date
budat BUDAT Posting Date
doc_amount SAFTN_PL_AMOUNT Amount
mat_unit_price SAFTN_PL_MAT_UNIT_PRICE Unit Price
mat_value SAFTN_PL_MAT_VALUE Material Value
mat_name SAFTN_PL_MAT_NAME Material Name
inv_ref SAFTN_PL_INVOICE_REF Invoice Reference
inv_date SAFTN_PL_INVOICE_DATE Invoice Date
ship_from SAFTN_PL_SHIP_FROM Ship-From Address
ship_to SAFTN_PL_SHIP_TO Ship-To Address

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.

-- SAF-T PL : Material Document Movements for JPK_MAG
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SND_PL_MAG (
    MANDT,           -- Client [MANDT]
    EXTRACTION_ID,   -- Extraction ID [SAFTN_EXTRACTION_ID]
    MOV_CAT,         -- Movement Category [SAFTN_PL_MOV_CAT]
    WERKS,           -- Plant [WERKS_D]
    LGORT,           -- Location [LGORT_D]
    MBLNR,           -- Material Doc. [MBLNR]
    MJAHR,           -- Mat. Doc. Year [MJAHR]
    ZEILE,           -- Mat. Doc.Item [MBLPO]
    BUKRS,           -- Company Code [BUKRS]
    LIFNR,           -- Supplier [LIFNR]
    KUNNR,           -- Customer [KUNNR]
    MATNR,           -- Material [MATNR]
    MENGE,           -- Quantity [MENGE_D]
    MEINS,           -- Base Unit [MEINS]
    WAERS,           -- Currency [WAERS]
    BLDAT,           -- Document Date [BLDAT]
    BUDAT,           -- Posting Date [BUDAT]
    DOC_AMOUNT,      -- Amount [SAFTN_PL_AMOUNT]
    MAT_UNIT_PRICE,  -- Unit Price [SAFTN_PL_MAT_UNIT_PRICE]
    MAT_VALUE,       -- Material Value [SAFTN_PL_MAT_VALUE]
    MAT_NAME,        -- Material Name [SAFTN_PL_MAT_NAME]
    INV_REF,         -- Invoice Reference [SAFTN_PL_INVOICE_REF]
    INV_DATE,        -- Invoice Date [SAFTN_PL_INVOICE_DATE]
    SHIP_FROM,       -- Ship-From Address [SAFTN_PL_SHIP_FROM]
    SHIP_TO,         -- Ship-To Address [SAFTN_PL_SHIP_TO]
    PRIMARY KEY (MANDT, EXTRACTION_ID, MOV_CAT, WERKS, LGORT, MBLNR, MJAHR, ZEILE)
);

Learn More