SAP table T161V (Shipping-Specific Data for Stock Tfr. for Purch. Doc. Type)

SAP table T161V has 4 primary key fields being MANDT,BSTYP,BSART,RESWK.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
BSART Purchasing Document Type CHAR 4 0 T161 ESART
RESWK Supplying (issuing) plant in case of stock transport order CHAR 4 0 RESWK
LFART Delivery Type CHAR 4 0 TVLK LFART
PRREG Checking rule for the availability check CHAR 2 0 T441R PRREG
LFRET Delivery Type for Returns to Supplier CHAR 4 0 TVLK LFRET
LBLFA Delivery Type for Materials Provided to Subcontractor CHAR 4 0 TVLK LBLFA
LFRFL Delivery type for store returns CHAR 4 0 TVLK LFRFL
MEVST Perform Shipment Scheduling CHAR 1 0 MEVST
MERFP Use Route Schedule for Shipment Scheduling CHAR 1 0 MERFP
LFART1 Delivery Type for Stock Transfers Within a Company Code CHAR 4 0 TVLK LFART1
LFART2 Delivery Type for Stock Transfers Between Two Company Codes CHAR 4 0 TVLK LFART2
LFCON Delivery Type for Transfers to Consignment Stock CHAR 4 0 TVLK LFCON
REVFE Rule for Adoption of ATP Results in Purchasing CHAR 1 0 REVFE
One-Time Delivery (Rescheduling: Delivery Proposal)
A One-Time Delivery
B Complete Delivery
C Delivery Proposal
D Dialog Box in Case of Undercoverage (Batch: One-Time Deliv.)
E Dialog Box in Case of Undercoverage (Batch: Deliv. Proposal)
U Dialog Box in Case of Undercoverage (Batch: Complete Deliv.)
CRM_BILL CRM Billing active CHAR 1 0 /SPE/CRM_BILLING_ACTIVE
AUTO_DELV Automatic Delivery Creation Active CHAR 1 0 /SPE/AUTO_ACTIVE
REQPRF ATP: Profile at Requirements Level for APO CHAR 6 0 TREQPRF APOREQPRF
FLS_LFART Delivery Type for Outbound Delivery for Enh. Store Return CHAR 4 0 TVLK FLS_LFART
ATPCONFMRP ATP Confirmations Relevant for MRP CHAR 1 0 ATPCONFMRP
STR_BOM_DELV take over struct. article as BOM to replenishment delivery CHAR 3 0 STR_BOM_DELV
no subitems
5 Lot
56 Lot/Display
567 Lot/Display/Set
57 Lot/Set
6 Display
67 Display/Set
7 Set
ACTIVATE_ADV_PAL_IND Activate Product Allocation Check in Advanced ATP CHAR 1 0 ACTIVATE_ADV_PAL_IND
No
X Yes
ARTYP Allocation Type CHAR 4 0 FSH_ARCO FSH_ARTYP
IMMEDIATE_ORDER Immediate Order Assignment CHAR 1 0 ARUN_IMMEDIATE
SOREG Supply Sorting Rule during Order Assignment CHAR 4 0 ARUN_SORG_W ARUN_S_SOREGA
RELEASE_CHECK Set Release Rule Check for Orders CHAR 1 0 ARUN_RELEASE_CHECK
RFM_VAS_PLANT_CHECK Enable VAS Plant Capability Check CHAR 1 0 RFM_VAS_PLANT_CHECK
GR_RELEASE_CHECK Skip Release Rule Check for Goods Receipt CHAR 1 0 ARUN_GR_RELEASE_CHECK
BSGRU Reason for Ordering CHAR 3 0 * BSGRU
ARUN_EVENT_WF Workflow Events - Supply Assignment (ARUN) CHAR 1 0 ARUN_WORKFLOW
ARUN_EVENT_SIT Supply Assignment Situation CHAR 1 0 ARUN_SITUATION
UNCONFIRMED_ITEMS Supply Assignment Include Unconfirmed Order Items CHAR 1 0 ARUN_SEL_UNCONF_ORD

T161V foreign key relationships

Table Field Check Table Check Field
0 T161V BSART T161 Purchasing Document Types MANDT
1 T161V FLS_LFART TVLK Delivery Types MANDT
1 T161V FLS_LFART TVLK Delivery Types LFART
0 T161V LBLFA TVLK Delivery Types MANDT
0 T161V LBLFA TVLK Delivery Types LFART
1 T161V LFART TVLK Delivery Types MANDT
1 T161V LFART TVLK Delivery Types LFART
0 T161V LFART1 TVLK Delivery Types MANDT
0 T161V LFART1 TVLK Delivery Types LFART
1 T161V LFART2 TVLK Delivery Types MANDT
1 T161V LFART2 TVLK Delivery Types LFART
0 T161V LFCON TVLK Delivery Types MANDT
0 T161V LFCON TVLK Delivery Types LFART
1 T161V LFRET TVLK Delivery Types MANDT
1 T161V LFRET TVLK Delivery Types LFART
0 T161V LFRFL TVLK Delivery Types MANDT
0 T161V LFRFL TVLK Delivery Types LFART
1 T161V MANDT T000 Clients MANDT
0 T161V PRREG T441R Values Table for Checking Rule MANDT
0 T161V PRREG T441R Values Table for Checking Rule PRREG
1 T161V REQPRF TREQPRF Requirements Profile CLIENT
0 T161V SOREG ARUN_SORG_W Sorting Rule and Type SOOBJ