1. Home
  2. Resources
  3. SAP Tables
  4. BIW_ACTY_V - Generated Table for View

SAP Table BIW_ACTY_V

Generated Table for View

BIW_ACTY_V (Generated Table for View) 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 BIW_ACTY_V to other SAP tables.

BIW_ACTY_V table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
APLZL General counter for order CO_APLZL NUMC 8 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
VORNR Operation/Activity Number VORNR CHAR 4 0
PSPID_INT Current number of the appropriate project PS_PSPHI PROJ NUMC 8 0
PSPID Project Definition PS_PSPID CHAR 24 0
POSID_INT Work breakdown structure element (WBS element) PS_PSP_ELE PRPS NUMC 8 0
POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
DISPO MRP controller for the order CO_DISPO T024D CHAR 3 0
WERKS Plant WERKS_D T001W CHAR 4 0
ANFKO Requesting cost center ANFKO CSKS CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
STEUS Control key STEUS T430 CHAR 4 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
SAKTO Cost Element KSTAR CSKA CHAR 10 0
WAERS Currency Key WAERS TCURC CUKY 5 0
INFNR Number of Purchasing Info Record INFNR EINA CHAR 10 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing group for external processing VG_EKGRP T024 CHAR 3 0
MATKL Material Group MATKL T023 CHAR 9 0
BUKRS Company Code BUKRS T001 CHAR 4 0
ANFKOKRS Controlling area of the requesting cost center ANFKOKRS TKA01 CHAR 4 0
LARNT Activity Type LSTAR CSLA CHAR 6 0
NPRIO Priority NW_PRIO TCN07 CHAR 1 0
SCOPE Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
ARBID Object ID of the resource CR_OBJID CRID NUMC 8 0
USR00 User field with 20 characters USRCHAR20 CHAR 20 0
USR01 User field with 20 characters USRCHAR20 CHAR 20 0
USR02 User field with 10 characters USRCHAR10 CHAR 10 0
USR03 User field with 10 characters USRCHAR10 CHAR 10 0
USR04 User field for quantity (length 10.3) USRQUAN13 QUAN 13 3
USE04 User field: Unit for quantity fields USRUNIT T006 UNIT 3 0
USR05 User field for quantity (length 10.3) USRQUAN13 QUAN 13 3
USE05 User field: Unit for quantity fields USRUNIT T006 UNIT 3 0
USR06 User-defined field for values (length 10,3) USRCURR13 CURR 13 3
USE06 User field: Unit for value fields USRCUKY TCURC CUKY 5 0
USR07 User-defined field for values (length 10,3) USRCURR13 CURR 13 3
USE07 User field: Unit for value fields USRCUKY TCURC CUKY 5 0
USR08 User field for date USRDATE DATS 8 0
USR09 User field for date USRDATE DATS 8 0
USR10 User-defined field: Indicator for reports USRFLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
USR11 User-defined field: Indicator for reports USRFLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
SUMNR Node number of the superior operation SUMKNTNR NUMC 8 0
TXTMD Operation short text LTXA1 CHAR 40 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
KOKRS Controlling area for the project PS_VKOKR TKA01 CHAR 4 0

BIW_ACTY_V foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BIW_ACTY_V ANFKO AFVKI MANDT CSKS Cost Center Master Data MANDT
BIW_ACTY_V ANFKO BIW_ACTY_V ANFKOKRS CSKS Cost Center Master Data KOKRS
BIW_ACTY_V ANFKO BIW_ACTY_V ANFKO CSKS Cost Center Master Data KOSTL
BIW_ACTY_V ANFKO CSKS DATBI CSKS Cost Center Master Data DATBI
BIW_ACTY_V ANFKOKRS AFVKI MANDT TKA01 Controlling Areas MANDT
BIW_ACTY_V ANFKOKRS BIW_ACTY_V ANFKOKRS TKA01 Controlling Areas KOKRS
BIW_ACTY_V ARBID CRID OBJTY CRID CIM Resource - Entities OBJTY
BIW_ACTY_V ARBID BIW_ACTY_V ARBID CRID CIM Resource - Entities OBJID
BIW_ACTY_V ARBID AFVKI MANDT CRID CIM Resource - Entities MANDT
BIW_ACTY_V AUFNR BIW_ACTY_V MANDT AUFK Order master data MANDT
BIW_ACTY_V AUFNR BIW_ACTY_V AUFNR AUFK Order master data AUFNR
BIW_ACTY_V BUKRS AFVKI MANDT T001 Company Codes MANDT
BIW_ACTY_V BUKRS BIW_ACTY_V BUKRS T001 Company Codes BUKRS
BIW_ACTY_V DISPO BIW_ACTY_V DISPO T024D MRP controllers DISPO
BIW_ACTY_V DISPO BIW_ACTY_V MANDT T024D MRP controllers MANDT
BIW_ACTY_V DISPO AUFK WERKS T024D MRP controllers WERKS
BIW_ACTY_V EBELN BIW_ACTY_V EBELN EKKO Purchasing Document Header EBELN
BIW_ACTY_V EBELN AFVGD MANDT EKKO Purchasing Document Header MANDT
BIW_ACTY_V EBELP AFVGD MANDT EKPO Purchasing Document Item MANDT
BIW_ACTY_V EBELP BIW_ACTY_V EBELN EKPO Purchasing Document Item EBELN
BIW_ACTY_V EBELP BIW_ACTY_V EBELP EKPO Purchasing Document Item EBELP
BIW_ACTY_V EKGRP AFVKI MANDT T024 Purchasing Groups MANDT
BIW_ACTY_V EKGRP BIW_ACTY_V EKGRP T024 Purchasing Groups EKGRP
BIW_ACTY_V EKORG AFVKI MANDT T024E Purchasing Organizations MANDT
BIW_ACTY_V EKORG BIW_ACTY_V EKORG T024E Purchasing Organizations EKORG
BIW_ACTY_V GSBER AFVKI MANDT TGSB Business Areas MANDT
BIW_ACTY_V GSBER BIW_ACTY_V GSBER TGSB Business Areas GSBER
BIW_ACTY_V INFNR AFVKI MANDT EINA Purchasing Info Record: General Data MANDT
BIW_ACTY_V INFNR BIW_ACTY_V INFNR EINA Purchasing Info Record: General Data INFNR
BIW_ACTY_V KOKRS BIW_ACTY_V MANDT TKA01 Controlling Areas MANDT
BIW_ACTY_V KOKRS BIW_ACTY_V KOKRS TKA01 Controlling Areas KOKRS
BIW_ACTY_V LARNT BIW_ACTY_V LARNT CSLA Activity master LSTAR
BIW_ACTY_V LARNT CSLA DATBI CSLA Activity master DATBI
BIW_ACTY_V LARNT AFVGK MANDT CSLA Activity master MANDT
BIW_ACTY_V LARNT BIW_ACTY_V ANFKOKRS CSLA Activity master KOKRS
BIW_ACTY_V LIFNR BIW_ACTY_V LIFNR LFA1 Vendor Master (General Section) LIFNR
BIW_ACTY_V LIFNR AFVKI MANDT LFA1 Vendor Master (General Section) MANDT
BIW_ACTY_V MANDT BIW_ACTY_V MANDT T000 Clients MANDT
BIW_ACTY_V MATKL AFVKI MANDT T023 Material Groups MANDT
BIW_ACTY_V MATKL BIW_ACTY_V MATKL T023 Material Groups MATKL
BIW_ACTY_V NPRIO SYST MANDT TCN07 Priority MANDT
BIW_ACTY_V NPRIO BIW_ACTY_V NPRIO TCN07 Priority NPRIO
BIW_ACTY_V OBJNR AFVKI MANDT ONR00 General Object Number MANDT
BIW_ACTY_V OBJNR BIW_ACTY_V OBJNR ONR00 General Object Number OBJNR
BIW_ACTY_V POSID_INT BIW_ACTY_V POSID_INT PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
BIW_ACTY_V POSID_INT AFVKI MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
BIW_ACTY_V PRCTR AFVKI MANDT CEPC Profit Center Master Data Table MANDT
BIW_ACTY_V PRCTR BIW_ACTY_V PRCTR CEPC Profit Center Master Data Table PRCTR
BIW_ACTY_V PRCTR * CEPC Profit Center Master Data Table DATBI
BIW_ACTY_V PRCTR * CEPC Profit Center Master Data Table KOKRS
BIW_ACTY_V PSPID_INT BIW_ACTY_V MANDT PROJ Project definition MANDT
BIW_ACTY_V PSPID_INT BIW_ACTY_V PSPID_INT PROJ Project definition PSPNR
BIW_ACTY_V SAKTO AFVKI MANDT CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
BIW_ACTY_V SAKTO CSKA KTOPL CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
BIW_ACTY_V SAKTO BIW_ACTY_V SAKTO CSKA Cost Elements (Data Dependent on Chart of Accounts) KSTAR
BIW_ACTY_V STEUS BIW_ACTY_V STEUS T430 Operation/Activity control key STEUS
BIW_ACTY_V STEUS AFVKI MANDT T430 Operation/Activity control key MANDT
BIW_ACTY_V STEUS CAUFVD PLNAW T430 Operation/Activity control key PLNAW
BIW_ACTY_V USE04 AFVGI MANDT T006 Units of Measurement MANDT
BIW_ACTY_V USE04 BIW_ACTY_V USE04 T006 Units of Measurement MSEHI
BIW_ACTY_V USE05 AFVGI MANDT T006 Units of Measurement MANDT
BIW_ACTY_V USE05 BIW_ACTY_V USE05 T006 Units of Measurement MSEHI
BIW_ACTY_V USE06 AFVKI MANDT TCURC Currency Codes MANDT
BIW_ACTY_V USE06 BIW_ACTY_V USE06 TCURC Currency Codes WAERS
BIW_ACTY_V USE07 AFVKI MANDT TCURC Currency Codes MANDT
BIW_ACTY_V USE07 BIW_ACTY_V USE07 TCURC Currency Codes WAERS
BIW_ACTY_V WAERS AFVKI MANDT TCURC Currency Codes MANDT
BIW_ACTY_V WAERS BIW_ACTY_V WAERS TCURC Currency Codes WAERS
BIW_ACTY_V WERKS BIW_ACTY_V WERKS T001W Plants/Branches WERKS
BIW_ACTY_V WERKS AFVKI MANDT T001W Plants/Branches MANDT