T161V
Shipping-Specific Data for Stock Tfr. for Purch. Doc. Type
T161V is an SAP database table in S/4HANA. Shipping-Specific Data for Stock Tfr. for Purch. Doc. Type. It contains 23 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Arun_I_Sto_Reqmt | view | inner | STO selection for Normal mode | |
| ARUN_I_STO_REQMT_PREV | view | inner | STO selection from Preview table | |
| Atpc_Cds_Sto_10 | view | left_outer | Helper CDS view for STOs in ATP BOP | |
| I_PurgDocTypeShipgData | view | from | BASIC | Shipping Stock Data |
Fields (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | bstyp | bstyp | Doc. Category | |||
| KEY | bsart | esart | Document Type | |||
| KEY | reswk | reswk | Supplying Plant | |||
| lfart | lfart | Delivery Type | ||||
| prreg | prreg | Checking rule | ||||
| lfret | lfret | Del. Type Rtns | ||||
| lblfa | lblfa | Del. Type f. SC | ||||
| lfrfl | lfrfl | Del. ty. rtrns | ||||
| mevst | mevst | Shipment Sched. | ||||
| merfp | merfp | Route Schedule | ||||
| lfart1 | lfart1 | Delivery type 1 | ||||
| lfart2 | lfart2 | Delivery type 2 | ||||
| lfcon | lfcon | DT for consign. | ||||
| revfe | revfe | AvailCheck Rule | ||||
| crm_bill | /spe/crm_billing_active | active | ||||
| auto_delv | /spe/auto_active | Active | ||||
| reqprf | aporeqprf | ATP reqmnts prfl. | ||||
| fls_lfart | fls_lfart | Del.Ty. Enh.Ret | ||||
| atpconfmrp | atpconfmrp | ATP Conf. MRP | ||||
| str_bom_delv | str_bom_delv | Str.BOM-Deliv | ||||
| activate_adv_pal_ind | activate_adv_pal_ind | Activate PAL in aATP | ||||
| fcfs_priority | mmpur_atp_fcfs_priority | ATP FCFS Priority |
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.
-- Shipping-Specific Data for Stock Tfr. for Purch. Doc. Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T161V (
MANDT, -- Client [mandt]
BSTYP, -- Doc. Category [bstyp]
BSART, -- Document Type [esart]
RESWK, -- Supplying Plant [reswk]
LFART, -- Delivery Type [lfart]
PRREG, -- Checking rule [prreg]
LFRET, -- Del. Type Rtns [lfret]
LBLFA, -- Del. Type f. SC [lblfa]
LFRFL, -- Del. ty. rtrns [lfrfl]
MEVST, -- Shipment Sched. [mevst]
MERFP, -- Route Schedule [merfp]
LFART1, -- Delivery type 1 [lfart1]
LFART2, -- Delivery type 2 [lfart2]
LFCON, -- DT for consign. [lfcon]
REVFE, -- AvailCheck Rule [revfe]
CRM_BILL, -- active [/spe/crm_billing_active]
AUTO_DELV, -- Active [/spe/auto_active]
REQPRF, -- ATP reqmnts prfl. [aporeqprf]
FLS_LFART, -- Del.Ty. Enh.Ret [fls_lfart]
ATPCONFMRP, -- ATP Conf. MRP [atpconfmrp]
STR_BOM_DELV, -- Str.BOM-Deliv [str_bom_delv]
ACTIVATE_ADV_PAL_IND, -- Activate PAL in aATP [activate_adv_pal_ind]
FCFS_PRIORITY, -- ATP FCFS Priority [mmpur_atp_fcfs_priority]
PRIMARY KEY (MANDT, BSTYP, BSART, RESWK)
);
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