SAP table T621 (Item Categories for Allocation Tables)

SAP table T621 has 2 primary key fields being MANDT,APSTP.

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
APSTP Item category of allocation table CHAR 4 0 APSTP
BSTGE Goods Recipient of Supplier Purchase Order CHAR 1 0 BSTGE
No Purchase Order
1 PO via DC (Delivery to Distribution Center)
2 PO as Desired (Delivery to DC or Plant Depending on Key)
3 Direct Delivery (Delivery to Plant)
UMLGE Stock Transfer From DC to Recipients CHAR 1 0 UMLGE
No Flow of Goods from DC to the Recipient
1 Warehouse Order (For Plants)
2 Delivery Without Reference (For Plants)
3 Sales Order (For Plants and Customers)
4 Warehouse Order For Plants, Sales Order for Customers
5 Customers: Order; Plants: User Exit "PO or Order"
AAFBG Interaction Notif./Follow-on doc. generation CHAR 1 0 AAFBG
Generate follow-on docs immediately (no check)
A Generate follow-on docs as soon as notif. created for plant
B Generate follow-on docs when notif. created for all plants
WEFBG Generate follow-on docs following GR in DC CHAR 1 0 WEFBG
In stock/generate deliveries immediately
1 In stock/generate deliveries following GR entry in DC
LFART Delivery type of allocation table CHAR 4 0 TVLK LFART_AUFT
BZQFI ID: how source of supply is determined CHAR 1 0 BZQFI
No Supply Source Determination
1 Distribution Center and Supplier
2 Distribution Center Only
3 Supplier only
4 DC Recipient Determination and DC Supplier
5 DC Recipient Determination
POSGR Screen sequence group for document header & item CHAR 4 0 * BIFGR
BSART Order Type in Allocation Table (for External Supplier) CHAR 4 0 T161 BSART_LIEF
UMART Order type in allocation table (for warehouse/DC) CHAR 4 0 T161 BSART_LAGER
BSART_GL_BUKRS Replacement order type in alloc tbl in same company code CHAR 4 0 T161 BSART_GL_BUKRS
ASNRM Create distribution data (procurement in 2 steps) CHAR 1 0 ASNRM
Always create distribution data
1 Only create distribution data for CD and FT (not PA)
2 Do not create distribution data
BSTZU Supplier Purchase Orders, Aggregate CHAR 1 0 BSTZU
Not Allowed
1 Only Allowed for Alloc. Tbl Line Items
2 Allowed With No Restrictions
UMLZU Stock transfer order, aggregate CHAR 1 0 UMLZU
Not allowed
1 Only allowed for alloc tbl line items
2 Allowed with no restrictions
LIEZU Aggregate alloc tbl items in deliveries CHAR 1 0 LIEZU
Per shipping point
TERMG Scheduling CHAR 1 0 TERMG
No scheduling (enter generation date in header)
0 Schedule today as generation date
1 Schedule order date
2 Schedule stock transfer date
3 Schedule delivery date
4 Schedule all
VZWBG Indicates how processing method in DC is determined CHAR 1 0 VZWBG
Put-away (placement in storage)
0 Determine processing method from master data
1 Cross-docking
2 Flow-through
3 Cross-docking/flow-through
4 Cross-docking/put-away (placement in storage)
LFIND Storage Location Determination CHAR 1 0 LFIND
0 No Storage Location Determination
1 Storage Location Determination for Distr. Center (Generic)
2 Storage Location Determination for Store (Generic)
3 Storage Location Determination in all Cases (Generic)
4 Storage Location Determination for the DC 8Putaway)
5 Storage Location Determination for the Store (Putaway)
6 Storage Location Determination in all Cases (Putaway)
KAART Sales Document Type CHAR 4 0 DB_AUART AUART
DETDELDATE Determine Delivery Date Recipient CHAR 1 0 DETDELDATE
Default delivery date
0 User exit
DETDELDATE_VZ Determine Delivery Date DC CHAR 1 0 DETDELDATE_VZ
Default delivery date
0 User Exit
PRIO_ORDER_TYPE Priority of Doc. Type in Warehouse Order from Alloc. Table CHAR 1 0 PRIO_ORDER_TYPE
TERMG_NO_WEBAZ Scheduling Without Goods Receipt Processing Time CHAR 1 0 TERMG_NO_WEBAZ
WRF_TERMG_REACT Control of Scheduling (Seasonal Procurement) CHAR 1 0 WRF_TERMG_REACT
0 Reschedule (Current Date = Latest Generation Date)
1 Copy Scheduling - Modify Dateline Manually
CONS_MODE Consignment Processing in Allocation Table CHAR 1 0 WRF_AT_CONS_MODE
DC: Own Goods/Store: Own Goods
1 DC: Value of Master Data/Store: Value of Master Data
2 DC: Value of Master Data/Store: Own Goods
3 DC: Consignment Goods/Store: Value from Master Data
4 DC: Consignment Goods/Store: Consignment Goods
5 DC. Consignment Goods/Store: Own Goods

T621 foreign key relationships

Table Field Check Table Check Field
0 T621 BSART T161 Purchasing Document Types MANDT
1 T621 BSART_GL_BUKRS T161 Purchasing Document Types MANDT
0 T621 KAART DB_AUART Generated Table for View AUART
1 T621 LFART TVLK Delivery Types MANDT
1 T621 LFART TVLK Delivery Types LFART
0 T621 UMART T161 Purchasing Document Types MANDT