AUFK

Transparent Table Application Table
97 Fields 67 CDS Views

Order master data

AUFK is an SAP database table in S/4HANA. Order master data. It contains 97 fields. 67 CDS views read from this table.

CDS Views using this table (67)

ViewTypeJoinVDMDescription
/MERP/PP_PO_COMPONENT view inner Production Order Component
/MERP/PP_PO_HEADER view from Production Order Header
/MERP/PP_PO_QUANTITY_ISSUE view from PO Quantity Deviation Calculation
ARUN_I_F_LINE view left_outer Production Order Item level selection
ARUN_PROD_REQMT view from Production order components
ARUN_SSD_PREV view left_outer Get supply specific SO preview
ARUN_SUP_SP_SO view left_outer Get supply specific SO online
atpc_dvol_peak_creation_tstmp view left_outer Data Volume for Peaks with Creation Timestamp
CRMS4_IU_C_UMOCON view_entity left_outer Utilities Service Order by Con. Object
CTE_CDS_FIN_MON_IO view inner CDS View for Monotoring Internal Order export to Concur
CTE_CDS_FIN_MON_MO view inner CDS View for Monotoring MO exp to Concur
CTE_CDS_FIN_MON_NW view inner CDS View for Monotoring NA exp to Concur
CTE_CDS_FIN_MON_PP view inner CDS View for Monotoring PP exp to Concur
E_LogisticsOrder view_entity from EXTENSION Logistics Order - Extension
E_ProcessOrder view from EXTENSION Process Order - Extension
E_ProductCostCtrlgOrder view from EXTENSION Include View for PCC Order
E_ProductionOrder view_entity from EXTENSION Production Order Header - Extension
F_Mmim_OrderItem_Vh view inner Value Help Order Items
FCO_COR_HSL_DER view left_outer HSL Corr. for Stat. Records in CO: Derivation of CurrKey
Fco_Mig_Check_Coep11_L2 view left_outer Check ACDOCA-records against COEP-records with WRTTP=11
FCO_MIG_DERIV_P view left_outer CO Delta Entries (COSP+COSS) - Derivation of Dep. Fields
FINOC_CHECK_REC_01_PRCTRS view_entity left_outer Org. Change: PRCTRS of RE Contracts
FINOC_RULE_NWA_BASE view inner O/C Rule: Network Activity Base
FINOC_RULE_NWA_EXAMPLE view inner Organizational Change: Customer Rule NWA
FINOC_RULE_ORD_BASE view from Orgl Change-Rule: Order Base
FINOC_RULE_ORD_EXAMPLE view inner Organizational Change: Customer Rule ORD
fins_prctr_of_object_acdoca view left_outer Derive PRCTR & PPRCTR for ACDOCA object
FINS_REV_REC_FLOWSOMD view left_outer Flow of documents, Object Summary
FMLV_MLAUFCR_UCT_UNION view inner ML Currency Table for Order History w. cor. CURTP
FMLV_MLAUFCRH_UCT_UNION view inner History table for summerized MLAUFCR data w. correct CURPT
FMLV_MLAUFKEPH_UCT_UNION view inner ML: Cost Component Split for Order History w. correct CURTP
FMLV_MLAUFKEPHH_UCT_UNION view inner History table for summarized MLAUFKEPH data w. correct CURTP
I_BR_OrderText view from BASIC Brazil Order - Text
I_ControllingOrder view from BASIC Controlling Order
I_FldLogsProcRcptMaintOrd view inner BASIC Maintenance orders for process receipts FL
I_InternalOrder view from BASIC Internal Order
I_JointVentureOrderData view from BASIC Joint Venture Order Data
I_JVANetworkActivity view_entity inner BASIC JVA Network Activity
I_LogisticsOrder view from BASIC Logistics Order
I_NetworkActivity view inner BASIC Network Activity Details
I_NetworkActivityForCostReport view inner BASIC Network Activity For Cost Report
I_OrdCostRollUpReplnmtElmnt view_entity from COMPOSITE Replenishment element in order cost roll up
I_OrdCostRollUpReplnmtElmnt view_entity union_all COMPOSITE Replenishment element in order cost roll up
I_OrderBasic view from BASIC Order Header Basic
I_OrderDocumentedGoodsMovement view inner BASIC Documented Goods Movement of an Order
I_OrderMasterDataWithCrcy view from BASIC Order Master Data
I_OrdMstrData view from BASIC Order Master Data
I_ProductCostCtrlgOrder view from BASIC Product Cost Controlling Order
I_ProjectNetworkBasicData view inner BASIC Project Network Basic Data
I_ProjSchedMaintOrderData view inner BASIC Project Schedule Data for Work Order
I_SrvcDocFUPInternalOrder view from BASIC Follow-Up Internal Order of Srvc Transac
I_SrvcDocInternalOrderVH view from BASIC Internal Order Search Help
I_SupDmndAllDocProdnOrdBsc view from BASIC Basic View for Production Order
I_TripOrderNumberVH view from BASIC Order Number Value Help
Mmim_MatDocDocFlow view inner Material Documents Document Flow
P_ChgImpactNtwkOrderStatus view from COMPOSITE
P_EBWObjectMaxStatus view from BASIC
P_EventBasedOrder view from BASIC
P_IncgOutgProjectNetworkStdVH view from BASIC
P_MaintOrderDuration view inner BASIC
P_ONROR view inner BASIC
P_Ra_Objects view left_outer BASIC
P_RO_SAFTOrderText view from BASIC Order Text
SHSM_IAOM_CRM_AUFK view from Internal Orders Created from CRM Service
SHSM_IAOM_OM_AUFK view from CO Production Orders Created from OM
SHSM_V_NPACT view inner cds view for search help NPACT
v_coep_v2_l1a_view view left_outer LOCAL: Line Items COEP for statistical postings

Fields (97)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY aufnr aufnr Order
auart aufart Order Type
autyp auftyp Order category
refnr aufrefnr Order
ernam auferfnam Entered By
erdat auferfdat Created On
aenam aufaenam Changed By
aedat aufaedat Changed On
ktext auftext Description
ltext aufltext Long Txt Exists
bukrs bukrs Company Code
werks werks_d Plant
gsber gsber Business Area
kokrs kokrs CO Area
cckey cckey Cost Collector
kostv aufkostv Resp. cost cntr
stort aufstort Location
sowrk aufsowrk Location Plant
astkz aufstkz Statistical
waers aufwaers Currency
astnr aufastnr Status
stdat aufstdat Status Change
estnr aufestnr Reached Status
phas0 aufphas0 Created
phas1 aufphas1 Released
phas2 aufphas2 Completed
phas3 aufphas3 Closed
pdat1 aufpdat1 Planned release
pdat2 aufpdat2 PlannedCompltn
pdat3 aufpdat3 Planned.clo.dat
idat1 aufidat1 Release
idat2 aufidat2 Tech.Completion
idat3 aufidat3 Close
objid ccobjid Object ID
vogrp aufspset DisTranGroup
loekz aufloekz Deletion Flag
plgkz plgkz Plan Line Items
kvewe kvewe Usage
kappl kappl Application
kalsm aufkalsm Costing Sheet
zschl aufzschl Overhead key
abkrs aufabkrs Process. group
kstar aufkstar Settlement CE
kostl aufkostl Cost Center
saknr aufsaknr G/L Account
setnm aufsetnm Allocation Set
cycle st_kostl CCtr: True post
sdate sdate Valid From
seqnr aufseqnr Sequence Number
user0 aufuser0 Applicant
user1 aufuser1 Telephone
user2 aufuser2 Person resp.
user3 aufuser3 Telephone
user4 aufuser4 Estimated costs
user5 aufuser5 ApplicDate
user6 aufuser6 Department
user7 aufuser7 Work Start
user8 aufuser8 End of Work
user9 aufuser9 Work permit
objnr j_objnr Object number
prctr prctr Profit Center
pspel ps_psp_ele WBS Element
awsls awsls Variance key
abgsl abgr_schl RA Key
ebw_key fco_ebw_key Event-Based Proc Key
eb_post fco_eb_post Event-Based Posting
txjcd txjcd Tax Jur.
func_area fkber Functional Area
scope scope_cv Object Class
plint plint Integ. Planning
kdauf kdauf Sales Order
kdpos kdpos Sales Ord. Item
aufex aufex Ext. order no.
ivpro im_profil Invest. Profile
logsystem logsystem Logical System
flg_mltps co_mltps Multiple Items
abukr im_abukrs Req. co.code
akstl ps_akstl Req.cost center
sizecl im_sizecl Scale
izwek izwek Invest. Reason
umwkz am_umwkz Envir. Invest.
kstempf co_kstempf Cost collector
zschm ps_zschm Interest Prof.
pkosa pkosa_d Cost Collector
anfaufnr aufanfnr Req. order
procnr ckml_f_procnr Prod. Proc. No.
proty ckml_prozess_typ Process Cat.
rsord rsord Refurbishment
bemot bemot AcctIndicator
adrnra ad_addrnum Address Number
erfzeit co_ins_time Time created
aezeit co_chg_time Changed At
cstg_vrnt ck_klvar Costing Variant
costestnr ck_kalnr Cost EstimateNo
veraa_user veraa_user PersonResponsible
order_proc_mode orderprocmode Procurement Mode

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Order master data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AUFK (
    MANDT,            -- Client [mandt]
    AUFNR,            -- Order [aufnr]
    AUART,            -- Order Type [aufart]
    AUTYP,            -- Order category [auftyp]
    REFNR,            -- Order [aufrefnr]
    ERNAM,            -- Entered By [auferfnam]
    ERDAT,            -- Created On [auferfdat]
    AENAM,            -- Changed By [aufaenam]
    AEDAT,            -- Changed On [aufaedat]
    KTEXT,            -- Description [auftext]
    LTEXT,            -- Long Txt Exists [aufltext]
    BUKRS,            -- Company Code [bukrs]
    WERKS,            -- Plant [werks_d]
    GSBER,            -- Business Area [gsber]
    KOKRS,            -- CO Area [kokrs]
    CCKEY,            -- Cost Collector [cckey]
    KOSTV,            -- Resp. cost cntr [aufkostv]
    STORT,            -- Location [aufstort]
    SOWRK,            -- Location Plant [aufsowrk]
    ASTKZ,            -- Statistical [aufstkz]
    WAERS,            -- Currency [aufwaers]
    ASTNR,            -- Status [aufastnr]
    STDAT,            -- Status Change [aufstdat]
    ESTNR,            -- Reached Status [aufestnr]
    PHAS0,            -- Created [aufphas0]
    PHAS1,            -- Released [aufphas1]
    PHAS2,            -- Completed [aufphas2]
    PHAS3,            -- Closed [aufphas3]
    PDAT1,            -- Planned release [aufpdat1]
    PDAT2,            -- PlannedCompltn [aufpdat2]
    PDAT3,            -- Planned.clo.dat [aufpdat3]
    IDAT1,            -- Release [aufidat1]
    IDAT2,            -- Tech.Completion [aufidat2]
    IDAT3,            -- Close [aufidat3]
    OBJID,            -- Object ID [ccobjid]
    VOGRP,            -- DisTranGroup [aufspset]
    LOEKZ,            -- Deletion Flag [aufloekz]
    PLGKZ,            -- Plan Line Items [plgkz]
    KVEWE,            -- Usage [kvewe]
    KAPPL,            -- Application [kappl]
    KALSM,            -- Costing Sheet [aufkalsm]
    ZSCHL,            -- Overhead key [aufzschl]
    ABKRS,            -- Process. group [aufabkrs]
    KSTAR,            -- Settlement CE [aufkstar]
    KOSTL,            -- Cost Center [aufkostl]
    SAKNR,            -- G/L Account [aufsaknr]
    SETNM,            -- Allocation Set [aufsetnm]
    CYCLE,            -- CCtr: True post [st_kostl]
    SDATE,            -- Valid From [sdate]
    SEQNR,            -- Sequence Number [aufseqnr]
    USER0,            -- Applicant [aufuser0]
    USER1,            -- Telephone [aufuser1]
    USER2,            -- Person resp. [aufuser2]
    USER3,            -- Telephone [aufuser3]
    USER4,            -- Estimated costs [aufuser4]
    USER5,            -- ApplicDate [aufuser5]
    USER6,            -- Department [aufuser6]
    USER7,            -- Work Start [aufuser7]
    USER8,            -- End of Work [aufuser8]
    USER9,            -- Work permit [aufuser9]
    OBJNR,            -- Object number [j_objnr]
    PRCTR,            -- Profit Center [prctr]
    PSPEL,            -- WBS Element [ps_psp_ele]
    AWSLS,            -- Variance key [awsls]
    ABGSL,            -- RA Key [abgr_schl]
    EBW_KEY,          -- Event-Based Proc Key [fco_ebw_key]
    EB_POST,          -- Event-Based Posting [fco_eb_post]
    TXJCD,            -- Tax Jur. [txjcd]
    FUNC_AREA,        -- Functional Area [fkber]
    SCOPE,            -- Object Class [scope_cv]
    PLINT,            -- Integ. Planning [plint]
    KDAUF,            -- Sales Order [kdauf]
    KDPOS,            -- Sales Ord. Item [kdpos]
    AUFEX,            -- Ext. order no. [aufex]
    IVPRO,            -- Invest. Profile [im_profil]
    LOGSYSTEM,        -- Logical System [logsystem]
    FLG_MLTPS,        -- Multiple Items [co_mltps]
    ABUKR,            -- Req. co.code [im_abukrs]
    AKSTL,            -- Req.cost center [ps_akstl]
    SIZECL,           -- Scale [im_sizecl]
    IZWEK,            -- Invest. Reason [izwek]
    UMWKZ,            -- Envir. Invest. [am_umwkz]
    KSTEMPF,          -- Cost collector [co_kstempf]
    ZSCHM,            -- Interest Prof. [ps_zschm]
    PKOSA,            -- Cost Collector [pkosa_d]
    ANFAUFNR,         -- Req. order [aufanfnr]
    PROCNR,           -- Prod. Proc. No. [ckml_f_procnr]
    PROTY,            -- Process Cat. [ckml_prozess_typ]
    RSORD,            -- Refurbishment [rsord]
    BEMOT,            -- AcctIndicator [bemot]
    ADRNRA,           -- Address Number [ad_addrnum]
    ERFZEIT,          -- Time created [co_ins_time]
    AEZEIT,           -- Changed At [co_chg_time]
    CSTG_VRNT,        -- Costing Variant [ck_klvar]
    COSTESTNR,        -- Cost EstimateNo [ck_kalnr]
    VERAA_USER,       -- PersonResponsible [veraa_user]
    ORDER_PROC_MODE,  -- Procurement Mode [orderprocmode]
    PRIMARY KEY (MANDT, AUFNR)
);

Learn More