RFM_ALIGN_DETAIL

Transparent Table Application Table
45 Fields 1 CDS Views

Table for storing alignment detail

RFM_ALIGN_DETAIL is an SAP database table in S/4HANA. Table for storing alignment detail. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurReqnAlgnmtMntrProdDetsBsc view from BASIC Alignment Details Basic

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY runid rfm_runid Run ID
KEY alignid rfm_alignid Alignment ID
align_date erdat Created On
align_time erzet Time
sales_org vkorg Sales Org.
distribution_channel vtweg Distr. Channel
division spart Division
material matnr Material
material_baseunit meins Base Unit
pr_document banfn Purchase Req.
pr_purchase_org ekorg Purchasing Org.
pr_vendor flief Fixed Vendor
pr_item bnfpo Requisn. item
pr_plant werks_d Plant
pr_konnr konnr Agreement
pr_ktpnr ktpnr Agreement Item
pr_quantity bamng Quantity
pr_segment sgt_scat Stock Segment
pr_season_year fsh_saisj Season Year
pr_season fsh_saiso Season
pr_collection fsh_collection Collection
pr_theme fsh_theme Theme
proposed_po ebeln Purchasing Doc.
proposed_po_item ebelp Item
proposed_po_purchase_org ekorg Purchasing Org.
proposed_po_vendor elifn Supplier
proposed_po_plant werks_d Plant
proposed_po_segment sgt_scat Stock Segment
proposed_po_konnr konnr Agreement
proposed_po_ktpnr ktpnr Agreement Item
proposed_po_quantity menge_d Quantity
proposed_po_season_year fsh_saisj Season Year
proposed_po_season fsh_saiso Season
proposed_po_collection fsh_collection Collection
proposed_po_theme fsh_theme Theme
cross_seaind rfm_cross_seaind Cross Season In
cross_plantind rfm_cross_plantind Cross Plant In
cross_segmentind rfm_cross_segment_ind Align Cross Segment
aligned_po ebeln Purchasing Doc.
aligned_po_item ebelp Item
aligned_po_quantity menge_d Quantity
alignment_confirmation rfm_alignment_confirmation RFM_ALIGNMENT_CONFIR
proposed_po_diversionstatus rfm_diversion_status Diversion Status
consolidated_baseunit meins Base Unit

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.

-- Table for storing alignment detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RFM_ALIGN_DETAIL (
    MANDT,                        -- Client [mandt]
    RUNID,                        -- Run ID [rfm_runid]
    ALIGNID,                      -- Alignment ID [rfm_alignid]
    ALIGN_DATE,                   -- Created On [erdat]
    ALIGN_TIME,                   -- Time [erzet]
    SALES_ORG,                    -- Sales Org. [vkorg]
    DISTRIBUTION_CHANNEL,         -- Distr. Channel [vtweg]
    DIVISION,                     -- Division [spart]
    MATERIAL,                     -- Material [matnr]
    MATERIAL_BASEUNIT,            -- Base Unit [meins]
    PR_DOCUMENT,                  -- Purchase Req. [banfn]
    PR_PURCHASE_ORG,              -- Purchasing Org. [ekorg]
    PR_VENDOR,                    -- Fixed Vendor [flief]
    PR_ITEM,                      -- Requisn. item [bnfpo]
    PR_PLANT,                     -- Plant [werks_d]
    PR_KONNR,                     -- Agreement [konnr]
    PR_KTPNR,                     -- Agreement Item [ktpnr]
    PR_QUANTITY,                  -- Quantity [bamng]
    PR_SEGMENT,                   -- Stock Segment [sgt_scat]
    PR_SEASON_YEAR,               -- Season Year [fsh_saisj]
    PR_SEASON,                    -- Season [fsh_saiso]
    PR_COLLECTION,                -- Collection [fsh_collection]
    PR_THEME,                     -- Theme [fsh_theme]
    PROPOSED_PO,                  -- Purchasing Doc. [ebeln]
    PROPOSED_PO_ITEM,             -- Item [ebelp]
    PROPOSED_PO_PURCHASE_ORG,     -- Purchasing Org. [ekorg]
    PROPOSED_PO_VENDOR,           -- Supplier [elifn]
    PROPOSED_PO_PLANT,            -- Plant [werks_d]
    PROPOSED_PO_SEGMENT,          -- Stock Segment [sgt_scat]
    PROPOSED_PO_KONNR,            -- Agreement [konnr]
    PROPOSED_PO_KTPNR,            -- Agreement Item [ktpnr]
    PROPOSED_PO_QUANTITY,         -- Quantity [menge_d]
    PROPOSED_PO_SEASON_YEAR,      -- Season Year [fsh_saisj]
    PROPOSED_PO_SEASON,           -- Season [fsh_saiso]
    PROPOSED_PO_COLLECTION,       -- Collection [fsh_collection]
    PROPOSED_PO_THEME,            -- Theme [fsh_theme]
    CROSS_SEAIND,                 -- Cross Season In [rfm_cross_seaind]
    CROSS_PLANTIND,               -- Cross Plant In [rfm_cross_plantind]
    CROSS_SEGMENTIND,             -- Align Cross Segment [rfm_cross_segment_ind]
    ALIGNED_PO,                   -- Purchasing Doc. [ebeln]
    ALIGNED_PO_ITEM,              -- Item [ebelp]
    ALIGNED_PO_QUANTITY,          -- Quantity [menge_d]
    ALIGNMENT_CONFIRMATION,       -- RFM_ALIGNMENT_CONFIR [rfm_alignment_confirmation]
    PROPOSED_PO_DIVERSIONSTATUS,  -- Diversion Status [rfm_diversion_status]
    CONSOLIDATED_BASEUNIT,        -- Base Unit [meins]
    PRIMARY KEY (MANDT, RUNID, ALIGNID)
);

Learn More