1. Home
  2. Resources
  3. SAP Tables
  4. ATPSG - Availability structure for several items

SAP Table ATPSG

Availability structure for several items

ATPSG (Availability structure for several items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ATPSG to other SAP tables.

ATPSG table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
BERID MRP Area BERID CHAR 10 0
LGORT Storage Location LGORT_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
PSPEL WBS Element PS_POSNR NUMC 8 0
KUNNR Customer Number KUNNR CHAR 10 0
PRREG Checking Rule for Availability Check PRREG CHAR 2 0
DELKZ MRP element DELKZ CHAR 2 0
AR Dependent reservation
BA Purchase requisition
BB Subcontractor requirements of material provided
BE Order item schedule line
BP Gross requirements planning
BR Process order
CH Batch stock
ER End of replenishment lead time
E1 Subcontracting purchasing
FE Production order
FH End of planning time fence
IH Maintenance order
JI JIT call
IM Actual goods receipt quantity
IW In plant (only relevant for IS Automotive)
KB Individual customer stock
KD Customer independent requirement (currently not used)
KK Consignment stock for customer (availability check)
LA Shipping notification
LB Storage location stock
LC Batch/storage location stock
LE SA schedule line
LF JIT delivery schedule
LK Stock with subcontractor
LL Forecast delivery schedule
MB Goods issue
MR Reservation
MS Direct production
NE Network order
PA Planned order
PB Project stock
PP Planned independent requirement
PR Forecast requirement
QM Inspection lot for quality management
RP Returns item
RR MRP requirement (only relevant for IS-Automotive)
RU Confirmation
S2 Simulated requirement from availability check
SA Simulation order
SB Dependent requirement
SF Safety requirement
SH Safety stock
SI Simulation requirement
SM Sim. dependent reqmts
SU Total requirements
TB Transfer requirements WMS
U1 Release order for a stock transfer order
U2 Release order for a stock transfer requisition
U3 Transfer requirement for simulation order
U4 Release order for stock transport scheduling agreement
UB Unplanned requirement
UL Reservation in another plant
UR Stock transfer reservation
VA Request for quotation
VB Quotation
VC Order
VE SD scheduling agreement
VF SD scheduling agreement; external service agent
VG Contract
VH Returns from Consignation Stock at Customer
VI Delivery Free of Charge
VJ Delivery
VP Planning
VT Returns (availability check)
VW External sales order
VZ Unverified delivery
WA Goods issue
WB Plant stock
WE Goods receipt
WH End replenishment period
DD Effective-out date
C3 Subcontr. Customer Order Stock
C4 Subcontr. Project Stock
DEL12 MRP element number DEL12 CHAR 12 0
DELNR MRP element number DELNR CHAR 10 0
DELPS MRP element item DELPS NUMC 6 0
DELET Schedule Line Number MRP Element DELET NUMC 4 0
BAART P.O./Order type BAART CHAR 4 0
BDART Requirement type BDART CHAR 2 0
PLART Planning type PLART CHAR 1 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
ENMNG Quantity Withdrawn ENMNG QUAN 13 3
BDTER Requirement Date for the Component BDTER DATS 8 0
ATPMG ATP Server: ATP quantity ATPMNG QUAN 15 3
ATPM1 ATP Server: ATP quantity ATPMNG QUAN 15 3
BDMNG Requirement Quantity BDMNG QUAN 13 3
VMENG ATP Server: confirmed qty BESTMNG QUAN 15 3
FMENG Quantity is Fixed FMENG CHAR 1 0
X Yes
NULL No
FIXMG Delivery date and quantity fixed FIXMG CHAR 1 0
X Yes
NULL No
DAT01 Committed Date DAT05 DATS 8 0
DAT02 Date for total commitment DAT06 DATS 8 0
ERRKZ ATP Server: Error flag ERRORKZ CHAR 1 0
X Yes
NULL No
XFEHL Missing Part XFEHL CHAR 1 0
X Yes
NULL No
XLINE Line index for internal table processing XLINE INT4 10 0
REVLV Revision Level REVLV CHAR 2 0
ALPST Alternative item: strategy CS_ALPST CHAR 1 0
1 Manual maintenance/by usage probability
2 100% check
ALPGR Alternative item: group CS_ALPGR CHAR 2 0
ALPLP Alternative Items with Level and Path ALPLP CHAR 1 0
NULL Level and Path Have Not Been Selected
X Level and Path Have Been Selected
AUFWG Order path AUFWG NUMC 2 0
AUFST Order level AUFST NUMC 2 0
ALPRF Alternative item: ranking order CS_ALPRF NUMC 2 0
ALPSELFLG ATP Server: selection flag for alternative items ALPSELFLG CHAR 1 0
X Yes
NULL No
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLNR Bill of material STNUM CHAR 8 0
TRTYP Transaction type TRTYP CHAR 1 0
* Masked
A Display
B Edit
C Display from archive
E Single-item planning
H Add
V Change
X Initial transaction
S Standard parameter: normal mode
U Convert indiv. planned order
L Delete
P Planning file entry
K Copy reference
D Print
SUMAG ATP Server: Total Issues SUMIS QUAN 15 3
SUMBA ATP Server: confirmed issues total SUMCI QUAN 15 3
SUMZG ATP Server: Total Receipts SUMRE QUAN 15 3
IDXATP ATP Server: index for ATP check in check sequence IDXATP NUMC 1 0
0 No avail. check
IDXPLN ATP Server: index for planning check in check sequence IDXPLN NUMC 1 0
0 No avail. check
IDXALL ATP Server: index for allocation check in check sequence IDXALL NUMC 1 0
0 No avail. check
RPFLG ATP Server: receipts in the past included RPFLG CHAR 1 0
X Yes
NULL No
RESMD ATP Server: Mode for Results of Check RESMD CHAR 1 0
NULL One-time delivery on requested delivery date
A Quantity at requested date, lock entire confirmation
B Complete dlv.
X Proposal list
CHKFLG ATP Server: Flag - check requirement (yes/no) CHKFLG CHAR 1 0
X Yes
NULL No
CORFLG ATP Server: Flag for creating correction records (yes/no) CORFLG CHAR 1 0
X Yes
NULL No
ENQFLG ATP Server: Flag for creating reqmts lock records (yes/no) ENQFLG CHAR 1 0
X Yes
NULL No
TCCFLG ATP server: Participation in calculation of confirmation TCCFLG CHAR 1 0
X Yes
NULL No
KNTTP Account Assignment Category KNTTP CHAR 1 0
VPMAT Planning material VPMAT CHAR 18 0
VPWRK Planning plant VPWRK CHAR 4 0
VPZUO Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
ATPIF ATP Server: Additional information field for 'shared buffer' ATPIF CHAR 3 0
SUMBD Summing up of requirements SUMBD CHAR 1 0
A Single records
B Totals records per day
C Totals records per week, reqs date on Monday of current week
D Totals records per week, reqs date on Monday of fol. week