SAP Table CNPB_H_AUFK_MANDATORY_FIELDS

Fields Required from AUFK to Determine the Hierarchy

CNPB_H_AUFK_MANDATORY_FIELDS (Fields Required from AUFK to Determine the Hierarchy) 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 CNPB_H_AUFK_MANDATORY_FIELDS to other SAP tables.

Source: CNPB_H_AUFK_MANDATORY_FIELDS (Fields Required from AUFK to Determine the Hierarchy)

CNPB_H_AUFK_MANDATORY_FIELDS table fields

Field Data element Checktable Datatype Length Decimals
AUFNR Order Number AUFNR CHAR 12 0
OBJNR Object number J_OBJNR CHAR 22 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
AUART Order Type AUFART CHAR 4 0
PSPEL Work breakdown structure element (WBS element) PS_PSP_ELE NUMC 8 0
PRONR Project definition PS_PSP_PRO NUMC 8 0
AUFNT Number of superior network CO_TEILNET CHAR 12 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
EXT_AUFNR Order Number AUFNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
NETZKONT Indicator for the account assignment of a network(hdr/act.) NETZKONT CHAR 1 0
NULL Account assignment determined by status
1 Header-assigned network
2 Activity-assigned network
VALLC Single-Character Indicator CHAR1 CHAR 1 0
NODE_KEY Tree Control: Node Key TV_NODEKEY CHAR 12 0
FLG_HANDLED Indicator: Object already edited CNPB_H_FLG_OBJECT_HANDLED CHAR 1 0
X Yes
NULL No
LOEKZ Indicates whether an object is logically deleted. LOLOE CHAR 1 0
X Yes
NULL No
LOCKED Lock flag, U = User, F = Other, A = Not authorized UFENQUEUE CHAR 1 0
U User Locks Self
F Other User Locks
A No Authorization
EXPANDER CHAR 1 0
KTEXT General short text CNPB_KTEXT CHAR 40 0