T159L
Default values for inventory management and physical invent.
T159L is an SAP database table in S/4HANA. Default values for inventory management and physical invent.. It contains 36 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DfltValsForInvtryMgmtAndPInv | view_entity | from | COMPOSITE | Default values IM and Physical INV |
| P_ReservationPlantDefaultValue | view_entity | from | BASIC | Plant Defaults for Manual Reservations |
Fields (36)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | werks | werks_d | Plant | |||
| bstar | bstar | Stock type | ||||
| kzcha | kzcha | Batch Backgrnd | ||||
| xamei | xamei | Altern. Unit | ||||
| stlan | stlan | Usage | ||||
| xwaok | xwaok | Mvt Allowed | ||||
| xlaut | xlaut | Automatic SLoc. | ||||
| twaok | twaok | Days mvt. allow | ||||
| tloek | tloek | Retention per. | ||||
| xelik | xelik | Delivery compl. | ||||
| vgart | vgart | Trans. Ev. Type | ||||
| capid | capid | BOM Application | ||||
| xchvw | xchvw | BaWU synchron. | ||||
| xchva | xchva | BaWU deactivat. | ||||
| xfhtp | xfhtp | Miss.parts act. | ||||
| xfver | xfver | Summ.miss.parts | ||||
| kzxab | kzxab | GR/GI slip no. | ||||
| xsmng | xsmng | Neg. stock RTP | ||||
| xsvng | xsvng | Neg.stck rePckC | ||||
| xwmhd | xwmhd | BBD/Prod. Date | ||||
| xskng | xskng | Neg. vCons.stck | ||||
| xsong | xsong | Neg. SC stocks | ||||
| xswng | xswng | Neg. Cust. Csgt | ||||
| xseng | xseng | Neg.sl.ordStock | ||||
| xsqng | xsqng | Neg. proj. stck | ||||
| grund | grdif | Reason f. Diff. | ||||
| xrmad | xrmad | Auto. MARD segment | ||||
| xaebl | xaebl | Change Document | ||||
| xcaut | xcaut | BchNo.auto.GR AcAsst | ||||
| xbuib | xbuib | Adj. Book Inv. | ||||
| xserp | xserp | Print Ser. Nos | ||||
| xsera | xsera | Display Serial Nos | ||||
| serpr | serpr | No. Serial No. Lines | ||||
| msr_insmk_free | msr_insmk_free | StckT Free Av. | ||||
| msr_insmk_rcv | msr_insmk_rcv | Stock Type Rcv. |
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.
-- Default values for inventory management and physical invent.
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T159L (
MANDT, -- Client [mandt]
WERKS, -- Plant [werks_d]
BSTAR, -- Stock type [bstar]
KZCHA, -- Batch Backgrnd [kzcha]
XAMEI, -- Altern. Unit [xamei]
STLAN, -- Usage [stlan]
XWAOK, -- Mvt Allowed [xwaok]
XLAUT, -- Automatic SLoc. [xlaut]
TWAOK, -- Days mvt. allow [twaok]
TLOEK, -- Retention per. [tloek]
XELIK, -- Delivery compl. [xelik]
VGART, -- Trans. Ev. Type [vgart]
CAPID, -- BOM Application [capid]
XCHVW, -- BaWU synchron. [xchvw]
XCHVA, -- BaWU deactivat. [xchva]
XFHTP, -- Miss.parts act. [xfhtp]
XFVER, -- Summ.miss.parts [xfver]
KZXAB, -- GR/GI slip no. [kzxab]
XSMNG, -- Neg. stock RTP [xsmng]
XSVNG, -- Neg.stck rePckC [xsvng]
XWMHD, -- BBD/Prod. Date [xwmhd]
XSKNG, -- Neg. vCons.stck [xskng]
XSONG, -- Neg. SC stocks [xsong]
XSWNG, -- Neg. Cust. Csgt [xswng]
XSENG, -- Neg.sl.ordStock [xseng]
XSQNG, -- Neg. proj. stck [xsqng]
GRUND, -- Reason f. Diff. [grdif]
XRMAD, -- Auto. MARD segment [xrmad]
XAEBL, -- Change Document [xaebl]
XCAUT, -- BchNo.auto.GR AcAsst [xcaut]
XBUIB, -- Adj. Book Inv. [xbuib]
XSERP, -- Print Ser. Nos [xserp]
XSERA, -- Display Serial Nos [xsera]
SERPR, -- No. Serial No. Lines [serpr]
MSR_INSMK_FREE, -- StckT Free Av. [msr_insmk_free]
MSR_INSMK_RCV, -- Stock Type Rcv. [msr_insmk_rcv]
PRIMARY KEY (MANDT, WERKS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA