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