Profile "Extraction preparation tables"

tables for fiscal year determination and index review

Name Description Type

Extraction preparation tables tables for fiscal year determination and index review Profile

DD17S R/3 S_SECINDEX: secondary indexes, fields Table

FIELDNAME Field Name Field

INDEXNAME Unique Index ID in a Table Field

POSITION Position of the field in the table Field

SQLTAB Table Name Field

T000 Clients Table

ADRNR Character Field Length = 10 Field

CCCATEGORY Client control: Role of client (production, test,...) Field

CCCOPYLOCK Protection reg. client copy program and comparison tools Field

CCCORACTIV Changes and transports for client-specific objects Field

CCIMAILDIS Client Control: CATT und eCATT Authorization Field

CCNOCASCAD Client control: No client cascade for upgrade import Field

CCNOCLIIND Maintenance authorization for objects in all clients Field

CCORIGCONT Recording Client for Switch BC Sets Field

CCSOFTLOCK Client control: Soft Lock Required (Planned for 4.0) Field

CCTEMPLOCK Client control: Indicator that client is temporarily locked Field

CHANGEDATE Date of Last Change Field

CHANGEUSER Last Changed by Field

LOGSYS Logical system Field

MANDT Client Field

MTEXT Client name Field

MWAER Standard currency throughout client Field

ORT01 City Field

T001 Company Codes Table

BUKRS Company Code Field

BUTXT Name of Company Code or Company Field

KKBER Credit control area Field

KTOPL Chart of Accounts Field

LAND1 Country Key Field

Page 1
Name Description Type

MANDT Client Field

MWSKA Output Tax Code for Non-Taxable Transactions Field

MWSKV Input Tax Code for Non-Taxable Transactions Field

ORT01 City Field

PERIV Fiscal Year Variant Field

RCOMP Company Field

SPRAS Language Key Field

STCEG VAT Registration Number Field

TXJCD Jurisdiction for tax calculation - tax jurisdiction code Field

UMKRS Sales/Purchases Tax Group Field

WAERS Currency Key Field

T009 Fiscal Year Variants Table

MANDT Client Field

PERIV Fiscal Year Variant Field

XJABH Indicator: Fiscal year variants year-dependent ? Field

XKALE Indicator: Determine periods like calendar year ? Field

T009B Fiscal year variant periods Table

BDATJ Posting date YYYY Field

BUMON Posting date calendar month Field

BUTAG Calendar day from the posting date Field

MANDT Client Field

PERIV Fiscal Year Variant Field

RELJR Year shift relative to the current year Field

Page 2
 Profile "Customizing"
Tables for customizing and application control settings

Name Description Type

Customizing Tables for customizing and application control settings Profile

T001K Valuation area Table

BDIFP Stock correction tolerance Field

BUKRS Company Code Field

BWKEY Valuation Area Field

BWMOD Valuation Grouping Code Field

EFREJ Start of validity period f. del. costs in price diff. acct Field

ERKLAERKOM Explanation Facility for Material Ledger Active/Inactive Field

MANDT Client Field

MLAST Material Price Determination: Control Field

MLASV Price Determination is Binding in Valuation Area Field

MLBWA Material ledger activated in valuation area Field

MLBWV Material ledger activated in valuation area (compulsory) Field

MLCCS Active Actual Cost Component Split Field

PRSFR Price Release Field

UPROF Retail revalution profile Field

WBPRO Profile for value-based inventory management Field

X2FDO Two FI documents with purchase account Field

XBKNG Negative stocks in valuation area allowed Field

XEFRE Del. costs to price diff. acct when purch. acct active Field

XEWRX Post purchase account with receipt value Field

XLBPD Price difference posting in GR for subcontract oder Field

XVKBW Sales price valuation active Field

DD07T DD: Texts for Domain Fixed Values (Language-Dependent) Table

DDLANGUAGE Language Key Field

DDTEXT Short Text for Fixed Values Field

DOMNAME Domain name Field

DOMVALUE_L Values for Domains: Single Value / Upper Limit Field

NRIV Number Range Intervals Table

CLIENT Client Field

Page 3
Name Description Type

EXTERNIND Internal ( ) or external (X) number range flag Field

FROMNUMBER From number Field

NRLEVEL Number range status Field

NRRANGENR Number range number Field

OBJECT Name of number range object Field

SUBOBJECT Number range object subobject value Field

TONUMBER To number Field

TOYEAR To fiscal year Field

PAHI History of system, DB and SAP parameter Table

PARDATE Current Date of Application Server Field

PARNAME Parameter name Field

PARSTATE State of parameter (original, changed, active) Field

PARTYPE Parameter type (OP system, DB, SAP) Field

PARVALUE Parameter value Field

SYSTEMID SAP System ID Field

T001L Storage Locations Table

DISKZ Storage location MRP indicator Field

KUNNR Account Number of Customer Field

LGOBE Description of Storage Location Field

LGORT Storage Location Field

LIFNR Vendor Account Number Field

MANDT Client Field

OIB_TNKASSIGN Silo Managament: Tank assignment indicator Field

OIG_ITRFL TD in-transit flag Field

OIH_LICNO License number for untaxed stock Field

PARLG Partner storage location of the handling unit Field

SPART Division Field

VKORG Sales Organization Field

VSTEL Shipping Point/Receiving Point Field

VTWEG Distribution Channel Field

Page 4
Name Description Type

WERKS Plant Field

XBLGO Storage location authorization for goods movements active Field

XBUFX Freezing book inventory bal. allowed in stor. loc. Field

XHUPF Handling unit requirement Field

XLONG Negative stocks allowed in storage location Field

XRESS Storage location is allocated to resource (storage resource) Field

T001W Plants/Branches Table

ACHVM Field

ADRNR Field

AWSLS Field

BEDPL Field

BETOL Field

BWKEY Valuation Area Field

BZIRK Field

BZQHL Field

CHAZV Field

CHAZV_OLD Field

CITYC Field

COUNC Field

DEP_STORE Field

DVSART Field

EKORG Field

FABKL Field

FPRFW Field

IWERK Field

J_1BBRANCH Field

KKOWK Field

KORDB Field

KUNNR Field

LAND1 Field

Page 5
Name Description Type

LET01 Field

LET02 Field

LET03 Field

LIFNR Field

MANDT Client Field

MGVLAREVAL Field

MGVLAUPD Field

MGVUPD Field

MISCH Field

NAME1 Field

NAME2 Field

NODETYPE Field

NSCHEMA Field

OIHCREDIPI Field

OIHVTYPE Field

OILIVAL Field

ORT01 Field

PFACH Field

PKOSA Field

PSTLZ Field

REGIO Field

SOURCING Field

SPART Field

SPRAS Field

STORETYPE Field

STRAS Field

TAXIW Field

TXJCD Field

TXNAM_MA1 Field

TXNAM_MA2 Field

Page 6
Name Description Type

TXNAM_MA3 Field

VKORG Field

VLFKZ Field

VSTEL Field

VTBFI Field

VTWEG Field

WERKS Plant Field

WKSOP Field

ZONE1 Field

T003 Document Types Table

BLART Document Type Field

MANDT Client Field

NUMKR Number range Field

T003T Document Type Texts Table

BLART Document Type Field

LTEXT Document Type Description Field

MANDT Client Field

SPRAS Language Key Field

T005 Countries Table

KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) Field

LAND1 Country Key Field

LKVRZ Short Name for Foreign Trade Statistics Field

MANDT Client Field

SPRAS Language Key Field

WAERS Country currency Field

XEGLD Indicator: European Union Member? Field

T005T Country Names Table

LAND1 Country Key Field

LANDX Country Name Field

LANDX50 Country Name (Max. 50 Characters) Field

Page 7
Name Description Type

MANDT Client Field

NATIO Nationality Field

NATIO50 Nationality (Max. 50 Characters) Field

PRQ_SPREGT Super region per country text Field

SPRAS Language Key Field

T007S Tax Code Names Table

KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) Field

MANDT Client Field

MWSKZ Sales Tax Code Field

SPRAS Language Key Field

TEXT1 Name for value-added tax Field

T011 Financial Statement Versions Table

AKTVA Item key representing the assets Field

ANHNG Item key that represents notes to financial statements Field

ASPRA Alternative languages Field

DSPRA Language Key Field

ERGAK Item key representing the line item net loss Field

ERGGV Fin.statement key representing the P+L profit item Field

ERGPA Fin.statement key representing the net profit/yr Field

KTOPL Financial Statement Version Uses Only One Chart of Accounts Field

MANDT Client Field

PSSVA Item Key Representing the Liabilities Field

VERSN Financial Statement Version Field

XAUTO Indicator: automatically allocate item keys Field

XERGS Financial Statement Version Uses Group Chart of Accounts Field

XFBER Indicator: assignment of functional areas is permitted Field

ZUORD Item key representing the non-assignable accounts Field

T011T Financial statement version names Table

MANDT Client Field

SPRAS Language Key Field

Page 8
Name Description Type

VERSN Financial Statement Version Field

VSTXT Financial Statement Version Name Field

T014 Credit control areas Table

ALLCC Indicator: Is posting possible for all company codes? Field

CTLPC Credit Management: Risk Category New Customer Field

KKBER Credit control area Field

KLIMK Credit limit (default setting, unless maintained by cust.) Field

MANDT Client Field

PERIV Fiscal Year Variant of Credit Control Area Field

SBGRP Credit management representatives group for new customers Field

STAFO Credit update for open order/delivery/billing document value Field

WAERS Currency Key Field

T023T Material Group Descriptions Table

MANDT Client Field

MATKL Material Group Field

SPRAS Language Key Field

WGBEZ Material Group Description Field

WGBEZ60 Long text describing the material group Field

T030K Tax Accounts Determination Table

KONTH G/L Account Number Field

KONTS G/L Account Number Field

KTOPL Chart of Accounts Field

KTOSL Transaction Key Field

MANDT Client Field

MWSKZ Sales Tax Code Field

T030W Transaction Key Names Table

KTEXT Description of Acct Determinatn Keys for Acct Determinatn Field

KTOSL Transaction Key Field

KTXT2 Description of Acct Determinatn Keys for Acct Determinatn Field

KTXT3 Description of Acct Determinatn Keys for Acct Determinatn Field

Page 9
Name Description Type

LTEXT Description Field

SPRAS Language Key Field

T041C Reasons for Reverse Posting Table

MANDT Client Field

STGRD Reason for Reversal Field

T041CT Reasons for Reverse Posting (Name) Table

MANDT Client Field

SPRAS Language Key Field

STGRD Reason for Reversal Field

TXT40 Text, length 40 Field

T043 Assign Accounting Clerks --> Tolerance Group Table

INVPR Tolerance group for persons processing phys.inv. differences Field

MANDT Client Field

USNAM User Name Field

T052 Terms of Payment Table

KOART Account Type of the Customer/Vendor Field

MANDT Client Field

ZPRZ1 Cash Discount Percentage Rate Field

ZPRZ2 Cash Discount Percentage Rate Field

ZTAG1 Days from Baseline Date for Payment Field

ZTAG2 Days from Baseline Date for Payment Field

ZTAG3 Days from Baseline Date for Payment Field

ZTERM Terms of Payment Key Field

T052U Own Explanations for Terms of Payment Table

MANDT Client Field

SPRAS Language Key Field

TEXT1 Own Explanation of Term of Payment Field

ZTERM Terms of Payment Key Field

T074T Special G/L Indicator Names Table

KOART Account Type Field

Page 10
Name Description Type

KTEXT Short Text for Special G/L Indicator Field

LTEXT Long Text for Special G/L Indicators Field

MANDT Client Field

SHBKZ Special G/L Indicator Field

SPRAS Language Key Field

T077S G/L account groups Table

BISNR Number of G/L Account (Upper Area Limit) Field

FAUSS Field status definition for G/L accounts Field

KTOKS G/L Account Group Field

KTOPL Chart of Accounts Field

LAYOUT_0 G/L account master record: Layout for "Central Processing" Field

LAYOUT_P G/L master data: Layout for "chart of accts processsing" Field

LAYOUT_S G/L master data: Layout for "company code processing" Field

MANDT Client Field

VONNR Number of G/L account (lower area limit) Field

T077Z Account Group Names (Table T077S) Table

KTOKS G/L Account Group Field

KTOPL Chart of Accounts Field

MANDT Client Field

SPRAS Language Key Field

TXT30 Account Group Name Field

T093 Real and derived depreciation areas Table

ABVOR1 +/- Sgn of real dep. area in screen layout rule of der. area Field

ABVOR2 +/- Sgn of real dep. area in screen layout rule of der. area Field

ABVOR3 +/- Sgn of real dep. area in screen layout rule of der. area Field

ABVOR4 +/- Sgn of real dep. area in screen layout rule of der. area Field

ABWBER Different Depreciation Area for Account Determination Field

AFABE1 Real depreciation area Field

AFABE2 Real depreciation area Field

AFABE3 Real depreciation area Field

Page 11
Name Description Type

AFABE4 Real depreciation area Field

AFABEO Indicator: Depreciation areas are OK Field

AFABER Depreciation area real or derived Field

AFAPL Chart of depreciaton for asset valuation Field

ANTEI1 Proportion of real depreciation area in derived dep.area Field

ANTEI2 Proportion of real depreciation area in derived dep.area Field

ANTEI3 Proportion of real depreciation area in derived dep.area Field

ANTEI4 Proportion of real depreciation area in derived dep.area Field

AREA_USAGE_IND Purpose of Depreciation Area Field

BUHBKT Post to G/L account Field

CORRBE Depreciation area used for modification Field

GAFABER Cross-system depreciation area Field

LDGRP_GL Target Ledger Group Field

MANDT Client Field

VIEW0 Asset view Field

VIEW1 Asset view Field

VIEW2 Asset view Field

VIEW3 Asset view Field

VIEW4 Asset view Field

VIEW5 Asset view Field

VIEW6 Asset view Field

VZAAFA +/- Sign for unplanned depreciation Field

VZANSW +/- Sign for acquisition value Field

VZAWMA +/- Sign for transfer of reserves(acquis.val.reducing dep.) Field

VZINDA +/- Sign for revaluation of ordinary depreciation Field

VZINDW +/- Sign for revaluation Field

VZINVZ +/- Sign for investment grants Field

VZNAFA +/- Sign for ordinary depreciation Field

VZREST +/- Sign for net book value Field

VZSAFA +/- Sign for special depreciation Field

Page 12
Name Description Type

VZZINS +/- Sign for interest Field

XAFABER Treat Derived Depreciation Area As Real Area Field

XBEREP Asset Accounting: Depreciation area for reporting purposes Field

XSTORE Indicator: Store real depreciation area Field

T093C Company codes in Asset Accounting Table

AFAPL Chart of depreciaton for asset valuation Field

AFBLRT Document type for depreciation posting Field

APERBLRT Document Type for Periodic Posting of APC Values Field

APROF Settlement profile for assets under construction Field

BKRAKT Cost center check across company codes Field

BUKRS Company Code Field

BUKRSN Company code for number assignment Field

DATUM Value date for legacy asset data transferred Field

J_1AAOFFCL Official document class for Asset Movements Field

KZRBWB Indicator post net book value for retirement Field

LGJAHR Last fiscal year opened by the fiscal year change Field

MANDT Client Field

MONMIT First day of the second half of the month Field

MWSKZAA Output tax code - asset is exempt from tax (unused) Field

MWSKZVA Input tax code - Assets without input tax Field

PERIV Fiscal Year Variant Field

TKUND Retention period of asset and asset values (cust. specific) Field

TTECH Min. retention period of assets and asset values Field

VARBZD Variant for determining asset value date Field

VRMAFB Depreciation area for net worth tax valuation Field

XANLE Indicator: Original line item for proof of origin Field

XANUEB Staus of asset data transfer in the company code Field

XNOSKONTO Subsequent Capitalization of Discount Not Allowed Field

XREBUW Ind: Enter net book value during legacy data transfer Field

XRUMPF Indicator: Shortened fiscal year Field

Page 13
Name Description Type

XVRSKU Recalculate cumulative insurance base value Field

XZORG Indicator: Time-independent management of organiz. units Field

T093T Names for real and derived depreciation areas Table

AFABER Depreciation area real or derived Field

AFAPL Chart of depreciaton for asset valuation Field

AFBKTX Short name for depreciation area Field

AFBTXT Name of depreciation area Field

MANDT Client Field

SPRAS Language Key Field

T100 Messages Table

ARBGB Application Area Field

MSGNR Message number Field

SPRSL Language Key Field

TEXT Message Text Field

T134T Material Type Descriptions Table

MANDT Client Field

MTART Material Type Field

MTBEZ Description of material type Field

SPRAS Language Key Field

T156 Movement Type Table

BWART Movement Type (Inventory Management) Field

MANDT Client Field

SHKZG Debit/Credit Indicator Field

T156T Movement Type Text Table

BTEXT Movement Type Text (Inventory Management) Field

BWART Movement Type (Inventory Management) Field

KZBEW Movement Indicator Field

KZVBR Consumption Posting Field

KZZUG Receipt Indicator Field

MANDT Client Field

Page 14
Name Description Type

SOBKZ Special Stock Indicator Field

SPRAS Language Key Field

T159L Default values for inventory management and physical invent. Table

MANDT Client Field

WERKS Plant Field

XAEBL Change Document in Physical Inventory Field

T161 Purchasing Document Types Table

BSART Purchasing Document Type Field

BSTYP Purchasing Document Category Field

MANDT Client Field

T161T Texts for Purchasing Document Types Table

BATXT Short Description of Purchasing Document Type Field

BSART Purchasing Document Type Field

BSTYP Purchasing Document Category Field

MANDT Client Field

SPRAS Language Key Field

T163 Item Categories in Purchasing Document Table

BFKNZ Inventory management indicator for purchasing Field

J_1BITMTYP Nota Fiscal Item Type Field

KNTZU Indicator: Account assignment required Field

MANDT Client Field

MATNO Indicator: Material number required Field

PSTYP Item Category in Purchasing Document Field

REPOS Invoice Receipt Indicator Field

REPOV Invoice receipt indicator binding Field

STAFO Update group for statistics update Field

WEPOS Goods Receipt Indicator Field

WEPOV Goods receipt indicator binding Field

WEUNB Goods Receipt, Non-Valuated Field

WEUNV Good receipt non-valuated (binding) Field

Page 15
Name Description Type

T173 Routes: Mode of Transport for Each Shipping Type Table

MANDT Client Field

VKTRA Mode of transport Field

VSART Shipping type Field

VSGRP Shipping type procedure group Field

T173T Routes: Mode of Transport by Shipping Type: Texts Table

BEZEI Description of the Shipping Type Field

MANDT Client Field

SPRAS Language Key Field

VSART Shipping type Field

T685 Conditions: Types Table

DATVO Date proposed as valid-to date Field

DTVOB Proposed starting date for the rebate validity period Field

J_3GBUARTB Posting Type - Debited Party Field

J_3GBUARTL Posting Type - Providing Party Field

J_3GPRAEND Take Price Change Over Time Into Account Field

KAPPL Application Field

KOZGF Access sequence Field

KSCHL Condition Type Field

KVEWE Usage of the condition table Field

MANDT Client Field

T685T Conditions: Types: Texts Table

KAPPL Application Field

KSCHL Condition Type Field

KVEWE Usage of the condition table Field

MANDT Client Field

SPRAS Language Key Field

VTEXT Name Field

T880 Global Company Data (for KONS Ledger) Table

CITY City where company is located Field

Page 16
Name Description Type

CURR Local currency Field

LANGU Language Key Field

MANDT Client Field

MCOMP Master data company code Field

NAME1 Company name Field

NAME2 Name of company 2 Field

RCOMP Company Field

TABW Asset transaction types Table

BLART Default document type for transaction type Field

BWASL Asset Transaction Type Field

MANDT Client Field

TABWT Asset transaction types texts Table

BWASL Asset Transaction Type Field

BWATXT Asset transaction type name Field

MANDT Client Field

SPRAS Language Key Field

TBSL Posting Key Table

BSCHL Posting Key Field

FAUS1 Account/Posting Key Field Selection Field

FAUS2 Account/Posting Key Field Selection Field

KOART Account Type Field

MANDT Client Field

SHKZG Debit/Credit Indicator Field

STBSL Posting Key for Reversal/Reverse Entry Field

XSONU Indicator: Posting key for special G/L transactions Field

XUMSW Indicator: Sales-related item ? Field

XZAHL Indicator: Is the posting key used in a payment transaction? Field

TBSLT Posting Key Names Table

BSCHL Posting Key Field

LTEXT Name of the Posting Key Field

Page 17
Name Description Type

MANDT Client Field

SPRAS Language Key Field

UMSKZ Special G/L Indicator Field

TCURC Currency Codes Table

ALTWR Alternative key for currencies Field

GDATU Date until which the currency is valid Field

ISOCD ISO currency code Field

MANDT Client Field

WAERS Currency Key Field

XPRIMARY Primary SAP Currency Code for ISO Code Field

TCURT Currency Code Names Table

KTEXT Short text Field

LTEXT Long Text Field

MANDT Client Field

SPRAS Language Key Field

WAERS Currency Key Field

TCURX Decimal Places in Currencies Table

CURRDEC Number of decimal places Field

CURRKEY Currency Key Field

TPFID Description of SAP instance Table

APSERVER Application server Field

BANAME Operation Mode Field

CMPON Components of instance Field

HOMEDIR Home directory of SAP instance Field

HOST Host name Field

INSTNAME SAP instance name Field

OPSYS uname of an application server, corresponds to SY-OPSYS Field

PASSWD Password of instance owner Field

PFINST Instance profile name Field

PFLINSNAME Name of profile for system parameterization Field

Page 18
Name Description Type

PFLSTRNAME Name of profile for system parameterization Field

PFSTART Instance Startup Profile Field

SRVBTC Instance service: Background processing Field

SRVDIA Instance service: Online Field

SRVENQ Instance service: Lock management Field

SRVGW Instance service: Gateway Field

SRVMSG Instance service: Message server Field

SRVRES1 Instance service: Online Field

SRVRES2 Instance service: Online Field

SRVSPO Instance service: Spooler Field

SRVV2 Instance service: V2 update Field

SRVVB Instance service: Update Process Field

STATUS Status of instance description Field

SYSNAME SAP System Name Field

SYSNR SAP system number (00 - 99) Field

TYPE SAP instance type Field

USERNAME User name of instance owner Field

WPNO Total no. of work processes for application server Field

WPNOBTC No. background work processes for instance Field

WPNOBTCA No. of work processes to be kept free for backgrnd. process. Field

WPNODIA No. dialog work processes of instance Field

WPNOENQ No. of enqueue work work processes of instance Field

WPNORES1 No. dialog work processes of instance Field

WPNORES2 No. dialog work processes of instance Field

WPNOSPO No. of spool work processes of instance Field

WPNOV2 Number of V2 update workprocesses of an instance Field

WPNOVB Number of update work processes on an instance Field

TSTCT Transaction Code Texts Table

SPRSL Language Key Field

TCODE Transaction Code Field

Page 19
Name Description Type

TTEXT Transaction Text Field

TTYP Object Types for Accounting Table

AWTYP Reference Transaction Field

FUNCTION Name of function module Field

REMOTE Method called remotely Field

STRUC Structure Description of Organizational Field Field

TVAK Sales Document Types Table

AAUART1 Alternative sales document type Field

AAUART2 Alternative sales document type Field

ABDIS MRP for delivery schedule types Field

ABGRU_IN Reason for rejection, internally assigned by system Field

ABRUF_PART Check partner authorizations Field

ABRVW Usage Indicator Field

AD01AURET Order type billing request for retroactive billing Field

AD04NUMFLG Document type relevant for numbering Field

AKTFI Promo determination Field

ATPGM Type of group calls for the availability check Field

AUARA Proposal for order type for the subsequent function Field

AUART Sales Document Type Field

AUFAK Order type for request for billing Field

AUGRP Version Number Component Field

AWAHR Sales probability Field

BABSS Document payment guarantee procedure Field

BEZOB Reference mandatory Field

BPROC ATP: Business Transaction for ATP Field

BSTVO Propose current date as purchase order date Field

CCPGR Payment cards: Checking group - Sales document Field

CMGRA Credit group sales order Field

CPFREE Suppress Copy Control Field

DABAR Default release type Field

Page 20
Name Description Type

DATVO Propose current date as requested delivery date Field

DELCF Commitment dates switch for calculation rule Field

DIAFE Dialog message for incompletion Field

DIAPA Dialog message for product attribute Field

EMPFI Receiving point determination Field

ERMAT Material entry control Field

ERNAM Name of Person who Created the Object Field

EXCBC Boycott list check of standard partners f.Foreign Trade - On Field

EXCEM Embargo check of standard partners for Foreign Trade - On Field

EXCLG Indicator: Save legal control log Field

EXCOK Carry out legal control for sales document type Field

EXDIA Automatic dialog in document for legal control Field

EXMOD Time interval for legal control Field

EXTNR_RMA Use document number to enter external PO number Field

FAKSK Block Field

FAUPR Shipment Cost Information Profile Field

FEHGR Incompletion procedure for sales document Field

FELDK Field selection group for document header Field

FKAIV Billing type for intercompany billing Field

FKARA Proposed billing type for an order-related billing document Field

FKARV Proposed billing type for a delivery-related billing doc. Field

FKTKT Activity type for the actions procedure Field

FPART Billing/Invoicing Plan Type Field

GUEBGV Proposed valid-from date Field

HITYP_PR Hierarchy type for pricing Field

HNWAG On/off switch for messages about quotations Field

HNWGK On/off switch for master contract messages Field

HNWK2 Add ref. to all contracts partner is authorized to release Field

HNWKM On/off switch for messages about outline agreements Field

INCPO Increment of item number in the SD document Field

Page 21
Name Description Type

INCUP Increment of sub-item number in sales document Field

INFLS Read customer-material info record ? Field

ISM_CONTRACT IS-M: Contract Usage Field

ISM_WERKSDET Plant Determination Type in Order Field

J_1AFCTYPE Category of Credit Memo Billing Document Field

J_1BNFTYPE Nota Fiscal Type Field

J_3GKBAUL ETM-Relevant Indicator Field

KALAU Procedure for material exclusion Field

KALLI Procedure for material listing Field

KALPG Product List eligibility: Procedure for product lists Field

KALSM Output determination procedure Field

KALSU Procedure for material determination Field

KALVG Document procedure (for determining pricing procedure) Field

KALVL Procedure for material listing Field

KAPPL Application for output conditions Field

KLIMP Check credit limit Field

KOPGR Screen sequence group for document header & item Field

KORLI Delivery type for correction deliveries Field

KPRGBZ Date type (day, week, month, interval) Field

KSCHL Output Type Field

KSCHL_KO Condition type for copying costs from line items Field

KSKPF Pricing procedure for contract conditions at header level Field

KSPOS Pricing procedure for contract conditions at item level Field

KUNN0 Customer number ZERO (0) allowed Field

LFARV Default delivery type Field

LIFSK Delivery block (document header) Field

LIFSM Delivery block Field

LISOF Create delivery immediately Field

MANDT Client Field

MILL_SE_ATNAM Characteristic name Field

Page 22
Name Description Type

NO_BUTTON Number of Generate Button in Browser Field

NUMKE Number range in the case of external number assignment Field

NUMKI Number range in the case of internal number assignment Field

OBJART_HIN Archiving document type when you create a document Field

OBJART_VER Archiving document type used when you change a document Field

OICFKARTDI Differential invoice billing type proposal Field

OICSEGI Quantity schedule creation permitted Field

OIFCONTI IS-Oil MRN indicator for additional contract data Field

OIISOILPD IS-Oil plant determination indicator: x=yes blank=no Field

OIMSG_DAT Message type for contract restrictions validity period Field

OIMSG_PRD Message type for product with contract restrictions Field

OIMSG_QTY Message type for contract restrictions quantity Field

OIMSG_SHP Message type for contract restrictions ship-to party Field

OIMSG_TRM Message type for contract restrictions payment terms Field

OIMSG_UOM Message type for contract restrictions unit of measure Field

OIPARVW1 Partner Function Field

OIPARVW2 Partner Function Field

OIPARVW3 Partner Function Field

OIPARVW4 Partner Function Field

OIPARVW5 Partner Function Field

OIPARVW6 Partner Function Field

OIPARVW7 Partner Function Field

OIPARVW8 Partner Function Field

OIPARVW9 Partner Function Field

OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) Field

OIPRTFNC Partner function Field

OISUBHEAD Subscreen number (header) Field

OISUBITEM Subscreen number (item level) Field

OIUSEREXIT Number of the routine used for copying Field

PARGR Partner Determination Procedure Field

Page 23
Name Description Type

PRBST Check purchase order number Field

PRDATV Proposed pricing date based on the requested dlv.date Field

PUSH_GRP Update lower level contract - on/off Field

PVBSM Document procedure for determining product proposal proced. Field

RFPA_SW Route schedule switch for order types Field

RPART Payment card plan type Field

SCHEME_GRP Referencing requirement: Procedure Field

SPAPO Division in sales order item comes from the material Field

SPAPR Check division Field

SPERR Sales document block Field

STGAK Statistics group for sales document type Field

STSMA Status Profile Field

TDID Text ID Field

TENUR Carry out backwards delivery scheduling only Field

TRTRM Activate transportation scheduling Field

TRVOG Transaction group Field

TXN08 Number of the standard text Field

TXTGR Text determination procedure Field

UEVOR F-code default for overview screen Field

UMFNG Display Range Field

UNITSALE Unit Sales Field

VARIANT Transaction variant Field

VBKLT Sales document indicator (for display in TVAK only) Field

VBTYP SD document category Field

VCLASSIFIC Contract classification SD customizing Field

VERLI Procedure for material listing Field

VLAUF Lead Time in Days Field

VPROF Profile with default values for contract data Field

VSBED Shipping conditions Field

VSTRM Activate delivery scheduling Field

Page 24
Name Description Type

VTERL Contract data allowed for sales order type Field

XASSORTMENT IS-M: Allowed Contract Type for Assortments (Retail) Field

XZEROORDER IS-M: Generate Order with Quantity 0 Field

TVAKT Sales Document Types: Texts Table

AUART Sales Document Type Field

BEZEI Description Field

MANDT Client Field

SPRAS Language Key Field

TXT_BUTTON Text on Browser Button Field

TVFS Billing: Reasons for Blocking Table

FAKSP Block Field

MANDT Client Field

TVFST Billing : Blocking Reason Texts Table

FAKSP Block Field

MANDT Client Field

SPRAS Language Key Field

VTEXT Description Field

TVLK Delivery Types Table

AUFER A sales order is required as basis for delivery Field

AVERP Automatic packing using packing proposal Field

BORGR_LIFEX_EDIA Type of Error Message when Online ID is not Unique Field

BORGR_LIFEX_EEDI Error Message Type when ID Transferred by EDI Is Not Unique Field

BORGR_LIFEX_MUST Required Entry Field

BORGR_LIFEX_UNQ Uniqueness of the External ID Field

BORGR_SODET Automatic PO Determination Field

BZOPS Staging area determination at delivery item level? Field

CMGRK Credit group for picking Field

CMGRL Delivery credit group Field

CMGRW Goods issue credit group Field

DAART Default order type for deliveries without reference to order Field

Page 25
Name Description Type

DBTCH Distribution Mode for the Delivery Field

DSFAD Delivery Split for Additional Partners Field

EDI_WEIGHTVOL Adopt Weight and Volume from IDoc Field

ERNAM Name of Person who Created the Object Field

EXCBC Boycott list check of standard partners f.Foreign Trade - On Field

EXCEM Embargo check of standard partners for Foreign Trade - On Field

EXCLG Indicator: Save legal control log Field

EXCOK Carry out legal control for sales document type Field

FEHGR Incompletion procedure for sales document Field

HOLD_DATA Indicator Whether Inbound Deliveries on Hold Are Allowed Field

INCPO Increment of item number in the SD document Field

J_1ADOCCLS Document Class Field

KALSM Output determination procedure Field

KALSP Shipping: Pricing procedure Field

KAPPL Application for output conditions Field

KOPGR Screen sequence group for document header & item Field

KSCHL Output Type Field

LFART Delivery Type Field

LNSPL Perform Delivery Split According to Warehouse Number Field

MANDT Client Field

NEUTE Reschedule deliveries Field

NUMKE Number range in the case of external number assignment Field

NUMKI Number range in the case of internal number assignment Field

NUMKIRULE Rule for Determining Number Ranges for Decentralized LES Field

OIDELDCM Active flag f. Document Change Management (DCM) f.deliveries Field

PARGR Partner Determination Procedure Field

PM_ITEM_GEN Generation of Delivery Items for HU Packaging Materials Field

POBED Requirement for item that does not refer to a sales order Field

PROFIDNETZ Network profile Field

QHERK Inspection Lot Origin Field

Page 26
Name Description Type

REGGR Dummy function Field

REGLG Rule for determining the storage location for picking Field

REGTB Rule for determining door and material staging area Field

RFPL_SW Route schedule switch for delivery types Field

ROUTF New route determination: with or without a check? Field

SPE_ENABLE_VALID Enable Validation for All Deliveries within VL60 Field

SPE_NR_RECYCLING Enable Number Reuse for Unchecked/Temporary Deliveries Field

SPE_NUMKT Number Range for Temporary Inbound Deliveries Field

SPOFI Rules for Shipping Point Determination Field

STGAK Statistics group for sales document type Field

TDID Text ID Field

TDIIX Transportation relevant indicator for delivery Field

TDSPRAS Language Key Field

TRSPG Shipment Blocking Reason Field

TSEGTP Event group time segment delivery header Field

TXN08 Number of the standard text Field

TXTGR Text determination procedure Field

UEVOR F-code default for overview screen Field

UMFNG Display Range Field

UVEIB Doc. pricing procedure for incomplete export/import data Field

VBTYP SD document category Field

WAAUS Dummy function in length 1 Field

TVLKT Delivery: Types: Texts Table

LFART Delivery Type Field

MANDT Client Field

SPRAS Language Key Field

VTEXT Description Field

Page 27
 Profile "FI tables"
Finance tables

Name Description Type

FI tables Finance tables Profile

BKPF Accounting Document Header Table

AWKEY Reference Key Field

AWTYP Reference Transaction Field

BELNR Accounting Document Number Field

BKTXT Document Header Text Field

BLART Document Type Field

BLDAT Document Date in Document Field

BSTAT Document Status Field

BUDAT Posting Date in the Document Field

BUKRS Company Code Field

CPUDT Day On Which Accounting Document Was Entered Field

CPUTM Time of Entry Field

DBBLG Recurring Entry Document Number Field

GJAHR Fiscal Year Field

GRPID Batch Input Session Name Field

MANDT Client Field

MONAT Fiscal Period Field

STBLG Reverse Document Number Field

STGRD Reason for Reversal Field

STJAH Reverse document fiscal year Field

TCODE Transaction Code Field

USNAM User Name Field

WAERS Currency Key Field

XBLNR Reference Document Number Field

XBLNR_ALT Alternative Reference Number Field

XREF1_HD Reference Key 1 Internal for Document Header Field

XREF2_HD Reference Key 2 Internal for Document Header Field

XREVERSAL Specifies whether doc. is reversal doc. or reversed doc. Field

REGUV Table

Page 28
Name Description Type

LAUFD Field

LAUFI Field

MANDT Field

BSEG Accounting Document Segment Table

AGZEI Clearing Item Field

ANBWA Asset Transaction Type Field

ANLN1 Main Asset Number Field

ANLN2 Asset Subnumber Field

AUFNR Order Number Field

AUGBL Document Number of the Clearing Document Field

AUGDT Clearing Date Field

AUGGJ Fiscal Year of Clearing Document Field

BELNR Accounting Document Number Field

BSCHL Posting Key Field

BUKRS Company Code Field

BUZEI Number of Line Item Within Accounting Document Field

BWKEY Valuation Area Field

BWTAR Valuation Type Field

DMBTR Amount in Local Currency Field

EBELN Purchasing Document Number Field

EBELP Item Number of Purchasing Document Field

EGBLD Country of Destination for Delivery of Goods Field

EGLLD Supplying Country for Delivery of Goods Field

FWBAS Tax Base Amount in Document Currency Field

GJAHR Fiscal Year Field

GSBER Business Area Field

HKONT General Ledger Account Field

HWBAS Tax Base Amount in Local Currency Field

IMKEY Internal Key for Real Estate Object Field

KOART Account Type Field

Page 29
Name Description Type

KOKRS Controlling Area Field

KOSTL Cost Center Field

KSTAR Cost Element Field

KSTRG Cost Object Field

KTOSL Transaction Key Field

KUNNR Customer Number 1 Field

LIFNR Account Number of Vendor or Creditor Field

LSTAR Activity Type Field

MABER Dunning Area Field

MADAT Last dunned on Field

MANDT Client Field

MANSP Dunning block Field

MANST Dunning level Field

MATNR Material Number Field

MSCHL Dunning key Field

MWART Tax Type Field

MWSKZ Sales Tax Code Field

MWSTS Tax Amount in Local Currency Field

NAVFW Non-Deductible Input Tax (in Document Currency) Field

NAVHW Non-Deductible Input Tax (in Local Currency) Field

NPLNR Network Number for Account Assignment Field

PAOBJNR Profitability Segment Number (CO-PA) Field

PERNR Personnel Number Field

POSN2 Sales Document Item Field

PRCTR Profit Center Field

PROJK Work Breakdown Structure Element (WBS Element) Field

PRZNR Business Process Field

REBZG Number of the Invoice the Transaction Belongs to Field

REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) Field

REBZT Follow-On Document Type Field

Page 30
Name Description Type

REBZZ Line Item in the Relevant Invoice Field

SAKNR G/L Account Number Field

SGTXT Item Text Field

SHKZG Debit/Credit Indicator Field

SKFBT Amount Eligible for Cash Discount in Document Currency Field

SKNTO Cash discount amount in local currency Field

STBUK Tax Company Code Field

STCEG VAT Registration Number Field

TXDAT Date for defining tax rates Field

UMSKZ Special G/L Indicator Field

VBEL2 Sales Document Field

VBELN Billing Document Field

VBUND Company ID of trading partner Field

WERKS Plant Field

WRBTR Amount in document currency Field

XAUTO Indicator: Line item automatically created Field

XBILK Indicator: Account is a balance sheet account? Field

XCPDD Indicator: Address and bank data set individually Field

XEGDR Indicator: Triangular deal within the EU ? Field

XOPVW Indicator: Open item management? Field

XREF1 Business partner reference key Field

XREF2 Business partner reference key Field

XREF3 Reference key for line item Field

XSKRL Item not discount relevant Field

XZAHL Indicator: Is the posting key used in a payment transaction? Field

ZBD1P Cash Discount Percentage 1 Field

ZBD1T Cash discount days 1 Field

ZBD2P Cash Discount Percentage 2 Field

ZBD2T Cash discount days 2 Field

ZBD3T Net Payment Terms Period Field

Page 31
Name Description Type

ZFBDT Baseline Date for Due Date Calculation Field

ZLSCH Payment Method Field

ZLSPR Payment Block Key Field

ZTERM Terms of Payment Key Field

ZUONR Assignment Number Field

BSET Tax Data Document Segment Table

BELNR Accounting Document Number Field

BUKRS Company Code Field

BUZEI Number of Line Item Within Accounting Document Field

GJAHR Fiscal Year Field

KBETR Tax Rate Field

KNUMH Condition record number Field

KSCHL Condition Type Field

MANDT Client Field

STCEG VAT Registration Number Field

FAGL_011FC Fin. Statement Structure: Assignment FS Item - Funct. Areas Table

BISFB Functional area interval upper limit Field

ERGSL Financial Statement Item Field

MANDT Client Field

VERSN Financial Statement Version Field

VONFB Functional area interval lower limit Field

FAGL_011PC Fin. Statement Structure: Items in Fin. Statement Structure Table

AEDAT Changed On Field

CHILD Internal: Node ID Field

ERGSL Financial Statement Item Field

ID Internal: Node ID Field

MANDT Client Field

NEXTN Internal: Node ID Field

PARENT Internal: Node ID Field

SIGN Change of sign (+/-) Field

Page 32
Name Description Type

STUFE Financial statement item hierarchy level Field

SUMME Is the total to be displayed? If yes, where? Field

TYPE Node type Field

USNAM User Name Field

VERSN Financial Statement Version Field

FAGL_011QT Fin. Statement Structure: Text for Fin. Statement Items Table

ERGSL Financial Statement Item Field

MANDT Client Field

SPRAS Language Key Field

TXT45 Financial statement item text Field

TXTYP Text type Field

VERSN Financial Statement Version Field

ZEILE Line number of the financial statement item Field

FAGL_011SC Fin. Statement Struct.: Assignment Fin. Stmnt Item: Setname Table

ERGSL Financial Statement Item Field

MANDT Client Field

SETNR Set Name Sequence Number Field

SETPR Set name prefix Field

SETVS Balance sheet version Field

VERSN Financial Statement Version Field

FAGL_011TC Fin. Statement Structure: Timestamp for Fin. Stmt Items Table

DATUM Date Field

ERGSL Financial Statement Item Field

MANDT Client Field

SPRAS Language Key Field

UZEIT Time Field

VERSN Financial Statement Version Field

FAGL_011VC Fin. Statement Structure: Contra Items Table

ERGS1 Debit Item key Field

ERGS2 Credit Item Key Field

Page 33
Name Description Type

MANDT Client Field

VERSN Financial Statement Version Field

FAGL_011ZC Fin. Statement Structure: Assignment FS Items - G/L Account Table

BISKT Account interval upper limit Field

ERGSL Financial Statement Item Field

KTOPL Chart of Accounts Field

MANDT Client Field

VERSN Financial Statement Version Field

VONKT Account interval lower limit Field

XHABN Indicator: Is entry relevant if there is a credit balance ? Field

XSOLL Indicator: Is entry relevant if there is a debit balance? Field

XVERD Indicator: Group balance decides on allocation Field

REGUH Settlement data from payment program Table

EMPFG Payee code Field

HKONT General Ledger Account Field

KUNNR Customer Number 1 Field

LAUFD Date on Which the Program Is to Be Run Field

LAUFI Additional Identification Field

LIFNR Account Number of Vendor or Creditor Field

MANDT Client Field

NAME1 Name 1 Field

NAME2 Name 2 Field

NAME3 Name 3 Field

NAME4 Name 4 Field

RZAWE Payment Method for This Payment Field

VBLNR Document Number of the Payment Document Field

XAEND Indicator: Payment Proposal was Changed Afterwards Field

XVORL Indicator: Only Proposal Run? Field

ZBKON Bank Control Key of the Payees Bank Field

ZBNKL Bank number of the payees bank Field

Page 34
Name Description Type

ZBNKN Bank account number of the payee Field

ZBNKS Country Key Field

ZBUKR Paying company code Field

ZBVTY Bank Data Indicator for the Payee Field

ZNME1 Name of the payee Field

ZNME2 Name of the payee Field

ZNME3 Name of the payee Field

ZNME4 Name of the payee Field

REGUP Processed items from payment program Table

BELNR Accounting Document Number Field

BLART Document Type Field

BSCHL Posting Key Field

BUDAT Posting Date in the Document Field

BUKRS Company Code Field

BUZEI Number of Line Item Within Accounting Document Field

DMBTR Amount in Local Currency Field

EBELN Purchasing Document Number Field

EBELP Item Number of Purchasing Document Field

EMPFG Payee code Field

GJAHR Fiscal Year Field

KKBER Credit control area Field

KUNNR Customer Number 1 Field

LAUFD Date on Which the Program Is to Be Run Field

LAUFI Additional Identification Field

LIFNR Account Number of Vendor or Creditor Field

MANDT Client Field

POKEN Item Indicator Field

SNAME1 Name 1 Field

SNAME2 Name 2 Field

SNAME3 Name 3 Field

Page 35
Name Description Type

SNAME4 Name 4 Field

STCEG VAT Registration Number Field

VBLNR Document Number of the Payment Document Field

VBUND Company ID of trading partner Field

XANET Indicator: Down payment in net procedure ? Field

XCPDD Indicator: Address and bank data set individually Field

XSAEN Indicator: Unconfirmed master data change Field

XVORL Indicator: Only Proposal Run? Field

ZBD1T Cash discount days 1 Field

ZBD2T Cash discount days 2 Field

ZBD3T Net Payment Terms Period Field

ZBUKR Paying company code Field

ZTERM Terms of Payment Key Field

SKA1 G/L Account Master (Chart of Accounts) Table

FUNC_AREA Functional Area Field

GVTYP P&L statement account type Field

KTOKS G/L Account Group Field

KTOPL Chart of Accounts Field

MANDT Client Field

SAKNR G/L Account Number Field

VBUND Company ID of trading partner Field

XBILK Indicator: Account is a balance sheet account? Field

SKAT G/L Account Master Record (Chart of Accounts: Description) Table

KTOPL Chart of Accounts Field

MANDT Client Field

SAKNR G/L Account Number Field

SPRAS Language Key Field

TXT20 G/L account short text Field

TXT50 G/L Account Long Text Field

SKB1 G/L account master (company code) Table

Page 36
Name Description Type

BEGRU Authorization Group Field

BUKRS Company Code Field

BUSAB Accounting clerk Field

ERDAT Date on which the Record Was Created Field

ERNAM Name of Person who Created the Object Field

MANDT Client Field

MWSKZ Tax Category in Account Master Record Field

SAKNR G/L Account Number Field

TOGRU Tolerance Group for G/L Accounts Field

VZSKZ Interest calculation indicator Field

WAERS Account currency Field

XGKON Cash receipt account / cash disbursement account Field

XOPVW Indicator: Open item management? Field

Page 37
 Profile "Procurement tables"
Purchasing (MM) tables

Name Description Type

Procurement tables Purchasing (MM) tables Profile

EKKO Purchasing Document Header Table

AEDAT Date on Which Record Was Created Field

ANGDT Deadline for Submission of Bid/Quotation Field

ANGNR Quotation Number Field

AUSNR Bid invitation number Field

BEDAT Purchasing Document Date Field

BSART Purchasing Document Type Field

BSTYP Purchasing Document Category Field

BUKRS Company Code Field

EBELN Purchasing Document Number Field

EKGRP Purchasing Group Field

EKORG Purchasing Organization Field

ERNAM Name of Person who Created the Object Field

FRGGR Release group Field

FRGKE Release Indicator: Purchasing Document Field

FRGRL Release Not Yet Completely Effected Field

FRGSX Release Strategy Field

FRGZU Release status Field

IHRAN Quotation Submission Date Field

INCO1 Incoterms (Part 1) Field

INCO2 Incoterms (Part 2) Field

KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) Field

KONNR Number of Principal Purchase Agreement Field

KUNNR Customer Number 1 Field

LANDS Country for Tax Return Field

LIFNR Vendor Account Number Field

LIFRE Different Invoicing Party Field

LLIEF Supplying Vendor Field

LOEKZ Deletion Indicator in Purchasing Document Field

Page 38
Name Description Type

MANDT Client Field

MEMORY Purchase order not yet complete Field

RLWRT Total value at time of release Field

SPRAS Language Key Field

STATU Status of Purchasing Document Field

STCEG VAT Registration Number Field

STCEG_L Country of Sales Tax ID Number Field

WAERS Currency Key Field

ZBD1P Cash Discount Percentage 1 Field

ZBD1T Cash (Prompt Payment) Discount Days Field

ZBD2P Cash Discount Percentage 2 Field

ZBD2T Cash (Prompt Payment) Discount Days Field

ZBD3T Cash (Prompt Payment) Discount Days Field

ZTERM Terms of Payment Key Field

EKPO Purchasing Document Item Table

AEDAT Purchasing Document Item Change Date Field

ANFNR RFQ Number Field

ANFPS Item Number of RFQ Field

BANFN Purchase Requisition Number Field

BNFPO Item Number of Purchase Requisition Field

BPRME Order Price Unit (Purchasing) Field

BRTWR Gross order value in PO currency Field

BUKRS Company Code Field

EBELN Purchasing Document Number Field

EBELP Item Number of Purchasing Document Field

INCO1 Incoterms (Part 1) Field

INCO2 Incoterms (Part 2) Field

KONNR Number of Principal Purchase Agreement Field

KUNNR Customer Field

LEBRE Indicator for Service-Based Invoice Verification Field

Page 39
Name Description Type

LOEKZ Deletion Indicator in Purchasing Document Field

MANDT Client Field

MATKL Material Group Field

MATNR Material Number Field

MEINS Purchase Order Unit of Measure Field

MENGE Purchase Order Quantity Field

MTART Material Type Field

MWSKZ Sales Tax Code Field

NETPR Net Price in Purchasing Document (in Document Currency) Field

NETWR Net Order Value in PO Currency Field

PSTYP Item Category in Purchasing Document Field

REPOS Invoice Receipt Indicator Field

STATU RFQ status Field

STATUS Status of Purchasing Document Item Field

TXZ01 Short Text Field

UEBTK Indicator: Unlimited Overdelivery Allowed Field

UEBTO Overdelivery Tolerance Limit Field

UNTTO Underdelivery Tolerance Limit Field

WEBRE Indicator: GR-Based Invoice Verification Field

WERKS Plant Field

WEUNB Goods Receipt, Non-Valuated Field

XOBLR Item affects commitments Field

EBAN Purchase Requisition Table

BADAT Requisition (Request) Date Field

BANFN Purchase Requisition Number Field

BEDAT Purchase Order Date Field

BNFPO Item Number of Purchase Requisition Field

BSART Purchase Requisition Document Type Field

BSTYP Purchasing Document Category Field

EBELN Purchase Order Number Field

Page 40
Name Description Type

EBELP Purchase Order Item Number Field

ERDAT Changed On Field

ERNAM Name of Person who Created the Object Field

LIFNR Desired Vendor Field

MANDT Client Field

MATKL Material Group Field

MATNR Material Number Field

MEINS Purchase requisition unit of measure Field

MENGE Purchase Requisition Quantity Field

PREIS Price in purchase requisition Field

RLWRT Total value at time of release Field

TXZ01 Short Text Field

WERKS Plant Field

EKBE History per Purchasing Document Table

AREWB Clearing Value on GR/IR Account in PO Currency Field

AREWR GR/IR account clearing value in local currency Field

AREWR_POP GR/IR account clearing value in local currency Field

AREWW Clearing value on GR/IR clearing account (transac. currency) Field

BAMNG Quantity Field

BEKKN Number of PO Account Assignment Field

BELNR Number of Material Document Field

BEWTP PO history category Field

BLDAT Document Date in Document Field

BPMNG Quantity in purchase order price unit Field

BPMNG_POP Quantity in purchase order price unit Field

BPWEB Quantity in Valuated GR Blocked Stock in Order Price Unit Field

BPWES Quantity in GR blocked stock in order price unit Field

BUDAT Posting Date in the Document Field

BUZEI Item in Material Document Field

BWART Movement Type (Inventory Management) Field

Page 41
Name Description Type

BWTAR Valuation Type Field

CHARG Batch Number Field

CPUDT Day On Which Accounting Document Was Entered Field

CPUTM Time of Entry Field

DMBTR Amount in Local Currency Field

DMBTR_POP Amount in Local Currency Field

EBELN Purchasing Document Number Field

EBELP Item Number of Purchasing Document Field

ELIKZ "Delivery Completed" Indicator Field

EMATN Material Number Field

ERNAM Name of Person who Created the Object Field

ETENS Sequential Number of Vendor Confirmation Field

ET_UPD Procedure for Updating the Schedule Line Quantity Field

EVERE Compliance with Shipping Instructions Field

GJAHR Material Document Year Field

GRUND Reason for Movement Field

HSWAE Local currency key Field

INTROW Line Number of Service Field

KNUMV Number of the document condition Field

KUDIF Exchange Rate Difference Amount Field

LEMIN Returns Indicator Field

LFBNR Document No. of a Reference Document Field

LFGJA Fiscal Year of a Reference Document Field

LFPOS Item of a Reference Document Field

LSMEH Unit of Measure From Delivery Note Field

LSMNG Quantity in Unit of Measure from Delivery Note Field

MANDT Client Field

MATNR Material Number Field

MENGE Quantity Field

MENGE_POP Quantity Field

Page 42
Name Description Type

MWSKZ Sales Tax Code Field

PACKNO Package Number of Service Field

REEWR Invoice Value Entered (in Local Currency) Field

REFWR Invoice value in foreign currency Field

REWRB Invoice Amount in PO Currency Field

SAPRL SAP Release Field

SHKZG Debit/Credit Indicator Field

SRVPOS Service number Field

VGABE Transaction/event type, purchase order history Field

WAERS Currency Key Field

WEORA Acceptance At Origin Field

WERKS Plant Field

WESBB Valuated Goods Receipt Blocked Stock in Order Unit Field

WESBS Goods Receipt Blocked Stock in Order Unit Field

WRBTR Amount in document currency Field

WRBTR_POP Amount in document currency Field

XBLNR Reference Document Number Field

XUNPL Unplanned Account Assignment from Invoice Verification Field

XWOFF Calculation of val. open Field

XWSBR Reversal of GR allowed for GR-based IV despite invoice Field

ZEKKN Sequential Number of Account Assignment Field

Page 43
 Profile "Sales"
Sales tables incl. delivery and invoicing

Name Description Type

Sales Sales tables incl. delivery and invoicing Profile

TVKO Organizational Unit: Sales Organizations Table

ADRNR Address Field

BOAVO Rebate processing active in the sales organization Field

BSART Order Type (Purchasing) Field

BSTYP Purchasing Document Category Field

BUKRS Company code of the sales organization Field

BWART Movement Type (Inventory Management) Field

EKGRP Purchasing Group Field

EKORG Purchasing Organization Field

J_1ANUTIME Time of numbering for deliveries Field

KUNNR Customer number for intercompany billing Field

LGORT Storage Location Field

LIFNR Account Number of Vendor or Creditor Field

MANDT Client Field

MAXBI Maximum Number of Items in Billing Document Field

MWSKZ Tax code for SD documents Field

PLAUEZ Unit for price protection Field

PLAUFZ Price protection period Field

TXNAM_ADR Text name for form text module short address Field

TXNAM_FUS Text name for formula text module footer lines Field

TXNAM_GRU Text name for form text module: Greeting Field

TXNAM_KOP Text name for form text module letter header Field

TXNAM_SDB Text names for layout-set module SDS sender Field

VKOAU Reference sales org.for sales doc.types (by sales area) Field

VKOKL Sales organization calendar Field

VKORG Sales Organization Field

WAERS Statistics currency Field

WERKS Plant Field

XSTCEG Determining the VAT registration number Field

Page 44
Name Description Type

VBAK Sales Document: Header Data Table

AEDAT Changed On Field

AMTBL Released credit value of the document Field

AUFNR Order Number Field

BNAME Name of orderer Field

BUKRS_VF Company code to be billed Field

CMFRE Release date of the document determined by credit management Field

CMNUP Date of next credit check of document Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

ERZET Entry time Field

FAKSK Billing block in SD document Field

GRUPP Customer Credit Group Field

KALSM Sales and Distribution: Pricing Procedure in Pricing Field

KKBER Credit control area Field

KNKLI Customers account number with credit limit reference Field

KNUMA Agreement (various conditions grouped together) Field

KOSTL Cost Center Field

KUNNR Sold-to party Field

LANDTX Tax departure country Field

LIFSK Delivery block (document header) Field

MANDT Client Field

NETWR Net Value of the Sales Order in Document Currency Field

SBGRP Credit representative group for credit management Field

STCEG_L Tax destination country Field

VBELN Sales Document Field

VBTYP SD document category Field

VKORG Sales Organization Field

XBLNR Reference Document Number Field

VBRK Billing Document: Header Data Table

Page 45
Name Description Type

AEDAT Changed On Field

BELNR Accounting Document Number Field

BUKRS Company Code Field

CITYC City Code Field

COUNC County Code Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

ERZET Entry time Field

FKSTO Billing document is cancelled Field

GJAHR Fiscal Year Field

INCO1 Incoterms (Part 1) Field

INCO2 Incoterms (Part 2) Field

KALSM Sales and Distribution: Pricing Procedure in Pricing Field

KDGRP Customer group Field

KKBER Credit control area Field

KNKLI Customers account number with credit limit reference Field

KNUMA Agreement (various conditions grouped together) Field

KONDA Price group (customer) Field

KUNAG Sold-to party Field

KUNRG Payer Field

LAND1 Country of Destination Field

LANDTX Tax departure country Field

MABER Dunning Area Field

MANDT Client Field

MANSP Dunning block Field

MRNKZ Manual invoice maintenance Field

MSCHL Dunning key Field

MWSBK Tax amount in document currency Field

NETWR Net Value in Document Currency Field

REGIO Region (State, Province, County) Field

Page 46
Name Description Type

RFBSK Status for transfer to accounting Field

STAFO Update group for statistics update Field

STCEG VAT Registration Number Field

STCEG_H Origin of sales tax ID number Field

STCEG_L Country of Sales Tax ID Number Field

VBELN Billing Document Field

VBTYP SD document category Field

VBUND Company ID of trading partner Field

WAERK SD Document Currency Field

XBLNR Reference Document Number Field

ZLSCH Payment Method Field

ZTERM Terms of Payment Key Field

LIKP SD Document: Delivery Header Data Table

BLDAT Document Date in Document Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

ERZET Entry time Field

KKBER Credit control area Field

KNKLI Customers account number with credit limit reference Field

KUNAG Sold-to party Field

KUNNR Ship-to party Field

LIFSK Delivery block (document header) Field

MANDT Client Field

NETWR Net Value of the Sales Order in Document Currency Field

TCODE Transaction Code Field

VBELN Delivery Field

VBTYP SD document category Field

VBUND Company ID Field

XBLNR Reference Document Number Field

LIPS SD document: Delivery: Item data Table

Page 47
Name Description Type

ARKTX Short text for sales order item Field

BWART Movement Type (Inventory Management) Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

ERZET Entry time Field

FAKSP Block Field

FKREL Relevant for Billing Field

KOSTL Cost Center Field

LFIMG Actual quantity delivered (in sales units) Field

MANDT Client Field

MATNR Material Number Field

MEINS Base Unit of Measure Field

MTART Material Type Field

NETPR Net price Field

NETWR Net Value in Document Currency Field

POSNR Delivery Item Field

SHKZG Returns Item Field

SPE_HERKL Country of origin of the material Field

UEBTK Indicator: Unlimited Overdelivery Allowed Field

UEBTO Overdelivery Tolerance Limit Field

UMBAR Valuation Type of Transfer Batch Field

UMCHA Receiving/Issuing Batch Field

UMLGO Receiving/Issuing Storage Location Field

UMMAT Receiving/Issuing Material Field

UMSOK Special Stock Indicator for Physical Stock Transfer Field

UMWRK Receiving/Issuing Plant Field

UM_PS_PSP_PNR Receiving/Issuing (WBS Element) Field

UNTTO Underdelivery Tolerance Limit Field

VBELN Delivery Field

VRKME Sales unit Field

Page 48
Name Description Type

VBAP Sales Document: Item Data Table

AEDAT Changed On Field

ARKTX Short text for sales order item Field

CMPRE Item credit price Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

ERZET Entry time Field

FAKSP Billing block for item Field

FKREL Relevant for Billing Field

KBMENG Cumulative confirmed quantity in sales unit Field

KOSTL Cost Center Field

MANDT Client Field

MATNR Material Number Field

MEINS Base Unit of Measure Field

NETPR Net price Field

NETWR Net value of the order item in document currency Field

POSNR Sales Document Item Field

PRCTR Profit Center Field

SHKZG Returns Item Field

UEBTK Unlimited overdelivery allowed Field

UEBTO Overdelivery Tolerance Limit Field

UNTTO Underdelivery Tolerance Limit Field

VBELN Sales Document Field

VRKME Sales unit Field

VBRP Billing Document: Item Data Table

ALAND Departure country (country from which the goods are sent) Field

ARKTX Short text for sales order item Field

AUBEL Sales Document Field

AUPOS Sales Document Item Field

BRTWR Gross value of the billing item in document currency Field

Page 49
Name Description Type

CMPRE Item credit price Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

ERZET Entry time Field

FKIMG Actual Invoiced Quantity Field

KONDA_AUFT Price group of sales order Field

KOSTL Cost Center Field

LLAND_AUFT Country of destination of sales order Field

MANDT Client Field

MATKL Material Group Field

MATNR Material Number Field

MEINS Base Unit of Measure Field

MWSBP Tax amount in document currency Field

MWSKZ Sales Tax Code Field

NETWR Net value of the billing item in document currency Field

POSNR Billing item Field

POSNV Originating item Field

SHKZG Returns item Field

VBELN Billing Document Field

VBELV Originating document Field

VGBEL Document number of the reference document Field

VGPOS Item number of the reference item Field

VGTYP Document category of preceding SD document Field

VRKME Sales unit Field

WERKS Plant Field

VBFA Sales Document Flow Table

AEDAT Changed On Field

ERDAT Date on Which Record Was Created Field

ERZET Entry time Field

MANDT Client Field

Page 50
Name Description Type

POSNN Subsequent item of an SD document Field

POSNV Preceding item of an SD document Field

VBELN Subsequent sales and distribution document Field

VBELV Preceding sales and distribution document Field

VBTYP_N Document category of subsequent document Field

VBTYP_V Document category of preceding SD document Field

Page 51
 Profile "User tables"
Tables for user master data

Name Description Type

User tables Tables for user master data Profile

USR02 Logon Data (Kernel-Side Use) Table

BCDA1 Date of Last Password Change Field

BCDA2 Date of Last Password Change Field

BCDA3 Date of Last Password Change Field

BCDA4 Date of Last Password Change Field

BCDA5 Date of Last Password Change Field

BCODE Password Hash Key Field

BNAME User Name in User Master Record Field

CLASS User group in user master maintenance Field

CODVN Code Version of Password Hash Algorithm (New Systems) Field

ERDAT Creation Date of the User Master Record Field

MANDT Client Field

PASSCODE Password Hash Value (SHA1, 160 Bit) Field

PWDCHGDATE Date of Last Password Change Field

PWDINITIAL Indicator: Password Is Initial (= Set by Administrator) Field

PWDLGNDATE Date of Last Password Logon Field

PWDLOCKDATE Date: Setting of Password Lock Field

TRDAT Last Logon Date Field

UFLAG User Lock Status Field

USTYP User Type Field

USR40 Table for illegal passwords Table

BCODE Password Pattern or Individual Value Field

CASESENSITIVE Password: Case-Sensitive? Field

UST04 User masters Table

BNAME User Name in User Master Record Field

MANDT Client Field

PROFILE Profile name Field

Page 52
 Profile "Fixed asset tables"
Tables for fixed asset accounting and master file

Name Description Type

Fixed asset tables Tables for fixed asset accounting and master file Profile

ANEP Asset Line Items Table

AFABE Real depreciation area Field

ANLN1 Main Asset Number Field

ANLN2 Asset Subnumber Field

BELNR Accounting Document Number Field

BUKRS Company Code Field

BUZEI Number of Line Item Within Accounting Document Field

BWASL Asset Transaction Type Field

GJAHR Fiscal Year Field

MANDT Client Field

ANLA Asset Master Record Segment Table

AEDAT Changed on Field

AENAM Name of Person Who Changed Object Field

AIMMO Indicator: real estate Field

AKTIV Asset capitalization date Field

ANEQS Completeness indicator for the asset Field

ANLKL Asset Class Field

ANLN1 Main Asset Number Field

ANLN2 Asset Subnumber Field

ANLTP Asset Category Field

BSTDT Asset purchase order date Field

BUKRS Company Code Field

DEAKT Deactivation date Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

INKEN Inventory indicator Field

INVNR Inventory number Field

LAND1 Assets country of origin Field

LEABG Lease start date Field

Page 53
Name Description Type

LIFNR Account number of vendor (other key word) Field

MANDT Client Field

MEINS Base Unit of Measure Field

MENGE Quantity Field

POSNR WBS element investment project Field

SERNR Serial number Field

SPRAS Language Key Field

TXT50 Asset description Field

VBUND Company ID of trading partner Field

XINVM Asset under Construction for Investment Measures Field

XOPVW Asset under construct. with line item settlement Field

ZUGDT Asset value date of the first posting Field

ANLB Depreciation terms Table

AEDAT Changed on Field

AENAM Name of Person Who Changed Object Field

AFABE Real depreciation area Field

AFABG Depreciation calculation start date Field

AFASL Depreciation key Field

ANLN1 Main Asset Number Field

ANLN2 Asset Subnumber Field

BUKRS Company Code Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

MANDT Client Field

NDJAR Planned useful life in years Field

XAFBE Indicator: Depreciation area is deactivated Field

ANLBZA Time-Dependent Depreciation Terms Table

AFABE Real depreciation area Field

AFASL Depreciation key Field

ANLN1 Main Asset Number Field

Page 54
Name Description Type

ANLN2 Asset Subnumber Field

BUKRS Company Code Field

MANDT Client Field

ANLC Asset Value Fields Table

AAFAG Unplanned depreciation posted for the year Field

AAFAV Proportional cumulative unplanned depreciation Field

AFABE Real depreciation area Field

ANLN1 Main Asset Number Field

ANLN2 Asset Subnumber Field

ANSWL Transactions for the year affecting asset values Field

BUKRS Company Code Field

GJAHR Fiscal Year Field

KAAFA Cumulative unplanned depreciation Field

KANSW Cumulative acquisition and production costs Field

KNAFA Accumulated ordinary depreciation Field

KSAFA Cumulative special depreciation Field

MAFAV Proportional cumulative transfer of reserves Field

MANDT Client Field

NAFAG Ordinary depreciation posted in the current year Field

NAFAV Proportional accumulated ordinary depreciation Field

SAFAG Special depreciation posted in the current fiscal year Field

SAFAV Proportional cumulative special depreciation Field

ZUSAA Write-up on unplanned depreciation Field

ZUSMA Write-up on transferred reserves Field

ZUSNA Write-up on ordinary depreciation Field

ZUSSA Write-up on special depreciation Field

ANLH Main asset number Table

ANLHTXT Asset main number text Field

ANLN1 Main Asset Number Field

BUKRS Company Code Field

Page 55
Name Description Type

MANDT Client Field

ANLZ Time-Dependent Asset Allocations Table

ADATU Date for beginning of validity Field

ANLN1 Main Asset Number Field

ANLN2 Asset Subnumber Field

ANUPD Indicator: Type of change to table Field

BDATU Date validity ends Field

BUKRS Company Code Field

CAUFN Internal order Field

FISTL Funds Center Field

FISTL2 Funds Center for APC Account Assignments Field

FKBER Functional Area Field

FKBER2 Functional Area for APC Account Assignments Field

GEBER Fund Field

GEBER2 Fund for APC Account Assignments Field

GRANT_NBR Grant Field

GRANT_NBR2 Grant for APC Account Assignments Field

GSBER Business Area Field

IAUFN Maintenance order Field

IMKEY Internal Key for Real Estate Object Field

IPROJ Old: Project number : No longer used --> PS_POSNR Field

IPSNR WBS element - maintenance project Field

KFZKZ License plate no. of vehichle Field

KOSTL Cost Center Field

KOSTLV Cost center responsible for asset Field

LSTAR Activity Type Field

MANDT Client Field

MSFAK Multiple-shift factor for multiple shift operation Field

PERNR Personnel Number Field

PLAN1 no longer used Field

Page 56
Name Description Type

PLAN2 No longer used Field

PS_PSP_PNR2 WBS Element (Costs) Field

RAUMN Room Field

STORT Asset location Field

TPLKZ Unused field length 3 Field

TPLNR Functional Location Field

TXJCD Tax Jurisdiction Field

WERKS Plant Field

XSTIL Asset shutdown Field

ANKA Asset classes: general data Table

AEDAT Changed on Field

AENAM Name of Person Who Changed Object Field

BEGRU Authorization Group Field

ERDAT Date on Which Record Was Created Field

ERNAM Name of Person who Created the Object Field

KOSTL Cost Center Field

LAND1 Assets country of origin Field

LIFNR Account number of vendor (other key word) Field

MANDT Client Field

WERKS Plant Field

XOPVW Asset under construct. with line item settlement Field

ANKT Asset classes: Description Table

ANLKL Asset Class Field

MANDT Client Field

SPRAS Language Key Field

TXK50 Asset class description Field

TXT50 Asset description Field

Page 57
 Profile "Material Master Table"
Tables for material master

Name Description Type

Material Master Table Tables for material master Profile

MARA General Material Data Table

AENAM Name of Person Who Changed Object Field

ATTYP Material Category Field

BEGRU Authorization Group Field

BMATN Number of firms own (internal) inventory-managed material Field

BSTME Purchase Order Unit of Measure Field

BWVOR Procurement rule Field

DATAB Valid-From Date Field

DG_PACK_STATUS Dangerous Goods Packaging Status Field

EAN11 International Article Number (EAN/UPC) Field

EKWSL Purchasing Value Key Field

ENTAR Deactivated Field

ERGEI Unit of weight (allowed packaging weight) Field

ERNAM Name of Person who Created the Object Field

ERSDA Created On Field

ETIAG IS-R Labeling: material grouping (deactivated in 4.0) Field

GEWEI Weight Unit Field

HAZMAT Relevant for Hazardous Substances Field

INHAL Net contents Field

INHBR Gross contents Field

INHME Content unit Field

KUNNR Competitor Field

KZNFM Indicator: The material has a follow-up material Field

LAEDA Date of Last Change Field

LVORM Flag Material for Deletion at Client Level Field

MANDT Client Field

MATKL Material Group Field

MATNR Material Number Field

MEABM Unit of Dimension for Length/Width/Height Field

Page 58
Name Description Type

MEINS Base Unit of Measure Field

MFRNR Number of a Manufacturer Field

MFRPN Manufacturer Part Number Field

MTART Material Type Field

MTPOS_MARA General item category group Field

NRFHG Material qualifies for discount in kind Field

NUMTP Category of International Article Number (EAN) Field

PILFERABLE Pilferable Field

PMATA Pricing Reference Material Field

PROFL Dangerous Goods Indicator Profile Field

RETDELC Return Code Field

SPROF Pricing profile for variants Field

STOFF Hazardous material number Field

TAKLV Tax classification of the material Field

VOLEH Volume unit Field

WHMATGR Warehouse Material Group Field

MKPF Header: Material Document Table

AEDAT Changed On Field

BLART Document Type Field

BLDAT Document Date in Document Field

BUDAT Posting Date in the Document Field

CPUDT Day On Which Accounting Document Was Entered Field

CPUTM Time of Entry Field

MANDT Client Field

MBLNR Number of Material Document Field

MJAHR Material Document Year Field

TCODE Not More Closely Defined Area, Possibly Used for Patchlevels Field

TCODE2 Transaction Code Field

USNAM User name Field

XBLNR Reference Document Number Field

Page 59
Name Description Type

MSEG Document Segment: Material Table

ANLN1 Field

ANLN2 Field

AUFNR Field

BELNR Field

BELUM Field

BNBTR Field

BPMNG Field

BPRME Field

BSTME Field

BSTMG Field

BUKRS Field

BUZEI Field

BUZUM Field

BWART Field

BWLVS Field

BWTAR Field

CHARG Field

DMBTR Field

DMBUM Field

EBELN Field

EBELP Field

EMATN Field

EMLIF Field

EQUNR Field

ERFME Field

ERFMG Field

EVERS Field

GJAHR Field

GSBER Field

Page 60
Name Description Type

INSMK Field

KDAUF Field

KDPOS Field

KOKRS Field

KOSTL Field

KUNNR Field

KZBEW Field

KZVBR Field

KZZUG Field

LGNUM Field

LGORT Field

LGTYP Field

LIFNR Field

LINE_DEPTH Field

LINE_ID Field

LLIEF Field

MANDT Client Field

MATBF Field

MATNR Field

MBLNR Number of Material Document Field

MEINS Field

MENGE Field

MJAHR Material Document Year Field

MWSKZ Field

PARBU Field

PARENT_ID Field

PARGB Field

PBAMG Field

SAKTO Field

SGTXT Field

Page 61
Name Description Type

SHKUM Field

SHKZG Field

SOBKZ Field

TXJCD Field

UMBAR Field

UMCHA Field

UMLGO Field

UMMAB Field

UMMAT Field

UMSOK Field

UMWRK Field

VKMWS Field

VPRSV Field

VPTNR Field

WAERS Field

WEMPF Field

WERKS Field

WEUNB Field

XAUTO Field

XRUEJ Field

XRUEM Field

XSKST Field

XWSBR Field

ZEILE Field

MAKT Material Descriptions Table

MAKTX Material Description (Short Text) Field

MANDT Client Field

MATNR Material Number Field

SPRAS Language Key Field

MBEW Material Valuation Table

Page 62
Name Description Type

BKLAS Valuation Class Field

BWKEY Valuation Area Field

BWTAR Valuation Type Field

LAEPR Date of the last price change Field

LBKUM Total Valuated Stock Field

MANDT Client Field

MATNR Material Number Field

MLAST Material Price Determination: Control Field

MLMAA Material ledger activated at material level Field

PEINH Price Unit Field

SPERW Physical Inventory Blocking Indicator Field

STPRS Standard price Field

VERPR Moving Average Price/Periodic Unit Price Field

VJSAV Value based on moving average price (previous year) Field

VJSTP Standard price in previous year Field

VJVER Moving Average Price/Periodic Unit Price in Previous Year Field

VPRSV Price control indicator Field

XLIFO LIFO/FIFO-Relevant Field

TDG41 DG: DG Indicator Profiles for Material Master Table

IDAGO Dangerous Goods Field

IDGCH Relevant for Dangerous Goods Checks Field

IDGPA Relevant for Dangerous Goods Documents Field

IDGSM Relevant for One-Time Materials Field

IDGTP Relevant for Template Materials Field

MANDT Client Field

PROFL Dangerous Goods Indicator Profile Field

Page 63
 Profile "Master data tables"
Customer and vendor master data tables

Name Description Type

Master data tables Customer and vendor master data tables Profile

KNB1 Customer Master (Company Code) Table

AKONT Reconciliation Account in General Ledger Field

BEGRU Authorization Group Field

BUKRS Company Code Field

CONFS Status of Change Authorization (Company Code Level) Field

ERDAT Date on which the Record Was Created Field

ERNAM Name of Person who Created the Object Field

FRGRP Release Approval Group Field

GMVKZD Customer is in execution Field

GUZTE Payment Terms Key for Credit Memos Field

KNRZB Account number of an alternative payer Field

KNRZE Head office account number (in branch accounts) Field

KULTG Probable time until check is paid Field

KUNNR Customer Number 1 Field

MANDT Client Field

MGRUP Key for dunning notice grouping Field

PERNR Personnel Number Field

QLAND Withholding Tax Country Key Field

REMIT Next payee Field

SPERR Posting block for company code Field

SREGL Selection Rule for Payment Advices Field

UPDAT Date on Which the Changes Were Confirmed Field

UPTIM Time of Last Change Confirmation Field

UZAWE Payment Method Supplement Field

VERDT Insurance validity date Field

VZSKZ Interest calculation indicator Field

XEDIP Indicator: Send Payment Advices by EDI Field

XKNZB Indicator: Alternative payer using account number Field

XVERR Indicator: Clearing between customer and vendor ? Field

Page 64
Name Description Type

XZVER Indicator: Record Payment History ? Field

ZAHLS Block key for payment Field

ZTERM Terms of Payment Key Field

ZWELS List of the Payment Methods to be Considered Field

LFB1 Vendor Master (Company Code) Table

AKONT Reconciliation Account in General Ledger Field

BUKRS Company Code Field

CONFS Status of Change Authorization (Company Code Level) Field

ERDAT Date on which the Record Was Created Field

ERNAM Name of Person who Created the Object Field

FRGRP Release Approval Group Field

GMVKZK Vendor is in execution Field

GUZTE Payment Terms Key for Credit Memos Field

KULTG Probable time until check is paid Field

LIFNR Account Number of Vendor or Creditor Field

LNRZB Account number of the alternative payee Field

LNRZE Head office account number Field

LOEVM Deletion Flag for Master Record (Company Code Level) Field

MANDT Client Field

MGRUP Key for dunning notice grouping Field

MINDK Minority Indicators Field

NODEL Deletion bock for master record (company code level) Field

PERNR Personnel Number Field

PREPAY_RELEVANT Prepayment Relevance (Vendor Master) Field

QLAND Withholding Tax Country Key Field

QSSKZ Withholding Tax Code Field

REPRF Check Flag for Double Invoices or Credit Memos Field

SPERR Posting block for company code Field

TOGRR Tolerance group; Invoice Verification Field

TOGRU Tolerance group for the business partner/G/L account Field

Page 65
Name Description Type

UPDAT Date on Which the Changes Were Confirmed Field

UPTIM Time of Last Change Confirmation Field

UZAWE Payment Method Supplement Field

VZSKZ Interest calculation indicator Field

XEDIP Indicator: Send Payment Advices by EDI Field

XLFZB Indicator: Alternative payee using account number Field

XPORE Indicator: Pay all items separately ? Field

XVERR Indicator: Clearing between customer and vendor? Field

ZAHLS Block key for payment Field

ZGRUP Key for Payment Grouping Field

ZTERM Terms of Payment Key Field

KNA1 General Data in Customer Master Table

AUFSD Central order block for customer Field

BEGRU Authorization Group Field

CASSD Central sales block for customer Field

CCC01 Indicator for biochemical warfare for legal control Field

CCC02 Indicator for nuclear nonproliferation for legal control Field

CCC03 Indicator for national security for legal control Field

CCC04 Indicator for missile technology for legal control Field

CITYC City Code Field

CONFS Status of Change Authorization (Central) Field

COUNC County Code Field

ERDAT Date on which the Record Was Created Field

ERNAM Name of Person who Created the Object Field

FAKSD Central billing block for customer Field

FISKN Account number of the master record with the fiscal address Field

FITYP Tax type Field

GFORM Legal status Field

INSPATDEBI Inspection for a Delivery Note After Outbound Delivery Field

KDKG1 Customer condition group 1 Field

Page 66
Name Description Type

KDKG2 Customer condition group 2 Field

KDKG3 Customer condition group 3 Field

KDKG4 Customer condition group 4 Field

KDKG5 Customer condition group 5 Field

KNRZA Account number of an alternative payer Field

KONZS Group key Field

KTOCD Reference Account Group for One-Time Account (Customer) Field

KTOKD Customer Account Group Field

KUKLA Customer classification Field

KUNNR Customer Number 1 Field

LAND1 Country Key Field

LIFNR Account Number of Vendor or Creditor Field

LIFSD Central delivery block for the customer Field

LOEVM Central Deletion Flag for Master Record Field

MANDT Client Field

MILVE ID for mainly military use Field

NAME1 Name 1 Field

NODEL Central deletion block for master record Field

ORT01 City Field

PERIV Fiscal Year Variant Field

PFACH PO Box Field

SPERR Central posting block Field

SPERZ Payment Block Field

SPRAS Language Key Field

STCD1 Tax Number 1 Field

STCDT Tax Number Type Field

STCEG VAT Registration Number Field

STKZA Indicator: Business Partner Subject to Equalization Tax? Field

STKZN Natural Person Field

STKZU Liable for VAT Field

Page 67
Name Description Type

STRAS House number and street Field

TXJCD Tax Jurisdiction Field

UPDAT Date on Which the Changes Were Confirmed Field

UPTIM Time of Last Change Confirmation Field

VBUND Company ID of trading partner Field

WERKS Plant Field

XCPDK Indicator: Is the account a one-time account? Field

XKNZA Indicator: Alternative payer using account number Field

XSUBT Customer group for Substituiçao Tributária calculation Field

XZEMP Indicator: Is an alternative payer allowed in document? Field

KNBK Customer Master (Bank Details) Table

BANKL Bank Keys Field

BANKN Bank account number Field

BANKS Bank country key Field

BKONT Bank Control Key Field

BKREF Reference specifications for bank details Field

EBPP_ACCNAME User-Defined Name of Bank Details Field

KOBIS Bank details valid to Field

KOINH Account Holder Name Field

KOVON Bank Details Valid From Field

KUNNR Customer Number 1 Field

MANDT Client Field

XEZER Indicator: Is there collection authorization ? Field

LFA1 Vendor Master (General Section) Table

BEGRU Authorization Group Field

CONFS Status of Change Authorization (Central) Field

ERDAT Date on which the Record Was Created Field

ERNAM Name of Person who Created the Object Field

FITYP Tax type Field

KTOCK Reference Account Group for One-Time Account (Vendor) Field

Page 68
Name Description Type

KTOKK Vendor account group Field

KUNNR Customer Number 1 Field

LAND1 Country Key Field

LIFNR Account Number of Vendor or Creditor Field

LNRZA Account Number of the Alternative Payee Field

LOEVM Central Deletion Flag for Master Record Field

MANDT Client Field

NAME1 Name 1 Field

NODEL Central deletion block for master record Field

ORT01 City Field

PODKZB Vendor indicator relevant for proof of delivery Field

PSTLZ Postal Code Field

REGIO Region (State, Province, County) Field

REVDB Last review (external) Field

SPERM Centrally imposed purchasing block Field

SPERQ Function That Will Be Blocked Field

SPERR Central posting block Field

SPERZ Payment Block Field

STCD1 Tax Number 1 Field

STCD2 Tax Number 2 Field

STCD3 Tax Number 3 Field

STCD4 Tax Number 4 Field

STCDT Tax Number Type Field

STCEG VAT Registration Number Field

STENR Tax Number at Responsible Tax Authority Field

STKZN Natural Person Field

STKZU Liable for VAT Field

STRAS House number and street Field

TXJCD Tax Jurisdiction Field

UPDAT Date on Which the Changes Were Confirmed Field

Page 69
Name Description Type

UPTIM Time of Last Change Confirmation Field

VBUND Company ID of trading partner Field

WERKS Plant (Own or External) Field

XCPDK Indicator: Is the account a one-time account? Field

XLFZA Indicator: Alternative payee using account number Field

XZEMP Indicator: Alternative payee in document allowed ? Field

LFBK Vendor Master (Bank Details) Table

BANKL Bank Keys Field

BANKN Bank account number Field

BANKS Bank country key Field

BKONT Bank Control Key Field

KOBIS Bank details valid to Field

KOINH Account Holder Name Field

KOVON Bank Details Valid From Field

LIFNR Account Number of Vendor or Creditor Field

MANDT Client Field

XEZER Indicator: Is there collection authorization ? Field

KNKK Customer master credit management: Control area data Table

ABSBT Total Secured Receivables Field

AEDAT Date of Last Change Field

CASHA Amount of Last Payment Field

CASHC Currency of Last Payment Field

CASHD Date of Last Payment Field

CRBLB Indicator: Blocked by credit management ? Field

CTLPC Credit management: Risk category Field

DBEKR Recommended credit limit Field

DBMON Date Monitoring Field

DBPAY Payment Index Field

DBRTG Rating Field

DBWAE Currency of recommended credit limit Field

Page 70
Name Description Type

DTREV Last internal review Field

ERDAT Date on which the Record Was Created Field

ERNAM Name of Person who Created the Object Field

KDGRP Customer Group Field

KKBER Credit control area Field

KLIMK Customers credit limit Field

KNKLI Customers account number with credit limit reference Field

KRAUS Credit information number Field

KUNNR Customer Number 1 Field

MANDT Client Field

NXTRV Next internal review Field

REVDB Last review (external) Field

SAUFT Total of the sales values for the credit limit check Field

SBDAT Reference Date Field

SBGRP Credit representative group for credit management Field

SKFOR Total receivables (for credit limit check) Field

SSOBL Relevant special liabilities for credit limit check Field

UEDAT Date on which the credit limit was exceeded Field

XCHNG Indicator: credit limit must be recreated Field

Page 71
 Profile "Change document tables"
Tables for changes of existing documents

Name Description Type

Change document tables Tables for changes of existing documents Profile

CDPOS Change document items Table

CHANGENR Document change number Field

CHNGIND Change type (U, I, E, D) Field

FNAME Field Name Field

MANDANT Client Field

OBJECTCLAS Object class Field

OBJECTID Object value Field

TABKEY Changed table record key Field

TABNAME Table Name Field

VALUE_NEW New contents of changed field Field

VALUE_OLD Old contents of changed field Field

CDHDR Change document header Table

CHANGENR Document change number Field

CHANGE_IND Application object change type (U, I, E, D) Field

LANGU Language Key Field

MANDANT Client Field

OBJECTCLAS Object class Field

OBJECTID Object value Field

TCODE Transaction in which a change was made Field

UDATE Creation date of the change document Field

USERNAME User name of the person responsible in change document Field

UTIME Time changed Field

VERSION 3-Byte field Field

TCDOBT Texts for objects for change document creation Table

OBJECT Object class Field

OBTEXT Change document object text Field

SPRAS Language Key Field

Page 72
 The following tables are required for integration check.
No extraction of these tables. But access right are required.

Name Description Type

DD03L Table Fields information Table

TABNAME Table name Field

FIELDNAME Field name Field

DATATYPE Data Type in ABAP Dictionary Field

LENG Length (No. of Characters) Field

DECIMALS Number of Decimal Places Field

Page 73