SAP Table VSAUFK_CN - Version: Order master data

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
VSNMR X VSNMR CHAR 3 12 0 Number or description of a version
AUFNR X AUFNR CHAR 15 12 0 AUFK Order Number
AUART AUFART CHAR 27 4 0 T003O Order Type
AUTYP AUFTYP NUMC 31 2 0 Order category
REFNR AUFREFNR CHAR 33 12 0 AUFK Reference order number
ERNAM AUFERFNAM CHAR 45 12 0 Entered by
ERDAT AUFERFDAT DATS 57 8 0 Created on
AENAM AUFAENAM CHAR 65 12 0 Last changed by
AEDAT AUFAEDAT DATS 77 8 0 Change date for Order Master
KTEXT AUFTEXT CHAR 85 40 0 Description
LTEXT AUFLTEXT CHAR 125 1 0 Long Text Exists
BUKRS BUKRS CHAR 126 4 0 T001 Company Code
WERKS WERKS_D CHAR 130 4 0 T001W Plant
GSBER GSBER CHAR 134 4 0 TGSB Business Area
KOKRS KOKRS CHAR 138 4 0 TKA01 Controlling Area
CCKEY CCKEY CHAR 142 23 0 Cost collector key
KOSTV AUFKOSTV CHAR 165 10 0 Responsible cost center
STORT AUFSTORT CHAR 175 10 0 T499S Location
SOWRK AUFSOWRK CHAR 185 4 0 T001W Location plant
ASTKZ AUFSTKZ CHAR 189 1 0 Identifier for statistical order
WAERS AUFWAERS CUKY 190 5 0 TCURC Order Currency
ASTNR AUFASTNR NUMC 195 2 0 TKO03 Order status
STDAT AUFSTDAT DATS 197 8 0 Date of last status change
ESTNR AUFESTNR NUMC 205 2 0 TKO03 Status reached so far
PHAS0 AUFPHAS0 CHAR 207 1 0 Phase "Order created"
PHAS1 AUFPHAS1 CHAR 208 1 0 Phase "Order released"
PHAS2 AUFPHAS2 CHAR 209 1 0 Phase "order completed"
PHAS3 AUFPHAS3 CHAR 210 1 0 Phase "order closed"
PDAT1 AUFPDAT1 DATS 211 8 0 Planned release date
PDAT2 AUFPDAT2 DATS 219 8 0 Planned completion date
PDAT3 AUFPDAT3 DATS 227 8 0 Planned closing date
IDAT1 AUFIDAT1 DATS 235 8 0 Release date
IDAT2 AUFIDAT2 DATS 243 8 0 Technical completion date
IDAT3 AUFIDAT3 DATS 251 8 0 Close date
OBJID CCOBJID CHAR 259 1 0 Object ID
VOGRP AUFSPSET CHAR 260 4 0 Group of disallowed transactions
LOEKZ AUFLOEKZ CHAR 264 1 0 Deletion flag
PLGKZ PLGKZ CHAR 265 1 0 Identifier for planning with line items
KVEWE KVEWE CHAR 266 1 0 T681V Usage of the condition table
KAPPL KAPPL CHAR 267 2 0 T681A Application
KALSM AUFKALSM CHAR 269 6 0 T683 Costing Sheet
ZSCHL AUFZSCHL CHAR 275 6 0 Overhead key
ABKRS AUFABKRS NUMC 281 2 0 Processing group
KSTAR AUFKSTAR CHAR 283 10 0 CSKA Settlement cost element
KOSTL AUFKOSTL CHAR 293 10 0 Cost center for basic settlement
SAKNR AUFSAKNR CHAR 303 10 0 G/L account for basic settlement
SETNM AUFSETNM CHAR 313 12 0 Allocation set
CYCLE ST_KOSTL CHAR 325 10 0 Cost center to which costs are actually posted
SDATE SDATE DATS 335 8 0 Start Date
SEQNR AUFSEQNR NUMC 343 4 0 Sequence number
USER0 AUFUSER0 CHAR 347 20 0 Applicant
USER1 AUFUSER1 CHAR 367 20 0 Applicant's telephone number
USER2 AUFUSER2 CHAR 387 20 0 Person responsible
USER3 AUFUSER3 CHAR 407 20 0 Telephone number of person in charge
USER4 AUFUSER4 CURR 427 11 2 Estimated total costs of order
USER5 AUFUSER5 DATS 433 8 0 Application Date
USER6 AUFUSER6 CHAR 441 15 0 Department
USER7 AUFUSER7 DATS 456 8 0 Work Start
USER8 AUFUSER8 DATS 464 8 0 End of Work
USER9 AUFUSER9 CHAR 472 1 0 Identifier for work permit issued
OBJNR J_OBJNR CHAR 473 22 0 ONR00 Object number
PRCTR PRCTR CHAR 495 10 0 Profit Center
PSPEL PS_PSP_ELE NUMC 505 8 0 PRPS Work breakdown structure element (WBS element)
AWSLS AWSLS CHAR 513 6 0 Variance Key
ABGSL ABGR_SCHL CHAR 519 6 0 Results Analysis Key
TXJCD TXJCD CHAR 525 15 0 TTXJ Tax Jurisdiction
FUNC_AREA FKBER CHAR 540 16 0 Functional Area
SCOPE SCOPE_CV CHAR 556 2 0 Object Class
PLINT PLINT CHAR 558 1 0 Indicator for Integrated Planning
KDAUF KDAUF CHAR 559 10 0 Sales Order Number
KDPOS KDPOS NUMC 569 6 0 Item Number in Sales Order
AUFEX AUFEX CHAR 575 20 0 External order number
IVPRO IM_PROFIL CHAR 595 6 0 TAPRF Investment measure profile
LOGSYSTEM LOGSYSTEM CHAR 601 10 0 Logical System
FLG_MLTPS CO_MLTPS CHAR 611 1 0 Order with multiple items
ABUKR IM_ABUKRS CHAR 612 4 0 T001 Requesting company code
AKSTL PS_AKSTL CHAR 616 10 0 Requesting cost center
SIZECL IM_SIZECL CHAR 626 2 0 TAIF5 Scale of investment objects
IZWEK IZWEK CHAR 628 2 0 Reason for investment
UMWKZ AM_UMWKZ CHAR 630 5 0 T087K Reason for environmental investment
KSTEMPF CO_KSTEMPF CHAR 635 1 0 Indicator: Direct cost collector
ZSCHM PS_ZSCHM CHAR 636 7 0 Interest Profile for Project/Order Interest Calculation
PKOSA PKOSA_D CHAR 643 12 0 AUFK Cost collector for production process PROCNR
ANFAUFNR AUFANFNR CHAR 655 12 0 AUFK Requesting order
PROCNR CKML_PROCNR NUMC 667 12 0 Production alternative
PROTY CKML_PROZESS_TYP CHAR 679 4 0 Process Category (Procurement/Consumption)
RSORD RSORD CHAR 683 1 0 Refurbishment order indicator (PM)
BEMOT BEMOT CHAR 684 2 0 TBMOT Accounting Indicator
ADRNRA AD_ADDRNUM CHAR 686 10 0 Address number
ERFZEIT CO_INS_TIME TIMS 696 6 0 Time created
AEZEIT CO_CHG_TIME TIMS 702 6 0 Changed at
CSTG_VRNT CK_KLVAR CHAR 708 4 0 TCK03 Costing Variant
COSTESTNR CK_KALNR NUMC 712 12 0 Cost Estimate Number for Cost Est. w/o Qty Structure
VERAA_USER VERAA_USER CHAR 724 12 0 USR02 User Responsible for CO Internal Order
VNAME JV_NAME CHAR 736 6 0 T8JV Joint Venture
RECID JV_RECIND CHAR 742 2 0 Recovery Indicator
ETYPE JV_ETYPE CHAR 744 3 0 T8JE Equity Type
OTYPE JV_OTYPE CHAR 747 4 0 Joint Venture Object Type
JV_JIBCL JV_JIBCL CHAR 751 3 0 T8J6A JIB/JIBE Class
JV_JIBSA JV_JIBSA CHAR 754 5 0 T8J6C JIB/JIBE Subclass A
JV_OCO JV_OR_CO CHAR 759 1 0 JV original cost object
ORGKEY AUFNR CHAR 760 12 0 AUFK Order Number
EXT_AUFNR AUFNR CHAR 772 12 0 AUFK Order Number
INACT VSINACT CHAR 784 1 0 Version inactive indicator
AUFK_STATUS ACTCMB_DELE INT1 785 3 0 ACTCMB_TAB Status Combination
/CUM/INDCU /CUM/INDCU CHAR 786 1 0 CU: Order is Used for Compatible Units
/CUM/CMNUM /CUM/CMNUM CHAR 787 12 0 CU: Construction Measure Number
/CUM/AUEST /CUM/AUEST CHAR 799 1 0 CU: Automatic Copy of Estimated Costs
/CUM/DESNUM /CUM/DESNUM CHAR 800 12 0 CU: Design Number
VAPLZ GEWRK CHAR 812 8 0 Main work center for maintenance tasks
WAWRK WERGW CHAR 820 4 0 T001W Plant associated with main work center
FERC_IND FE_IND CHAR 824 4 0 FERC_C7 Regulatory indicator