AUFK_DRAFT

Transparent Table Application Table
89 Fields 1 CDS Views

Draft table for entity R_INTERNALORDERTP

AUFK_DRAFT is an SAP database table in S/4HANA. Draft table for entity R_INTERNALORDERTP. It contains 89 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_InternalOrderDraft view_entity from EXTENSION Internal Order - Extension

Fields (89)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY internalorder FINS_INT_AUFNR Internal Order
KEY internalorderdraftinternaluuid SYSUUID_C32 UUID
internalorderforedit FINS_INT_AUFNR Internal Order
internalorderdescription KLTXT Description
ordercategory AUFTYP Order category
businessarea FIS_RBUSA Business Area
controllingarea FIS_KOKRS Controlling Area
plant WERKS_D Plant
currency AUFWAERS Currency
isstatisticalorder FINS_CO_XAUFNR_STAT Statistical Order
referenceorder FIS_AUFREFNR Reference Order
salesorder KDAUF Sales Order
salesorderitem KDPOS Sales Ord. Item
wbselementinternalid PS_S4_PSPNR WBS Internal ID
wbselementexternalid PS_POSID_EDIT WBS Element
requestingcostcenter PS_AKSTL Req.cost center
requestingcompanycode IM_ABUKRS Req. co.code
requestingorder AUFANFNR Req. order
internalorderlocation FCO_IO_AUFSTORT Location
locationplant AUFSOWRK Location Plant
externalorder AUFEX Ext. order no.
actualpostedcostcenter FINS_ST_KOSTL Cost Center for Actual Costs Posting
costcenter FIS_KOSTL Cost Center
logicalsystem LOGSYSTEM Logical System
ordisusedinintegratedplanning FCO_PLINT Plan-Integrated Order
resultanalysisinternalid FCO_ABGR_SCHL Results Analysis Key
conditionusage KVEWE Usage
conditionapplication KAPPL Application
costingsheet AUFKALSM Costing Sheet
overheadcode FCO_AUFZSCHL Overhead Key
orderinterestcalcprofile FCO_IO_PS_ZSCHM Interest Profile for Order Interest Calculation
intordersettlementcostelement FCO_AUFKSTAR Settlement Cost Element
basicsettlementglaccount AUFSAKNR G/L Account
intorderindividualfield1value AUFUSER0 Applicant
intorderindividualfield2value AUFUSER1 Telephone
intorderindividualfield3value AUFUSER2 Person resp.
intorderindividualfield4value AUFUSER3 Telephone
intorderindividualfield5amount AUFUSER4 Estimated costs
intorderindividualfield6date AUFUSER5 ApplicDate
intorderindividualfield7value AUFUSER6 Department
intorderindividualfield8date AUFUSER7 Work Start
intorderindividualfield9date AUFUSER8 End of Work
intorderindividualfield10value AUFUSER9 Work permit
orderprocessinggroup FCO_AUFABKRS Processing Group
investmentprofile FCO_IM_PROFIL Investment Measure Profile
investmentscale FCO_IM_SIZECL Investment Scale
investmentreason IZWEK Invest. Reason
environmentalinvestmentreason AM_UMWKZ Envir. Invest.
jointventure JV_NAME Joint venture
jointventurerecoverycode JV_RECIND Recovery Ind.
jointventureequitytype JV_ETYPE Equity Type
jointventureoriginalcostobject JV_OR_CO Or. Cost Obj.
jointventureobjecttype JV_OTYPE JV Object Type
jointventureclass JV_JIBCL JIB/JIBE Class
jointventuresubclass JV_JIBSA JIB/JIBE SbClsA
internalorderisdeleted FCO_IO_MARKEDFORDELETION Marked for Deletion
internalorderdeletionflagisset FCO_IO_DELETIONFLAG Deletion Flag
creationdate AUFERFDAT Created On
creationtime CO_INS_TIME Time created
createdbyuser FIN_USNAM Created By
lastchangedbyuser AUFAENAM Changed By
lastchangedate AUFAEDAT Changed On
lastchangetime CO_CHG_TIME Changed At
lastchangedatetime TIMESTAMP Time Stamp
controllingobject J_OBJNR Object number
companycode FIS_BUKRS Company Code
profitcenter FIS_PRCTR Profit Center
functionalarea FM_FAREA Functional Area
controllingobjectclass FIS_SCOPE_CV_CONV Object Class
ordertype AUFART Order Type
responsiblecostcenter FIN_IO_AUFKOSTV Responsible Cost Center
internalorderresponsibleuser FCO_VERAA_USER User Responsible
commitmentsmgmtactvtnstatus FINS_CO_IO_OBLIGO Commitment Update
revenuepostingisallowed ERLOESE Revenues
controllingobjectstatus J_STATUS Status
intordersystemstatusshortname J_TXT04 Status
internalordersystemstatusname J_TXT30 Status
internalorderislocked FCO_IO_LOCK Lock
intordsettlementruleiscreated FCO_IO_SETTL_RULE_CREATED Settlement Rule Created
taxjurisdiction FIS_TXJCD Tax Jurisdiction
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
zzbauleiter ZBAULEITER
eew_aufk_ps_dummy DUMMY Dummy function in length 1

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.

-- Draft table for entity R_INTERNALORDERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AUFK_DRAFT (
    MANDT,                           -- Client [MANDT]
    INTERNALORDER,                   -- Internal Order [FINS_INT_AUFNR]
    INTERNALORDERDRAFTINTERNALUUID,  -- UUID [SYSUUID_C32]
    INTERNALORDERFOREDIT,            -- Internal Order [FINS_INT_AUFNR]
    INTERNALORDERDESCRIPTION,        -- Description [KLTXT]
    ORDERCATEGORY,                   -- Order category [AUFTYP]
    BUSINESSAREA,                    -- Business Area [FIS_RBUSA]
    CONTROLLINGAREA,                 -- Controlling Area [FIS_KOKRS]
    PLANT,                           -- Plant [WERKS_D]
    CURRENCY,                        -- Currency [AUFWAERS]
    ISSTATISTICALORDER,              -- Statistical Order [FINS_CO_XAUFNR_STAT]
    REFERENCEORDER,                  -- Reference Order [FIS_AUFREFNR]
    SALESORDER,                      -- Sales Order [KDAUF]
    SALESORDERITEM,                  -- Sales Ord. Item [KDPOS]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [PS_S4_PSPNR]
    WBSELEMENTEXTERNALID,            -- WBS Element [PS_POSID_EDIT]
    REQUESTINGCOSTCENTER,            -- Req.cost center [PS_AKSTL]
    REQUESTINGCOMPANYCODE,           -- Req. co.code [IM_ABUKRS]
    REQUESTINGORDER,                 -- Req. order [AUFANFNR]
    INTERNALORDERLOCATION,           -- Location [FCO_IO_AUFSTORT]
    LOCATIONPLANT,                   -- Location Plant [AUFSOWRK]
    EXTERNALORDER,                   -- Ext. order no. [AUFEX]
    ACTUALPOSTEDCOSTCENTER,          -- Cost Center for Actual Costs Posting [FINS_ST_KOSTL]
    COSTCENTER,                      -- Cost Center [FIS_KOSTL]
    LOGICALSYSTEM,                   -- Logical System [LOGSYSTEM]
    ORDISUSEDININTEGRATEDPLANNING,   -- Plan-Integrated Order [FCO_PLINT]
    RESULTANALYSISINTERNALID,        -- Results Analysis Key [FCO_ABGR_SCHL]
    CONDITIONUSAGE,                  -- Usage [KVEWE]
    CONDITIONAPPLICATION,            -- Application [KAPPL]
    COSTINGSHEET,                    -- Costing Sheet [AUFKALSM]
    OVERHEADCODE,                    -- Overhead Key [FCO_AUFZSCHL]
    ORDERINTERESTCALCPROFILE,        -- Interest Profile for Order Interest Calculation [FCO_IO_PS_ZSCHM]
    INTORDERSETTLEMENTCOSTELEMENT,   -- Settlement Cost Element [FCO_AUFKSTAR]
    BASICSETTLEMENTGLACCOUNT,        -- G/L Account [AUFSAKNR]
    INTORDERINDIVIDUALFIELD1VALUE,   -- Applicant [AUFUSER0]
    INTORDERINDIVIDUALFIELD2VALUE,   -- Telephone [AUFUSER1]
    INTORDERINDIVIDUALFIELD3VALUE,   -- Person resp. [AUFUSER2]
    INTORDERINDIVIDUALFIELD4VALUE,   -- Telephone [AUFUSER3]
    INTORDERINDIVIDUALFIELD5AMOUNT,  -- Estimated costs [AUFUSER4]
    INTORDERINDIVIDUALFIELD6DATE,    -- ApplicDate [AUFUSER5]
    INTORDERINDIVIDUALFIELD7VALUE,   -- Department [AUFUSER6]
    INTORDERINDIVIDUALFIELD8DATE,    -- Work Start [AUFUSER7]
    INTORDERINDIVIDUALFIELD9DATE,    -- End of Work [AUFUSER8]
    INTORDERINDIVIDUALFIELD10VALUE,  -- Work permit [AUFUSER9]
    ORDERPROCESSINGGROUP,            -- Processing Group [FCO_AUFABKRS]
    INVESTMENTPROFILE,               -- Investment Measure Profile [FCO_IM_PROFIL]
    INVESTMENTSCALE,                 -- Investment Scale [FCO_IM_SIZECL]
    INVESTMENTREASON,                -- Invest. Reason [IZWEK]
    ENVIRONMENTALINVESTMENTREASON,   -- Envir. Invest. [AM_UMWKZ]
    JOINTVENTURE,                    -- Joint venture [JV_NAME]
    JOINTVENTURERECOVERYCODE,        -- Recovery Ind. [JV_RECIND]
    JOINTVENTUREEQUITYTYPE,          -- Equity Type [JV_ETYPE]
    JOINTVENTUREORIGINALCOSTOBJECT,  -- Or. Cost Obj. [JV_OR_CO]
    JOINTVENTUREOBJECTTYPE,          -- JV Object Type [JV_OTYPE]
    JOINTVENTURECLASS,               -- JIB/JIBE Class [JV_JIBCL]
    JOINTVENTURESUBCLASS,            -- JIB/JIBE SbClsA [JV_JIBSA]
    INTERNALORDERISDELETED,          -- Marked for Deletion [FCO_IO_MARKEDFORDELETION]
    INTERNALORDERDELETIONFLAGISSET,  -- Deletion Flag [FCO_IO_DELETIONFLAG]
    CREATIONDATE,                    -- Created On [AUFERFDAT]
    CREATIONTIME,                    -- Time created [CO_INS_TIME]
    CREATEDBYUSER,                   -- Created By [FIN_USNAM]
    LASTCHANGEDBYUSER,               -- Changed By [AUFAENAM]
    LASTCHANGEDATE,                  -- Changed On [AUFAEDAT]
    LASTCHANGETIME,                  -- Changed At [CO_CHG_TIME]
    LASTCHANGEDATETIME,              -- Time Stamp [TIMESTAMP]
    CONTROLLINGOBJECT,               -- Object number [J_OBJNR]
    COMPANYCODE,                     -- Company Code [FIS_BUKRS]
    PROFITCENTER,                    -- Profit Center [FIS_PRCTR]
    FUNCTIONALAREA,                  -- Functional Area [FM_FAREA]
    CONTROLLINGOBJECTCLASS,          -- Object Class [FIS_SCOPE_CV_CONV]
    ORDERTYPE,                       -- Order Type [AUFART]
    RESPONSIBLECOSTCENTER,           -- Responsible Cost Center [FIN_IO_AUFKOSTV]
    INTERNALORDERRESPONSIBLEUSER,    -- User Responsible [FCO_VERAA_USER]
    COMMITMENTSMGMTACTVTNSTATUS,     -- Commitment Update [FINS_CO_IO_OBLIGO]
    REVENUEPOSTINGISALLOWED,         -- Revenues [ERLOESE]
    CONTROLLINGOBJECTSTATUS,         -- Status [J_STATUS]
    INTORDERSYSTEMSTATUSSHORTNAME,   -- Status [J_TXT04]
    INTERNALORDERSYSTEMSTATUSNAME,   -- Status [J_TXT30]
    INTERNALORDERISLOCKED,           -- Lock [FCO_IO_LOCK]
    INTORDSETTLEMENTRULEISCREATED,   -- Settlement Rule Created [FCO_IO_SETTL_RULE_CREATED]
    TAXJURISDICTION,                 -- Tax Jurisdiction [FIS_TXJCD]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    ZZBAULEITER,                     -- ZBAULEITER
    EEW_AUFK_PS_DUMMY,               -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, INTERNALORDER, INTERNALORDERDRAFTINTERNALUUID)
);

Learn More