SAP Table DOCUMENT_FLOW_ALV_STRUC

Display Structure for the Document Flow

DOCUMENT_FLOW_ALV_STRUC (Display Structure for the Document Flow) 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 DOCUMENT_FLOW_ALV_STRUC to other SAP tables.

DOCUMENT_FLOW_ALV_STRUC table fields

Field Data element Checktable Datatype Length Decimals
DOCTYPE Document type description FMRE_BATXT CHAR 30 0
DOCNUM Doc. no. (IDoc number, application document no., etc.) DOC_NUMBER CHAR 70 0
ITEMNUM Item number of the SD document POSNR NUMC 6 0
DOCNUV Preceding Document PREDOC_NUMBER CHAR 70 0
ITEMNUV Originating item POSNV NUMC 6 0
HLEVEL INT4 10 0
FOCUS CHAR 1 0
ICON Tree Control: Icon / Image TV_IMAGE CHAR 46 0
VBELV CHAR 20 0
POSNV NUMC 10 0
VBELN CHAR 20 0
POSNN NUMC 10 0
KZVOR CHAR 1 0
KZDET CHAR 1 0
APPLI CHAR 2 0
MANDT Client MANDT CLNT 3 0
VBTYP_N Document category of subsequent document VBTYP_N 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
RFMNG Referenced quantity in base unit of measure RFMNG QUAN 15 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
RFWRT Reference value RFWRT CURR 15 2
WAERS Statistics currency WAERS_V TCURC CUKY 5 0
VBTYP_V Document category of preceding SD document VBTYP_V 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
PLMIN Quantity is calculated positively, negatively or not at all PLMIN CHAR 1 0
0 Zero
+ Positive
- Negative
TAQUI ID: MM-WM transfer order confirmed TAQUI CHAR 1 0
X Yes
NULL No
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
MATNR Material Number MATNR MARA CHAR 18 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
BDART Requirement type BDART CHAR 2 0
PLART Planning type PLART CHAR 1 0
STUFE Level of the document flow record STUFE_VBFA NUMC 2 0
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
AEDAT Changed On AEDAT DATS 8 0
FKTYP Billing category FKTYP CHAR 1 0
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
BRGEW Gross weight BRGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI UNIT 3 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH UNIT 3 0
FPLNR Billing plan number / invoicing plan number FPLNR FPLA CHAR 10 0
FPLTR Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
RFMNG_FLO Referenced quantity in sales unit (float) RFMNG_FLTV FLTP 16 16
RFMNG_FLT Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
VRKME Sales unit VRKME T006 UNIT 3 0
ABGES Guaranteed (factor between 0 and 1) ABGES_CM FLTP 16 16
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
SONUM Special Stock Number LVS_SONUM CHAR 16 0
KZBEF Indicator Inventory Management active LVS_KZBEF CHAR 1 0
X Yes
NULL No
LOGSYS Logical system LOGSYS CHAR 10 0
WBSTA Goods movement status WBSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BUKRS Company Code BUKRS CHAR 4 0
GJAHR Material Document Year MJAHR NUMC 4 0
OBJ_BEZEI Description BEZEI20 CHAR 20 0
POS_VTEXT Description BEZEI20 CHAR 20 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
STATUS Status of Document in the Document Flow BELEG_STATUS CHAR 20 0
OBJKEY Object key SWO_TYPEID CHAR 70 0
OBJTYPE Object Type SWO_OBJTYP CHAR 10 0
LOGSYS_AIP Logical system LOGSYS CHAR 10 0
AUFNR Order Number AUFNR CHAR 12 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
BEZKO Description of the document type BEZKO CHAR 20 0
BEZPO Description of the item category BEZPO CHAR 20 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
LOGSYS_A Logical system LOGSYS CHAR 10 0
LOGSYS_B Logical system LOGSYS CHAR 10 0
LOGSYS_V Logical system LOGSYS CHAR 10 0
LOGSYS_N Logical system LOGSYS CHAR 10 0
RELTYPE Relationship type BINRELTYP CHAR 4 0
PM_STATUS Status of a Document in the Document Flow (PM/CS/QM) RIBELF_STATUS CHAR 50 0
BLART_EAM General Document Type for Document Flow EAM_CC_BLART CHAR 4 0
MATNR_EAM Material / Batch for Document Flow EAM_CC_MATNR_CHARGE CHAR 40 0
QMTXT Short Text QMTXT CHAR 40 0
STEUS Control key STEUS CHAR 4 0
KUN_LIEF Customer/Vendor/Name for Document Flow EAM_CC_KUN_LIEF_NAM CHAR 60 0
BAUTL Assembly BAUTL CHAR 18 0
EQUNR Equipment Number EQUNR CHAR 18 0
TPLNR Functional Location TPLNR CHAR 30 0
MENGE Quantity AM_MENGE QUAN 13 3
MEINS_EAM Purchase Requisition Unit of Measure BAMEI UNIT 3 0
LGORT Storage Location LGORT_D CHAR 4 0
DWERK Plant WERKS_D CHAR 4 0
ARBPL Work center ARBPL CHAR 8 0
STRMN Start Date for Document Flow EAM_CC_START_DAT DATS 8 0
STRZT Start Time for Document Flow EAM_CC_START_ZEIT TIMS 6 0
LTRMN End Date for Document Flow EAM_CC_ENDE_DAT DATS 8 0
LTRZT End Time for Document Flow EAM_CC_ENDE_ZEIT TIMS 6 0
EKGRP Purchasing Group EKGRP CHAR 3 0
EKORG Purchasing Organization EKORG CHAR 4 0
AFNAM Name of Requisitioner/Requester AFNAM CHAR 12 0
ILART Activity Type LSTAR CHAR 6 0
ASTTX User Status ASTTX CHAR 40 0
EPSTP Item Category in Purchasing Document EPSTP CHAR 1 0
MATKL Material Group MATKL CHAR 9 0
REFNR_EAM External Reference Number in Document Flow EAM_CC_BEDNR CHAR 20 0
BWART_EAM Movement Type (Inventory Management) BWART CHAR 3 0
MPTYP Maintenance plan category MPTYP CHAR 2 0
STRAT Maintenance strategy STRAT CHAR 6 0
UVORN Suboperation UVORN CHAR 4 0

DOCUMENT_FLOW_ALV_STRUC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DOCUMENT_FLOW_ALV_STRUC FPLNR DOCUMENT_FLOW_ALV_STRUC MANDT FPLA Billing Plan MANDT
DOCUMENT_FLOW_ALV_STRUC FPLNR DOCUMENT_FLOW_ALV_STRUC FPLNR FPLA Billing Plan FPLNR
DOCUMENT_FLOW_ALV_STRUC MATNR DOCUMENT_FLOW_ALV_STRUC MATNR MARA General Material Data MATNR
DOCUMENT_FLOW_ALV_STRUC MATNR DOCUMENT_FLOW_ALV_STRUC MANDT MARA General Material Data MANDT
DOCUMENT_FLOW_ALV_STRUC MEINS DOCUMENT_FLOW_ALV_STRUC MANDT T006 Units of Measurement MANDT
DOCUMENT_FLOW_ALV_STRUC MEINS DOCUMENT_FLOW_ALV_STRUC MEINS T006 Units of Measurement MSEHI
DOCUMENT_FLOW_ALV_STRUC VRKME DOCUMENT_FLOW_ALV_STRUC MANDT T006 Units of Measurement MANDT
DOCUMENT_FLOW_ALV_STRUC VRKME DOCUMENT_FLOW_ALV_STRUC VRKME T006 Units of Measurement MSEHI
DOCUMENT_FLOW_ALV_STRUC WAERS DOCUMENT_FLOW_ALV_STRUC MANDT TCURC Currency Codes MANDT
DOCUMENT_FLOW_ALV_STRUC WAERS DOCUMENT_FLOW_ALV_STRUC WAERS TCURC Currency Codes WAERS