NJIT_PURCH_SA

Transparent Table Application Table
17 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 17 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 (17)

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
dummy_njit_cc_incl_sch_agmt_ps CFD_DUMMY Dummy

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]
    DUMMY_NJIT_CC_INCL_SCH_AGMT_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More