NJIT_PURCH_SA

Transparent Table Application Table
16 Fields 1 CDS Views

JIT S2P Control cycle

NJIT_PURCH_SA is an SAP database table in S/4HANA. JIT S2P Control cycle. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_JITOutbSchedgAgrmt view from BASIC Basic Scheduling Agreement data

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY db_key /bobf/conf_key NodeID
parent_key /bobf/conf_key NodeID
jitcontrolcycle pknum Control Cycle
productionsupplyarea njit_psa Supply Area
material njit_component Component
plant njit_werks Plant
jitoutbschedgagrmtsupplier njit_sched_agrmt_supplier Sch. Aggr Supplier
storagelocation njit_s2p_lgort Stor. Location
schedulingagreement njit_s2p_schedg_agrmt Scheduling Agreement
schedulingagreementitem njit_s2p_schedg_agrmt_item Schedule Item Number
jitoutbschedgagrmtstatus njit_sched_agrmt_status Sched Aggr Status
created_by_user syuname User Name
created_date_time timestampl Time Stamp
last_changed_by_user syuname User Name
updated_date_time timestampl Time Stamp

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.

-- JIT S2P Control cycle
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NJIT_PURCH_SA (
    MANDT,                       -- Client [mandt]
    DB_KEY,                      -- NodeID [/bobf/conf_key]
    PARENT_KEY,                  -- NodeID [/bobf/conf_key]
    JITCONTROLCYCLE,             -- Control Cycle [pknum]
    PRODUCTIONSUPPLYAREA,        -- Supply Area [njit_psa]
    MATERIAL,                    -- Component [njit_component]
    PLANT,                       -- Plant [njit_werks]
    JITOUTBSCHEDGAGRMTSUPPLIER,  -- Sch. Aggr Supplier [njit_sched_agrmt_supplier]
    STORAGELOCATION,             -- Stor. Location [njit_s2p_lgort]
    SCHEDULINGAGREEMENT,         -- Scheduling Agreement [njit_s2p_schedg_agrmt]
    SCHEDULINGAGREEMENTITEM,     -- Schedule Item Number [njit_s2p_schedg_agrmt_item]
    JITOUTBSCHEDGAGRMTSTATUS,    -- Sched Aggr Status [njit_sched_agrmt_status]
    CREATED_BY_USER,             -- User Name [syuname]
    CREATED_DATE_TIME,           -- Time Stamp [timestampl]
    LAST_CHANGED_BY_USER,        -- User Name [syuname]
    UPDATED_DATE_TIME,           -- Time Stamp [timestampl]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More