| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DSF_GUID | DSF GUID | nvarchar | 32 | 0 | CHAR | (N' ') | No | | /SMFND/DSF_GUID_DTE | Allow NULL? |
| 3 | DSF_DSTORE_ID | Data Store ID | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | /SMFND/DSF_DSTORE_ID_DTE | Allow NULL? |
| 4 | USER_GUID | User GUID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /SYCLO/CORE_USER_GUID_DTE | Allow NULL? |
| 5 | DSF_RECORD_ID | DSF Record ID | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | /SMFND/DSF_RECORD_ID_DTE | Allow NULL? |
| 6 | DSF_CHANGED_BY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /SYCLO/CORE_CHANGEDBY_DTE | Allow NULL? |
| 7 | DSF_CHANGED_TS | Changed time stamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SYCLO/CORE_CHANGEDTS_DTE | |
| 8 | EQUNR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | EQUNR | Allow NULL? |
| 9 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 10 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 11 | EQASP | Language in Which the Piece of Equipment was Entered | char | 1 | 0 | LANG | (N' ') | Yes | T002 | EQASP | Allow NULL? |
| 12 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 13 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 14 | BEGRU | Technical object authorization group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T370B | IAUTG | Allow NULL? |
| 15 | EQTYP | Equipment category | char | 1 | 0 | CHAR | (N' ') | Yes | T370T | EQTYP | Allow NULL? |
| 16 | EQART | Type of Technical Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T370K | EQART | Allow NULL? |
| 17 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_001 | Allow NULL? |
| 18 | INVNR | Inventory number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | INVNR | Allow NULL? |
| 19 | GROES | Size/dimension | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | GROSS | Allow NULL? |
| 20 | BRGEW | Weight of object | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OBJ_WEIGHT | |
| 21 | GEWEI | Unit of weight | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | WEIGHT_UNIT | Allow NULL? |
| 22 | ANSDT | Acquisition date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ANDTI | Allow NULL? |
| 23 | ANSWT | Acquisition Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | ANSWT | |
| 24 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 25 | ELIEF | Vendor number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | ELIEF | Allow NULL? |
| 26 | GWLEN | Date on which the warranty ends | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GWLEN | Allow NULL? |
| 27 | GWLDT | Warranty Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GWLDT | Allow NULL? |
| 28 | WDBWT | Equipment replacement value | decimal | 13 | 2 | CURR | ((0)) | Yes | | WDBWT | |
| 29 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HERST | Allow NULL? |
| 30 | HERLD | Country of manufacture | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | HERLD | Allow NULL? |
| 31 | HZEIN | Manufacturer drawing number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HZEIN | Allow NULL? |
| 32 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SERGE | Allow NULL? |
| 33 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | TYPBZ | Allow NULL? |
| 34 | BAUJJ | Year of construction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BAUJJ | Allow NULL? |
| 35 | BAUMM | Month of construction | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BAUMM | Allow NULL? |
| 36 | APLKZ | Indicator: Task List Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | APLKZ | Allow NULL? |
| 37 | AULDT | First delivery date of the equipment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AULDT | Allow NULL? |
| 38 | INBDT | Start-up Date of the Technical Object | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ILOM_DATAB | Allow NULL? |
| 39 | GERNR | Serial Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | GERNR | Allow NULL? |
| 40 | GWLDV | Warranty date for Sales and Distribution | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GWLDV | Allow NULL? |
| 41 | EQDAT | Date, intended for SAP internal use | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EQDAT | Allow NULL? |
| 42 | EQBER | Technical information, intended for SAP internal use | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | EQBER | Allow NULL? |
| 43 | EQNUM | Numerical field, intended for SAP internal use | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | EQNUM | Allow NULL? |
| 44 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 45 | EQSNR | EQSE Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | EQSE | EQSNR | Allow NULL? |
| 46 | CUOBJ | Configuration (internal object number) | nvarchar | 18 | 0 | NUMC | (N'000000000000000000') | Yes | | CUOBJ | Allow NULL? |
| 47 | KRFKZ | Referenced Configuration | char | 1 | 0 | CHAR | (N' ') | Yes | | KRFKZ | Allow NULL? |
| 48 | KMATN | Configurable Material | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | KMATN | Allow NULL? |
| 49 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 50 | SERNR | Serial Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | GERNR | Allow NULL? |
| 51 | WERK | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 52 | LAGER | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | LGORT_D | Allow NULL? |
| 53 | CHARGE | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | MCH1 | CHARG_D | Allow NULL? |
| 54 | KUNDE | Customer to Whom Serial Number was Delivered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNDSE | Allow NULL? |
| 55 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | MPLA | WARPL | Allow NULL? |
| 56 | IMRC_POINT | Measuring Point | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | IMPTT | IMRC_POINT | Allow NULL? |
| 57 | REVLV | Revision Level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | REVLV | Allow NULL? |
| 58 | MGANR | Master warranty number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | BGMK | MGANR | Allow NULL? |
| 59 | BEGRUI | Data origin for authorization group field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_BEGRUI | Allow NULL? |
| 60 | S_EQUI | Equipment data exists | char | 1 | 0 | CHAR | (N' ') | Yes | | EQUIP_KNZ | Allow NULL? |
| 61 | S_SERIAL | Serial data when maintaining equipment | char | 1 | 0 | CHAR | (N' ') | Yes | | KZKSD | Allow NULL? |
| 62 | S_KONFI | Configuration supported | char | 1 | 0 | CHAR | (N' ') | Yes | | KONFKNZ | Allow NULL? |
| 63 | S_SALE | Sales equipment | char | 1 | 0 | CHAR | (N' ') | Yes | | SDKNZ | Allow NULL? |
| 64 | S_FHM | Equip. category relevant to production resources and tools | char | 1 | 0 | CHAR | (N' ') | Yes | | FHMKZ | Allow NULL? |
| 65 | S_ELSE | Indicator: Other Data Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ELSE_KNZ | Allow NULL? |
| 66 | S_ISU | IS-U data | char | 1 | 0 | CHAR | (N' ') | Yes | | ISU_KNZ | Allow NULL? |
| 67 | S_EQBS | EQSI Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | KZEQBS | Allow NULL? |
| 68 | S_FLEET | Indicator: Fleet object active | char | 1 | 0 | CHAR | (N' ') | Yes | | FLEET_KNZ | Allow NULL? |
| 69 | BSTVP | Stock Check for Serial Numbers | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTVP | Allow NULL? |
| 70 | SPARTE | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPARTE | Allow NULL? |
| 71 | HANDLE | SAP Development Reserve: Integration of Date Segment (Key) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | ITOBTMP_TSEGGUID | Allow NULL? |
| 72 | TSEGTP | SAP Development Reserve: Integration Date Segment (Tempate) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ITOBTMP_TSEGTEMPLA | Allow NULL? |
| 73 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | EMATN | Allow NULL? |
| 74 | ACT_CHANGE_AA | Change Equipment Master when Changing Asset | char | 1 | 0 | CHAR | (N' ') | Yes | | AAPM_ACT_CHANGE_AA | Allow NULL? |
| 75 | S_CC | Configuration Control Data | char | 1 | 0 | CHAR | (N' ') | Yes | | CCC_KNZ | Allow NULL? |
| 76 | DATLWB | Date of Last Goods Movement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATLWB | Allow NULL? |
| 77 | DATBI | Valid To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATBI | Allow NULL? |
| 78 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | EQLFN | Allow NULL? |
| 79 | EQUZN | Number of next EquipUsagePeriod on same day | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | EQNNR | Allow NULL? |
| 80 | TIMBI | Equipment usage period time stamp | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TIMBI | Allow NULL? |
| 81 | ESTAI | SAP Development Reserve: Format CHAR, Length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_001 | Allow NULL? |
| 82 | ESTAE | SAP Development reserve: Format CHAR, length 4 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_004 | Allow NULL? |
| 83 | STNAM | SAP Development Reserve: Format CHAR, Length 12 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_012 | Allow NULL? |
| 84 | DATAB | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAB | Allow NULL? |
| 85 | IWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | IWERK | Allow NULL? |
| 86 | IWERKI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 87 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | SUBMT | Allow NULL? |
| 88 | MAPAR | Manufacturer part number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MAPAR | Allow NULL? |
| 89 | HEQUI | Superordinate Equipment | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | HEQUI | Allow NULL? |
| 90 | HEQNR | Equipment position at InstallLoc (Superior Equip./FunctLoc) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | HEQNR | Allow NULL? |
| 91 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | INGRP | Allow NULL? |
| 92 | INGRPI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 93 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PM_OBJTY | Allow NULL? |
| 94 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | LGWID | Allow NULL? |
| 95 | GEWRKI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 96 | TIDNR | Technical identification number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | TIDNR | Allow NULL? |
| 97 | TIDNRI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 98 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ILOAN | Allow NULL? |
| 99 | KUND1 | Customer number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUND1 | Allow NULL? |
| 100 | KUND2 | End customer number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUND2 | Allow NULL? |
| 101 | KUND3 | Operator | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUND3 | Allow NULL? |
| 102 | LIZNR | Equipment license number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | LIZNR | Allow NULL? |
| 103 | RBNR | Catalog Profile | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | * | RBNR | Allow NULL? |
| 104 | EZDAT | Date, intended for SAP internal use | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EQDAT | Allow NULL? |
| 105 | EZBER | Technical information, intended for SAP internal use | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | EQBER | Allow NULL? |
| 106 | EZNUM | Numerical field, intended for SAP internal use | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | EQNUM | Allow NULL? |
| 107 | RBNR_I | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 108 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | IBLNR | Allow NULL? |
| 109 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 110 | PVS_FOCUS | Internal Identification for PVS Objects | varbinary | 16 | 0 | RAW | | Yes | | PVS_GUID_CCC | |
| 111 | PPEGUID | Internal Identification for PVS Objects | varbinary | 16 | 0 | RAW | | Yes | | PVS_GUID_CCC | |
| 112 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TECHS | Allow NULL? |
| 113 | FUNCID | Function Identifier | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CCC_FUNCID | Allow NULL? |
| 114 | FRCFIT | Indicator: Forced Installation/Dismantling | char | 1 | 0 | CHAR | (N' ') | Yes | | CCC_FRCFIT | Allow NULL? |
| 115 | FRCRMV | Force Dismantling Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | CCC_FRCRMV | Allow NULL? |
| 116 | SPRAS | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | * | SPRAS | Allow NULL? |
| 117 | EQKTX | Description of technical object | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | KTX01 | Allow NULL? |
| 118 | KZLTX | Long Text Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZLTA | Allow NULL? |
| 119 | TXASP | Primary language indicator for text segment | char | 1 | 0 | CHAR | (N' ') | Yes | | KZMLA | Allow NULL? |
| 120 | EQKTU | Equipment description in capital letters | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | EQKTU | Allow NULL? |
| 121 | TPLNR | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TPLNR | Allow NULL? |
| 122 | ABCKZ | ABC indicator for technical object | char | 1 | 0 | CHAR | (N' ') | Yes | * | ABCKZ | Allow NULL? |
| 123 | ABCKZI | Data origin for ABC indicator field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_ABCKZI | Allow NULL? |
| 124 | EQFNR | Sort field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | EQFNR | Allow NULL? |
| 125 | EQFNRI | Data origin for sort field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_EQFNRI | Allow NULL? |
| 126 | SWERK | Maintenance plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SWERK | Allow NULL? |
| 127 | SWERKI | Data origin for maintenance plant field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_SWERKI | Allow NULL? |
| 128 | STORT | Location of maintenance object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PMLOC | Allow NULL? |
| 129 | STORTI | Data origin for location field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_STORTI | Allow NULL? |
| 130 | MSGRP | Room | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | RAUMNR | Allow NULL? |
| 131 | MSGRPI | Data origin for room number field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_MSGRPI | Allow NULL? |
| 132 | BEBER | Plant section | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BEBER | Allow NULL? |
| 133 | BEBERI | Data origin for plant section field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_BEBERI | Allow NULL? |
| 134 | CR_OBJTY | Object types of the CIM resource | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CR_OBJTY | Allow NULL? |
| 135 | PPSID | Object ID of PP work center | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PPSID | Allow NULL? |
| 136 | PPSIDI | Data origin for PP work center field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_PPSIDI | Allow NULL? |
| 137 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 138 | GSBERI | Data origin for business area field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_GSBERI | Allow NULL? |
| 139 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 140 | KOKRSI | Data origin for controlling area field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_KOKRSI | Allow NULL? |
| 141 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 142 | KOSTLI | Data origin for cost center field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_KOSTLI | Allow NULL? |
| 143 | PROID | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 144 | PROIDI | Data origin for WBS element field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_PROIDI | Allow NULL? |
| 145 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 146 | BUKRSI | Data origin for company code field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_BUKRSI | Allow NULL? |
| 147 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ANLN1 | Allow NULL? |
| 148 | ANLNRI | Data origin for asset main no./sub-no. fields | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_ANLNRI | Allow NULL? |
| 149 | ANLUN | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ANLN2 | Allow NULL? |
| 150 | ANLUNI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 151 | DAUFN | Standing order number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | DAUFN | Allow NULL? |
| 152 | DAUFNI | Data origin of standing order number field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_DAUFNI | Allow NULL? |
| 153 | AUFNR | Settlement order | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ILOM_ORDST | Allow NULL? |
| 154 | AUFNRI | Data origin for settlement order field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_AUFNRI | Allow NULL? |
| 155 | TPLNRI | Data origin for functional location field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_TPLNRI | Allow NULL? |
| 156 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 157 | VKORGI | Data origin for sales organization field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_VKORGI | Allow NULL? |
| 158 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VTWEG | Allow NULL? |
| 159 | VTWEGI | Data origin of distribution channel field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_VTWEGI | Allow NULL? |
| 160 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART | Allow NULL? |
| 161 | SPARTI | Data origin for division field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_SPARTI | Allow NULL? |
| 162 | ADRNR | Address number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AD_ADDRNUM | Allow NULL? |
| 163 | ADRNRI | Data origin for address field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_ADRNRI | Allow NULL? |
| 164 | OWNER | Object reference indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ILOM_OWNER | Allow NULL? |
| 165 | VKBUR | Sales Office | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKBUR | Allow NULL? |
| 166 | VKGRP | Sales Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VKGRP | Allow NULL? |
| 167 | LVORZ | SAP Development Reserve: Format CHAR, Length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_001 | Allow NULL? |
| 168 | ERNAZ | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 169 | ERDAZ | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 170 | AENAZ | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 171 | AEDAZ | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 172 | ARBPL_LOC | Work center | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ARBPL | Allow NULL? |
| 173 | ARBPL | Work center | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ARBPL | Allow NULL? |
| 174 | SYSTEM_STATUS | Display lines for system status | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ILOM_STTXS | Allow NULL? |
| 175 | USER_STATUS | Display lines for user status | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ILOM_STTXU | Allow NULL? |
| 176 | SYST_STATUS_CODE | Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TXT50 | Allow NULL? |
| 177 | USER_STATUS_CODE | Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TXT50 | Allow NULL? |
| 178 | TPLNR_EXT | | nvarchar | 40 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 179 | LBBSA | Stock Type of Goods Movement (Primary Posting) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T156C | LBBSA | Allow NULL? |
| 180 | B_WERK | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 181 | B_LAGER | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGORT_D | Allow NULL? |
| 182 | B_CHARGE | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | B_CHARGE | Allow NULL? |
| 183 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | SOBKZ | Allow NULL? |
| 184 | KUNNR | Customer account number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | B_KUNNR | Allow NULL? |
| 185 | LIFNR | Account number of the vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | B_LIFNR | Allow NULL? |
| 186 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KDAUF | Allow NULL? |
| 187 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 188 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 189 | DISUB_OWNER | Owner of stock | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OWNER_D | Allow NULL? |