1. Home
  2. Resources
  3. SAP Tables
  4. BAPI2075_MASTERDATA_ALE - Create Order Master Data for BAPIs in ALE Scenario

SAP Table BAPI2075_MASTERDATA_ALE

Create Order Master Data for BAPIs in ALE Scenario

BAPI2075_MASTERDATA_ALE (Create Order Master Data for BAPIs in ALE Scenario) 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 BAPI2075_MASTERDATA_ALE to other SAP tables.

BAPI2075_MASTERDATA_ALE table fields

Field Data element Checktable Datatype Length Decimals
ORDERID Order Number AUFNR CHAR 12 0
ORDER_TYPE Order Type AUFART T003O CHAR 4 0
ORDER_CATG 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
EXT_ORD_NO External order number AUFEX CHAR 20 0
SHORT_TEXT Description AUFTEXT CHAR 40 0
ENTERED_BY Entered by AUFERFNAM CHAR 12 0
ENTER_DATE Created on AUFERFDAT DATS 8 0
ENTER_TIME Time created CO_INS_TIME TIMS 6 0
CHANGED_BY Last changed by AUFAENAM CHAR 12 0
CHANGE_DATE Change date for Order Master AUFAEDAT DATS 8 0
CHANGE_TIME Changed at CO_CHG_TIME TIMS 6 0
REFERENCE_ORDER Reference order number AUFREFNR CHAR 12 0
CO_AREA Controlling Area KOKRS TKA01 CHAR 4 0
COMP_CODE Company Code BUKRS T001 CHAR 4 0
BUS_AREA Business Area GSBER TGSB CHAR 4 0
PLANT Plant WERKS_D T001W CHAR 4 0
PROFIT_CTR Profit Center PRCTR CEPC CHAR 10 0
RESPCCTR Responsible cost center AUFKOSTV CSKS CHAR 10 0
LOCATION Location AUFSTORT T499S CHAR 10 0
LOCATION_PLANT Location plant AUFSOWRK T001W CHAR 4 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
REQUEST_CCTR Requesting cost center PS_AKSTL CSKS CHAR 10 0
REQUEST_COMP_CODE Requesting company code IM_ABUKRS T001 CHAR 4 0
SALES_ORD Sales Order Number KDAUF VBUK CHAR 10 0
S_ORD_ITEM Item Number in Sales Order KDPOS NUMC 6 0
TAXJURCODE Tax Jurisdiction TXJCD TTXJ CHAR 15 0
PLANINTEGRATED Indicator for Integrated Planning PLINT CHAR 1 0
X Yes
NULL No
STATISTICAL Identifier for statistical order AUFSTKZ CHAR 1 0
X Yes
NULL No
CCTR_POSTED Cost center to which costs are actually posted ST_KOSTL CSKS CHAR 10 0
REVENUES Identifier "Revenue posting allowed" ERLOESE CHAR 1 0
NULL not allowed
X allowed
PLAN_WITH_LINE_ITEMS Identifier for planning with line items PLGKZ CHAR 1 0
X Yes
NULL No
CURRENCY Order Currency AUFWAERS TCURC CUKY 5 0
ISO_CODE ISO currency code ISOCD CHAR 3 0
RES_ANAL_KEY Results Analysis Key ABGR_SCHL TKKAA CHAR 6 0
CSTG_SHEET Costing Sheet AUFKALSM T683 CHAR 6 0
OVERHEAD_KEY Overhead key AUFZSCHL CHAR 6 0
INTEREST_PROF Interest Profile for Project/Order Interest Calculation PS_ZSCHM TPI01 CHAR 7 0
APPLICANT Applicant AUFUSER0 CHAR 20 0
APPLICANT_PHONE Applicant's telephone number AUFUSER1 CHAR 20 0
PERSON_RESP Person responsible AUFUSER2 CHAR 20 0
PERSON_RESP_PHONE Telephone number of person in charge AUFUSER3 CHAR 20 0
ESTIMATED_COSTS Estimated Overall Costs of the Order for BAPIs AUFUSER4BAPI DEC 23 4
APPLICATION_DATE Application Date AUFUSER5 DATS 8 0
DEPARTMENT Department AUFUSER6 CHAR 15 0
DATE_WORK_BEGINS Work Start AUFUSER7 DATS 8 0
DATE_WORK_ENDS End of Work AUFUSER8 DATS 8 0
WORK_PERMIT Identifier for work permit issued AUFUSER9 CHAR 1 0
X Work permit issued
NULL
PROCESSING_GROUP Processing group AUFABKRS TKO08 NUMC 2 0
INVEST_PROFILE Investment measure profile IM_PROFIL TAPRF CHAR 6 0
SCALE Scale of investment objects IM_SIZECL TAIF5 CHAR 2 0
INV_REASON Reason for investment IZWEK T087I CHAR 2 0
ENVIR_INVEST Reason for environmental investment AM_UMWKZ T087K CHAR 5 0
ORDER_STATUS Order status AUFASTNR TKO03 NUMC 2 0
LAST_STAT_CHANGE Date of last status change AUFSTDAT DATS 8 0
REACHED_STATUS Status reached so far AUFESTNR TKO03 NUMC 2 0
PHASE_CREATE Phase "Order created" AUFPHAS0 CHAR 1 0
X Yes
NULL No
PHASE_RELEASE Phase "Order released" AUFPHAS1 CHAR 1 0
X Yes
NULL No
PHASE_COMPLETION Phase "order completed" AUFPHAS2 CHAR 1 0
X Yes
NULL No
PHASE_CLOSE Phase "order closed" AUFPHAS3 CHAR 1 0
X Yes
NULL No
PLN_RELEASE Planned release date AUFPDAT1 DATS 8 0
PLN_COMPLETION Planned completion date AUFPDAT2 DATS 8 0
PLN_CLOSE Planned closing date AUFPDAT3 DATS 8 0
DATE_RELEASE Release date AUFIDAT1 DATS 8 0
DATE_COMPLETION Technical completion date AUFIDAT2 DATS 8 0
DATE_CLOSE Close date AUFIDAT3 DATS 8 0
DISALLOWED_T_GRP Group of disallowed transactions AUFSPSET TKAVG CHAR 4 0
DELETION_FLAG Deletion flag AUFLOEKZ CHAR 1 0
X Yes
NULL No
OBJECTCLASS Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
LOGSYSTEM Logical System LOGSYSTEM TBDLS CHAR 10 0
JOINT_VENTURE Joint Venture JV_NAME T8JV CHAR 6 0
RECOVERY_IND Recovery Indicator JV_RECIND T8JJ CHAR 2 0
EQUITY_TYPE Equity type JV_ETYPE T8JE CHAR 3 0
JV_OBJECT_TYPE Joint Venture Object Type JV_OTYPE CHAR 4 0
JV_JIB_CLASS JIB/JIBE Class JV_JIBCL T8J6A CHAR 3 0
JV_JIB_SUB_CLASS_A JIB/JIBE Subclass A JV_JIBSA T8J6C CHAR 5 0
JV_ORIG_COST_OBJ JV original cost object JV_OR_CO CHAR 1 0
P object type for projects
O object type for orders
C object type for costcenters
NULL object type for current object
REQUEST_ORDER Requesting order AUFANFNR CHAR 12 0
FUNC_AREA Functional Area FKBER_SHORT CHAR 4 0
FUNC_AREA_LONG Functional Area FKBER CHAR 16 0
IN_CHARGE_USER Person Responsible for CO Internal Order VERAA_USER CHAR 12 0

BAPI2075_MASTERDATA_ALE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPI2075_MASTERDATA_ALE BUS_AREA SY MANDT TGSB Business Areas MANDT
BAPI2075_MASTERDATA_ALE BUS_AREA BAPI2075_MASTERDATA_ALE BUS_AREA TGSB Business Areas GSBER
BAPI2075_MASTERDATA_ALE CCTR_POSTED BAPI2075_MASTERDATA_ALE CCTR_POSTED CSKS Cost Center Master Data KOSTL
BAPI2075_MASTERDATA_ALE CCTR_POSTED * CSKS Cost Center Master Data DATBI
BAPI2075_MASTERDATA_ALE CCTR_POSTED SY MANDT CSKS Cost Center Master Data MANDT
BAPI2075_MASTERDATA_ALE CCTR_POSTED BAPI2075_MASTERDATA_ALE CO_AREA CSKS Cost Center Master Data KOKRS
BAPI2075_MASTERDATA_ALE COMP_CODE BAPI2075_MASTERDATA_ALE COMP_CODE T001 Company Codes BUKRS
BAPI2075_MASTERDATA_ALE COMP_CODE SY MANDT T001 Company Codes MANDT
BAPI2075_MASTERDATA_ALE CO_AREA SY MANDT TKA01 Controlling Areas MANDT
BAPI2075_MASTERDATA_ALE CO_AREA BAPI2075_MASTERDATA_ALE CO_AREA TKA01 Controlling Areas KOKRS
BAPI2075_MASTERDATA_ALE CSTG_SHEET SY MANDT T683 Pricing procedures MANDT
BAPI2075_MASTERDATA_ALE CSTG_SHEET 'A' T683 Pricing procedures KVEWE
BAPI2075_MASTERDATA_ALE CSTG_SHEET 'KA' T683 Pricing procedures KAPPL
BAPI2075_MASTERDATA_ALE CSTG_SHEET BAPI2075_MASTERDATA_ALE CSTG_SHEET T683 Pricing procedures KALSM
BAPI2075_MASTERDATA_ALE CURRENCY SY MANDT TCURC Currency Codes MANDT
BAPI2075_MASTERDATA_ALE CURRENCY BAPI2075_MASTERDATA_ALE CURRENCY TCURC Currency Codes WAERS
BAPI2075_MASTERDATA_ALE DISALLOWED_T_GRP * TKAVG Transaction groups OBJID
BAPI2075_MASTERDATA_ALE DISALLOWED_T_GRP BAPI2075_MASTERDATA_ALE DISALLOWED_T_GRP TKAVG Transaction groups GRUPPE
BAPI2075_MASTERDATA_ALE DISALLOWED_T_GRP * TKAVG Transaction groups ACTIVITY
BAPI2075_MASTERDATA_ALE DISALLOWED_T_GRP SY MANDT TKAVG Transaction groups MANDT
BAPI2075_MASTERDATA_ALE ENVIR_INVEST SY MANDT T087K Reason for investment protecting the environment MANDT
BAPI2075_MASTERDATA_ALE ENVIR_INVEST BAPI2075_MASTERDATA_ALE ENVIR_INVEST T087K Reason for investment protecting the environment UMWKZ
BAPI2075_MASTERDATA_ALE EQUITY_TYPE SY MANDT T8JE Investment Type MANDT
BAPI2075_MASTERDATA_ALE EQUITY_TYPE BAPI2075_MASTERDATA_ALE COMP_CODE T8JE Investment Type BUKRS
BAPI2075_MASTERDATA_ALE EQUITY_TYPE BAPI2075_MASTERDATA_ALE EQUITY_TYPE T8JE Investment Type ETYPE
BAPI2075_MASTERDATA_ALE INTEREST_PROF SY MANDT TPI01 Interest Profile MANDT
BAPI2075_MASTERDATA_ALE INTEREST_PROF BAPI2075_MASTERDATA_ALE INTEREST_PROF TPI01 Interest Profile ZSCHM
BAPI2075_MASTERDATA_ALE INVEST_PROFILE SY MANDT TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
BAPI2075_MASTERDATA_ALE INVEST_PROFILE BAPI2075_MASTERDATA_ALE INVEST_PROFILE TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
BAPI2075_MASTERDATA_ALE INV_REASON SY MANDT T087I Reason for investment MANDT
BAPI2075_MASTERDATA_ALE INV_REASON BAPI2075_MASTERDATA_ALE INV_REASON T087I Reason for investment IZWEK
BAPI2075_MASTERDATA_ALE JOINT_VENTURE SY MANDT T8JV Joint Venture MANDT
BAPI2075_MASTERDATA_ALE JOINT_VENTURE BAPI2075_MASTERDATA_ALE COMP_CODE T8JV Joint Venture BUKRS
BAPI2075_MASTERDATA_ALE JOINT_VENTURE BAPI2075_MASTERDATA_ALE JOINT_VENTURE T8JV Joint Venture VNAME
BAPI2075_MASTERDATA_ALE JV_JIB_CLASS BAPI2075_MASTERDATA_ALE COMP_CODE T8J6A JIB/JIBE Class BUKRS
BAPI2075_MASTERDATA_ALE JV_JIB_CLASS BAPI2075_MASTERDATA_ALE JV_JIB_CLASS T8J6A JIB/JIBE Class CLASS
BAPI2075_MASTERDATA_ALE JV_JIB_CLASS SY MANDT T8J6A JIB/JIBE Class MANDT
BAPI2075_MASTERDATA_ALE JV_JIB_SUB_CLASS_A SY MANDT T8J6C JIB/JIBE Subclass MANDT
BAPI2075_MASTERDATA_ALE JV_JIB_SUB_CLASS_A BAPI2075_MASTERDATA_ALE COMP_CODE T8J6C JIB/JIBE Subclass BUKRS
BAPI2075_MASTERDATA_ALE JV_JIB_SUB_CLASS_A BAPI2075_MASTERDATA_ALE JV_JIB_CLASS T8J6C JIB/JIBE Subclass CLASS
BAPI2075_MASTERDATA_ALE JV_JIB_SUB_CLASS_A BAPI2075_MASTERDATA_ALE JV_JIB_SUB_CLASS_A T8J6C JIB/JIBE Subclass SUBCLASS
BAPI2075_MASTERDATA_ALE LOCATION SY MANDT T499S Location MANDT
BAPI2075_MASTERDATA_ALE LOCATION BAPI2075_MASTERDATA_ALE PLANT T499S Location WERKS
BAPI2075_MASTERDATA_ALE LOCATION BAPI2075_MASTERDATA_ALE LOCATION T499S Location STAND
BAPI2075_MASTERDATA_ALE LOCATION_PLANT SY MANDT T001W Plants/Branches MANDT
BAPI2075_MASTERDATA_ALE LOCATION_PLANT BAPI2075_MASTERDATA_ALE LOCATION_PLANT T001W Plants/Branches WERKS
BAPI2075_MASTERDATA_ALE LOGSYSTEM BAPI2075_MASTERDATA_ALE LOGSYSTEM TBDLS Logical system LOGSYS
BAPI2075_MASTERDATA_ALE ORDER_STATUS SY MANDT TKO03 Order status CLIENT
BAPI2075_MASTERDATA_ALE ORDER_STATUS BAPI2075_MASTERDATA_ALE ORDER_TYPE TKO03 Order status ART
BAPI2075_MASTERDATA_ALE ORDER_STATUS BAPI2075_MASTERDATA_ALE ORDER_STATUS TKO03 Order status ASTNR
BAPI2075_MASTERDATA_ALE ORDER_TYPE SY MANDT T003O Order Types CLIENT
BAPI2075_MASTERDATA_ALE ORDER_TYPE BAPI2075_MASTERDATA_ALE ORDER_TYPE T003O Order Types AUART
BAPI2075_MASTERDATA_ALE PLANT SY MANDT T001W Plants/Branches MANDT
BAPI2075_MASTERDATA_ALE PLANT BAPI2075_MASTERDATA_ALE PLANT T001W Plants/Branches WERKS
BAPI2075_MASTERDATA_ALE PROCESSING_GROUP SY MANDT TKO08 Processing groups for orders CLIENT
BAPI2075_MASTERDATA_ALE PROCESSING_GROUP BAPI2075_MASTERDATA_ALE CO_AREA TKO08 Processing groups for orders KOKRS
BAPI2075_MASTERDATA_ALE PROCESSING_GROUP BAPI2075_MASTERDATA_ALE PROCESSING_GROUP TKO08 Processing groups for orders ABKRS
BAPI2075_MASTERDATA_ALE PROFIT_CTR BAPI2075_MASTERDATA_ALE PROFIT_CTR CEPC Profit Center Master Data Table PRCTR
BAPI2075_MASTERDATA_ALE PROFIT_CTR * CEPC Profit Center Master Data Table DATBI
BAPI2075_MASTERDATA_ALE PROFIT_CTR BAPI2075_MASTERDATA_ALE CO_AREA CEPC Profit Center Master Data Table KOKRS
BAPI2075_MASTERDATA_ALE PROFIT_CTR SY MANDT CEPC Profit Center Master Data Table MANDT
BAPI2075_MASTERDATA_ALE REACHED_STATUS SY MANDT TKO03 Order status CLIENT
BAPI2075_MASTERDATA_ALE REACHED_STATUS BAPI2075_MASTERDATA_ALE ORDER_TYPE TKO03 Order status ART
BAPI2075_MASTERDATA_ALE REACHED_STATUS BAPI2075_MASTERDATA_ALE REACHED_STATUS TKO03 Order status ASTNR
BAPI2075_MASTERDATA_ALE RECOVERY_IND BAPI2075_MASTERDATA_ALE RECOVERY_IND T8JJ Recovery Indicator RECID
BAPI2075_MASTERDATA_ALE RECOVERY_IND SY MANDT T8JJ Recovery Indicator MANDT
BAPI2075_MASTERDATA_ALE RECOVERY_IND BAPI2075_MASTERDATA_ALE COMP_CODE T8JJ Recovery Indicator BUKRS
BAPI2075_MASTERDATA_ALE REQUEST_CCTR SY MANDT CSKS Cost Center Master Data MANDT
BAPI2075_MASTERDATA_ALE REQUEST_CCTR BAPI2075_MASTERDATA_ALE CO_AREA CSKS Cost Center Master Data KOKRS
BAPI2075_MASTERDATA_ALE REQUEST_CCTR BAPI2075_MASTERDATA_ALE REQUEST_CCTR CSKS Cost Center Master Data KOSTL
BAPI2075_MASTERDATA_ALE REQUEST_CCTR * CSKS Cost Center Master Data DATBI
BAPI2075_MASTERDATA_ALE REQUEST_COMP_CODE SY MANDT T001 Company Codes MANDT
BAPI2075_MASTERDATA_ALE REQUEST_COMP_CODE BAPI2075_MASTERDATA_ALE REQUEST_COMP_CODE T001 Company Codes BUKRS
BAPI2075_MASTERDATA_ALE RESPCCTR SY MANDT CSKS Cost Center Master Data MANDT
BAPI2075_MASTERDATA_ALE RESPCCTR BAPI2075_MASTERDATA_ALE CO_AREA CSKS Cost Center Master Data KOKRS
BAPI2075_MASTERDATA_ALE RESPCCTR BAPI2075_MASTERDATA_ALE RESPCCTR CSKS Cost Center Master Data KOSTL
BAPI2075_MASTERDATA_ALE RESPCCTR * CSKS Cost Center Master Data DATBI
BAPI2075_MASTERDATA_ALE RES_ANAL_KEY SY MANDT TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
BAPI2075_MASTERDATA_ALE RES_ANAL_KEY BAPI2075_MASTERDATA_ALE RES_ANAL_KEY TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
BAPI2075_MASTERDATA_ALE SALES_ORD SY MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
BAPI2075_MASTERDATA_ALE SALES_ORD BAPI2075_MASTERDATA_ALE SALES_ORD VBUK Sales Document: Header Status and Administrative Data VBELN
BAPI2075_MASTERDATA_ALE SCALE BAPI2075_MASTERDATA_ALE SCALE TAIF5 Scale of investment objects SIZECL
BAPI2075_MASTERDATA_ALE SCALE SY MANDT TAIF5 Scale of investment objects MANDT
BAPI2075_MASTERDATA_ALE TAXJURCODE SY MANDT TTXJ Check Table for Tax Jurisdiction MANDT
BAPI2075_MASTERDATA_ALE TAXJURCODE * TTXJ Check Table for Tax Jurisdiction KALSM
BAPI2075_MASTERDATA_ALE TAXJURCODE BAPI2075_MASTERDATA_ALE TAXJURCODE TTXJ Check Table for Tax Jurisdiction TXJCD