SCRM_AM
Tables (50)
AMS_COMPO_CUST_RSLT
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- PRJ_NO — VARCHAR2(150) — Primary key — NOT NULL
- CAR_NO — VARCHAR2(150) — Primary key — NOT NULL
- SITE_NM — VARCHAR2(600) — NOT NULL
- INST_DT — VARCHAR2(24) — NOT NULL
- MATER_LIFE_MTH_NB — NUMBER(22) — NOT NULL
- SALE_AMT — NUMBER(22) — NOT NULL
- MATER_LIFE_MTH_SNB — NUMBER(22) — NOT NULL
- SALE_UNIT_AMT — NUMBER(22) — NOT NULL
- CUST_YN — VARCHAR2(3) — NOT NULL
- MEMO_CONT — VARCHAR2(3000) — NOT NULL
- EMPL_TEL_CONT — VARCHAR2(3000) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AMS_COMPO_LIFE_MST
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- CRN_SEQ — VARCHAR2(60) — Primary key — NOT NULL
- CRN_CNT — NUMBER(22) — NOT NULL
- MEMO_CONT — VARCHAR2(3000) — NOT NULL
- ATTH_FILE_GCD_ID — VARCHAR2(150) — NOT NULL
- TYPE — VARCHAR2(60) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AMS_COMPO_LIFE_RSLT
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- PRJ_NO — VARCHAR2(54) — Primary key — NOT NULL
- CAR_NO — VARCHAR2(27) — Primary key — NOT NULL
- LIFE_CAR — VARCHAR2(9) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(36) — Primary key — NOT NULL
- FTRM_MODEL — VARCHAR2(45) — NOT NULL
- MAPI_MODEL — VARCHAR2(180) — NOT NULL
- MODEL_VAL — NUMBER(22) — NOT NULL
- CRTER_CD — VARCHAR2(9) — NOT NULL
- BASE_LIFE — NUMBER(22) — NOT NULL
- SPEC_NO — VARCHAR2(150) — NOT NULL
- LIFE_FC — NUMBER(22) — NOT NULL
- FC_VAL — NUMBER(22) — NOT NULL
- LIFE_SP — NUMBER(22) — NOT NULL
- SP_VAL — NUMBER(22) — NOT NULL
- LIFE_SEAT — NUMBER(22) — NOT NULL
- SEAT_VAL — NUMBER(22) — NOT NULL
- MATER_LIFE_MTH_NB — NUMBER(22) — NOT NULL
- ITEM_NM — VARCHAR2(150) — NOT NULL
- RM_SVC_ITEM_NM — VARCHAR2(162) — NOT NULL
- COMPO_PART — VARCHAR2(90) — NOT NULL
- SALE_AMT — NUMBER(22) — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- COMPL_INST_DT — VARCHAR2(24) — NOT NULL
- CHNG_LAST_CHNG_DT — VARCHAR2(24) — NOT NULL
- DRAW_NO — VARCHAR2(150) — NOT NULL
- SAVE_LOC — VARCHAR2(36) — NOT NULL
- EXPECT_DT — VARCHAR2(24) — NOT NULL
- DISPLAY_YN — VARCHAR2(3) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- USE_YN — VARCHAR2(3) — NOT NULL
- CUST_YN — VARCHAR2(3) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AMS_COMPO_MATNO_COMPO_MAPI
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATNO — VARCHAR2(150) — Primary key — NOT NULL
- ITEM_NM — VARCHAR2(150) — NOT NULL
- SPEC — VARCHAR2(300) — NOT NULL
- SIZE1 — VARCHAR2(300) — NOT NULL
- DRAW_NO — VARCHAR2(150) — NOT NULL
- MATER_PART — VARCHAR2(150) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AMS_COMPO_SEND_HIST
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- PRJ_NO — VARCHAR2(150) — Primary key — NOT NULL
- CAR_NO — VARCHAR2(150) — Primary key — NOT NULL
- SEND_SEQ — VARCHAR2(150) — Primary key — NOT NULL
- SEND_DT — VARCHAR2(24) — NOT NULL
- REC_CONT — VARCHAR2(600) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AMS_STAI_BASE_LIFE_LGCY
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- COMPO_PART — VARCHAR2(90) — Primary key — NOT NULL
- COMPO_CRTER — VARCHAR2(9) — Primary key — NOT NULL
- BASE_LIFE — NUMBER(22) — NOT NULL
- MODEL_WBS_T — NUMBER(22) — NOT NULL
- MODEL_WBS_S — NUMBER(22) — NOT NULL
- MODEL_WBLX — NUMBER(22) — NOT NULL
- MODEL_WBHS — NUMBER(22) — NOT NULL
- MODEL_STVF — NUMBER(22) — NOT NULL
- MODEL_SSVF — NUMBER(22) — NOT NULL
- MODEL_OLD — NUMBER(22) — NOT NULL
- MODEL_LXVF — NUMBER(22) — NOT NULL
- MODEL_HSVF_SUVF — NUMBER(22) — NOT NULL
- MODEL_FI_TS — NUMBER(22) — NOT NULL
- COMPO_FC — NUMBER(22) — NOT NULL
- COMPO_SP — NUMBER(22) — NOT NULL
- COMPO_SEAT — NUMBER(22) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_A017
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(12) — Primary key — NOT NULL
- KAPPL — VARCHAR2(6) — Primary key — NOT NULL
- KSCHL — VARCHAR2(12) — Primary key — NOT NULL
- LIFNR — VARCHAR2(30) — Primary key — NOT NULL
- MATNR — VARCHAR2(54) — Primary key — NOT NULL
- EKORG — VARCHAR2(12) — Primary key — NOT NULL
- WERKS — VARCHAR2(12) — Primary key — NOT NULL
- ESOKZ — VARCHAR2(3) — Primary key — NOT NULL
- DATBI — VARCHAR2(24) — Primary key — NOT NULL
- DATAB — VARCHAR2(24) — NOT NULL
- KNUMH — VARCHAR2(30) — NOT NULL
- KBETR — NUMBER(22) — NOT NULL
- KONWA — VARCHAR2(45) — NOT NULL
- LOEKZ — VARCHAR2(3) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — " — NOT NULL
AM_BLOCK_GCD_INFO
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- BLOCK_GCD_CD — VARCHAR2(45) — Primary key — NOT NULL
- DCD_CD — VARCHAR2(18) — Primary key — NOT NULL
- ITEMNM — VARCHAR2(450) — NOT NULL
- BLOCK_1 — VARCHAR2(36) — NOT NULL
- BLOCK_2 — VARCHAR2(36) — NOT NULL
- BLOCK_3 — VARCHAR2(36) — NOT NULL
- BLOCK_4 — VARCHAR2(36) — NOT NULL
- BLOCK_5 — VARCHAR2(36) — NOT NULL
- BLOCK_6 — VARCHAR2(36) — NOT NULL
- BLOCK_7 — VARCHAR2(36) — NOT NULL
- BLOCK_8 — VARCHAR2(36) — NOT NULL
- BLOCK_9 — VARCHAR2(36) — NOT NULL
- BLOCK_10 — VARCHAR2(36) — NOT NULL
- BLOCK_11 — VARCHAR2(36) — NOT NULL
- BLOCK_12 — VARCHAR2(36) — NOT NULL
- BLOCK_13 — VARCHAR2(36) — NOT NULL
- BLOCK_14 — VARCHAR2(36) — NOT NULL
- BLOCK_15 — VARCHAR2(36) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_BOM_CHRG_MNG
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- BOM_MNG_NO — VARCHAR2(135) — Primary key — NOT NULL
- QUOT_CHRG_DCD — VARCHAR2(9) — Primary key — NOT NULL
- PDT_DCD — VARCHAR2(9) — Primary key — NOT NULL
- BOM_MATER_YN — VARCHAR2(9) — NOT NULL
- BOM_CHRG_SCHE_DT — VARCHAR2(72) — NOT NULL
- ACTMT_DT — VARCHAR2(72) — NOT NULL
- ACTMT_DT_INFO_INPT_DT — VARCHAR2(72) — NOT NULL
- ACTMT_DT_INFO_KEYB — VARCHAR2(90) — NOT NULL
- LAYOUT_REQ_DT — VARCHAR2(72) — NOT NULL
- LAYOUT_CMPT_DT — VARCHAR2(72) — NOT NULL
- LAYOUT_INFO_INPT_DT — VARCHAR2(72) — NOT NULL
- LAYOUT_INFO_KEYB — VARCHAR2(90) — NOT NULL
- BOM_SPEC_THF_INPT_DT — VARCHAR2(72) — NOT NULL
- BOM_SPEC_TRASM_DT — VARCHAR2(72) — NOT NULL
- BOM_SPEC_LAST_TRASM_DT — VARCHAR2(72) — NOT NULL
- BOM_TRASM_YN — VARCHAR2(9) — NOT NULL
- WBS_NO — VARCHAR2(33) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_BOM_MATER_MNG
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATER_NO_1 — VARCHAR2(162) — Primary key — NOT NULL
- MATER_NO_2 — VARCHAR2(162) — Primary key — NOT NULL
- LEVL — VARCHAR2(90) — NOT NULL
- MATER_TYPE — VARCHAR2(36) — NOT NULL
- MATER_CONT — VARCHAR2(294) — NOT NULL
- MODEL — VARCHAR2(432) — NOT NULL
- QTMT — VARCHAR2(540) — NOT NULL
- STD — VARCHAR2(540) — NOT NULL
- UNIT — VARCHAR2(30) — NOT NULL
- MATER_NM — VARCHAR2(360) — NOT NULL
- RM_MATER_NM — VARCHAR2(360) — NOT NULL
- COSP — NUMBER(22) — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- CLASI — VARCHAR2(225) — NOT NULL
- PUT_HEADC — NUMBER(22) — NOT NULL
- WORK_TM — NUMBER(22) — NOT NULL
- RATIO — NUMBER(22) — NOT NULL
- WEGI — NUMBER(22) — NOT NULL
- BLOCK_NO — VARCHAR2(30) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_BOM_SPEC_CHACT_VAL_DESG
- MANDT — VARCHAR2(27) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- WBS_NO — VARCHAR2(33) — Primary key — NOT NULL
- CHACT_GCD — VARCHAR2(135) — Primary key — NOT NULL
- CHACT_CD — VARCHAR2(15) — Primary key — NOT NULL
- DGRE — VARCHAR2(18) — Primary key — NOT NULL
- CHACT_CD_NM — VARCHAR2(900) — NOT NULL
- CHACT_CD_VAL — VARCHAR2(135) — NOT NULL
- CHACT_CD_VAL_NM — VARCHAR2(354) — NOT NULL
- SAVE_YN — VARCHAR2(9) — NOT NULL
- PDM_TRASM_YN — VARCHAR2(9) — NOT NULL
- SALE_DOC — VARCHAR2(90) — NOT NULL
- CHRG_NO — VARCHAR2(30) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(42) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(42) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_BOM_SPEC_TRASM_HIST
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- WBS_NO — VARCHAR2(33) — Primary key — NOT NULL
- DGRE — VARCHAR2(18) — Primary key — NOT NULL
- PDM_TRASM_YN — VARCHAR2(9) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_BOM_YOWUL
- MANDT — VARCHAR2(3) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Primary key — NOT NULL
- PDT_DCD — VARCHAR2(90) — Primary key — NOT NULL
- CHACT_GCD — VARCHAR2(135) — Primary key — NOT NULL
- CHACT_CD — VARCHAR2(15) — Primary key — NOT NULL
- BLOCK_NO — VARCHAR2(9) — NOT NULL
- YOWUL — VARCHAR2(5) — NOT NULL
- BUKRS — VARCHAR2(4) — NOT NULL
- CHACT_GCD_NM — VARCHAR2(900) — NOT NULL
- CHACT_CD_NM — VARCHAR2(900) — NOT NULL
- NUM_TP_YN — VARCHAR2(9) — NOT NULL
- ESTL_INPT_YN — VARCHAR2(9) — NOT NULL
- SORT_ORDER — VARCHAR2(36) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
- USE_YN — VARCHAR2(6) — NOT NULL
AM_CHACT_VAL_LIST
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- PDT_DCD — VARCHAR2(90) — Primary key — NOT NULL
- CHACT_CD — VARCHAR2(135) — Primary key — NOT NULL
- CHACT_CD_VAL — VARCHAR2(135) — Primary key — NOT NULL
- CHACT_CD_NM — VARCHAR2(900) — NOT NULL
- CHACT_CD_VAL_NM — VARCHAR2(900) — NOT NULL
- CHACT_CD_DESC — VARCHAR2(900) — NOT NULL
- SORT_ORDER — VARCHAR2(36) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
- USE_YN — VARCHAR2(6) — NOT NULL
AM_COOP_BIZC_IVT_COLCT
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(24) — Primary key — NOT NULL
- PLANT — VARCHAR2(24) — Primary key — NOT NULL
- SAVE_LOC — VARCHAR2(24) — Primary key — NOT NULL
- ESTMA_TYPE — VARCHAR2(4) — Primary key — NOT NULL
- MATER_TYPE — VARCHAR2(24) — NOT NULL
- SAVE_LOC_CONT — VARCHAR2(62) — NOT NULL
- MATER_CONT — VARCHAR2(196) — NOT NULL
- SPECL_IVT_DIRT — VARCHAR2(6) — NOT NULL
- SIMP_CONT — VARCHAR2(48) — NOT NULL
- BASE_UNIT — VARCHAR2(20) — NOT NULL
- CRE_DATE — VARCHAR2(48) — NOT NULL
- CRE_TIME — VARCHAR2(36) — NOT NULL
- ASIS_CRE_ID — VARCHAR2(72) — NOT NULL
- ESTMA_AVLB_IVT — NUMBER(22) — NOT NULL
- LSTMON_AVLB_IVT — NUMBER(22) — NOT NULL
- MONBFLST_AVLB_IVT — NUMBER(22) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_COST_CHRG_MNG
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- CHRG_NO — VARCHAR2(30) — Primary key — NOT NULL
- COST_SEQ_NO — NUMBER(22) — Primary key — NOT NULL
- COST_DCD — VARCHAR2(60) — NOT NULL
- CHRG_AMT — NUMBER(22) — NOT NULL
- ETC_CONT — VARCHAR2(900) — NOT NULL
- DEL_YN — VARCHAR2(3) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
- COST_ACCT — VARCHAR2(100) — NOT NULL
AM_EINA
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(12) — Primary key — NOT NULL
- INFNR — VARCHAR2(30) — Primary key — NOT NULL
- MATNR — VARCHAR2(54) — NOT NULL
- MATKL — VARCHAR2(27) — NOT NULL
- LIFNR — VARCHAR2(30) — NOT NULL
- LOEKZ — VARCHAR2(3) — NOT NULL
- ERDAT — VARCHAR2(24) — NOT NULL
- ERNAM — VARCHAR2(36) — NOT NULL
- TXZ01 — VARCHAR2(120) — NOT NULL
- SORTL — VARCHAR2(30) — NOT NULL
- MEINS — VARCHAR2(9) — NOT NULL
- UMREZ — NUMBER(22) — NOT NULL
- UMREN — NUMBER(22) — NOT NULL
- IDNLF — VARCHAR2(105) — NOT NULL
- VERKF — VARCHAR2(90) — NOT NULL
- TELF1 — VARCHAR2(48) — NOT NULL
- MAHN1 — NUMBER(22) — NOT NULL
- MAHN2 — NUMBER(22) — NOT NULL
- MAHN3 — NUMBER(22) — NOT NULL
- URZNR — VARCHAR2(30) — NOT NULL
- URZDT — VARCHAR2(24) — NOT NULL
- URZLA — VARCHAR2(9) — NOT NULL
- URZTP — VARCHAR2(3) — NOT NULL
- URZZT — VARCHAR2(48) — NOT NULL
- LMEIN — VARCHAR2(9) — NOT NULL
- REGIO — VARCHAR2(9) — NOT NULL
- VABME — VARCHAR2(3) — NOT NULL
- LTSNR — VARCHAR2(18) — NOT NULL
- LTSSF — VARCHAR2(15) — NOT NULL
- WGLIF — VARCHAR2(54) — NOT NULL
- RUECK — VARCHAR2(6) — NOT NULL
- LIFAB — VARCHAR2(24) — NOT NULL
- LIFBI — VARCHAR2(24) — NOT NULL
- KOLIF — VARCHAR2(30) — NOT NULL
- ANZPU — NUMBER(22) — NOT NULL
- PUNEI — VARCHAR2(9) — NOT NULL
- RELIF — VARCHAR2(3) — NOT NULL
- MFRNR — VARCHAR2(30) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — " — NOT NULL
AM_KONP
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- KNUMH — VARCHAR2(90) — Primary key — NOT NULL
- KOPOS — VARCHAR2(18) — Primary key — NOT NULL
- KAPPL — VARCHAR2(18) — NOT NULL
- KSCHL — VARCHAR2(36) — NOT NULL
- KNUMT — VARCHAR2(90) — NOT NULL
- STFKZ — VARCHAR2(9) — NOT NULL
- KZBZG — VARCHAR2(9) — NOT NULL
- KSTBM — NUMBER(22) — NOT NULL
- KONMS — VARCHAR2(27) — NOT NULL
- KSTBW — NUMBER(22) — NOT NULL
- KONWS — VARCHAR2(45) — NOT NULL
- KRECH — VARCHAR2(9) — NOT NULL
- KBETR — NUMBER(22) — NOT NULL
- KONWA — VARCHAR2(45) — NOT NULL
- KPEIN — NUMBER(22) — NOT NULL
- KMEIN — VARCHAR2(27) — NOT NULL
- PRSCH — VARCHAR2(36) — NOT NULL
- KUMZA — NUMBER(22) — NOT NULL
- KUMNE — NUMBER(22) — NOT NULL
- MEINS — VARCHAR2(27) — NOT NULL
- MXWRT — NUMBER(22) — NOT NULL
- GKWRT — NUMBER(22) — NOT NULL
- PKWRT — NUMBER(22) — NOT NULL
- FKWRT — NUMBER(22) — NOT NULL
- RSWRT — NUMBER(22) — NOT NULL
- KWAEH — VARCHAR2(45) — NOT NULL
- UKBAS — NUMBER(22) — NOT NULL
- KZNEP — VARCHAR2(9) — NOT NULL
- KUNNR — VARCHAR2(90) — NOT NULL
- LIFNR — VARCHAR2(90) — NOT NULL
- MWSK1 — VARCHAR2(18) — NOT NULL
- LOEVM_KO — VARCHAR2(9) — NOT NULL
- ZAEHK_IND — VARCHAR2(18) — NOT NULL
- BOMAT — VARCHAR2(162) — NOT NULL
- KBRUE — NUMBER(22) — NOT NULL
- KSPAE — VARCHAR2(9) — NOT NULL
- BOSTA — VARCHAR2(9) — NOT NULL
- KNUMA_PI — VARCHAR2(90) — NOT NULL
- KNUMA_AG — VARCHAR2(90) — NOT NULL
- KNUMA_SQ — VARCHAR2(90) — NOT NULL
- VALTG — VARCHAR2(18) — NOT NULL
- VALDT — VARCHAR2(72) — NOT NULL
- ZTERM — VARCHAR2(36) — NOT NULL
- ANZAUF — VARCHAR2(18) — NOT NULL
- MIKBAS — NUMBER(22) — NOT NULL
- MXKBAS — NUMBER(22) — NOT NULL
- KOMXWRT — NUMBER(22) — NOT NULL
- KLF_STG — VARCHAR2(36) — NOT NULL
- KLF_KAL — VARCHAR2(36) — NOT NULL
- VKKAL — VARCHAR2(9) — NOT NULL
- AKTNR — VARCHAR2(90) — NOT NULL
- KNUMA_BO — VARCHAR2(90) — NOT NULL
- MWSK2 — VARCHAR2(18) — NOT NULL
- VERTT — VARCHAR2(9) — NOT NULL
- VERTN — VARCHAR2(117) — NOT NULL
- VBEWA — VARCHAR2(36) — NOT NULL
- MDFLG — VARCHAR2(9) — NOT NULL
- KFRST — VARCHAR2(9) — NOT NULL
- … +10
AM_MARC_MST
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(36) — Primary key — NOT NULL
- PLNT_NO — VARCHAR2(12) — Primary key — NOT NULL
- RQRD_TM — NUMBER(22) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MATER_CAR_DOOR_MAPI
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- DRAW_NO — VARCHAR2(51) — Primary key — NOT NULL
- DOOR_MOTOR_MATNO — VARCHAR2(180) — NOT NULL
- PROXIMITY_SWITCH_MATNO — VARCHAR2(180) — NOT NULL
- CAR_DOOR_CMPNT_MATNO — VARCHAR2(180) — NOT NULL
- CLTCH_MATNO — VARCHAR2(180) — NOT NULL
- TIMING_BELT_MATNO — VARCHAR2(180) — NOT NULL
- GATE_SW_MATNO — VARCHAR2(180) — NOT NULL
- HNER_PL_LH_MATNO — VARCHAR2(180) — NOT NULL
- HNER_PL_RH_MATNO — VARCHAR2(180) — NOT NULL
- ROP_ASSY_MATNO — VARCHAR2(60) — NOT NULL
- TENSION_PLLY_ROP_MATNO — VARCHAR2(180) — NOT NULL
- TENSION_PLLY_BELT_MATNO — VARCHAR2(180) — NOT NULL
- THRESHOLD_ASSY_MATNO — VARCHAR2(180) — NOT NULL
- DRIVE_PLLY_MATNO — VARCHAR2(180) — NOT NULL
- DOOR_ENCDR_MATNO — VARCHAR2(180) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MATER_CPASSY
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- DRAW_NO — VARCHAR2(51) — Primary key — NOT NULL
- SAF_BD_MATNO — VARCHAR2(660) — NOT NULL
- VCON_MATNO — VARCHAR2(660) — NOT NULL
- NFB_2_MATNO — VARCHAR2(660) — NOT NULL
- BKA_MATNO — VARCHAR2(660) — NOT NULL
- TRANS_MATNO — VARCHAR2(660) — NOT NULL
- PWR_S_UP_PLY_MATNO — VARCHAR2(660) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MATER_CPASSY_PWR_MTRL
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- DRAW_NO — VARCHAR2(51) — Primary key — NOT NULL
- NFB_1_MATNO — VARCHAR2(660) — NOT NULL
- MC_2_MATNO — VARCHAR2(660) — NOT NULL
- DCR_OR_ACR_MATNO — VARCHAR2(660) — NOT NULL
- NOISE_FILTER_MATNO — VARCHAR2(660) — NOT NULL
- BKR_WBS_T_WBLX_MATNO — VARCHAR2(660) — NOT NULL
- BKR_WBS_S_MATNO — VARCHAR2(660) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MATER_DOC_HANDL_SERI
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(12) — Primary key — NOT NULL
- REQNR — VARCHAR2(30) — Primary key — NOT NULL
- REQITEM — VARCHAR2(15) — Primary key — NOT NULL
- GJAHR — VARCHAR2(12) — Primary key — NOT NULL
- BUDAT — VARCHAR2(24) — Primary key — NOT NULL
- MBLNR — VARCHAR2(30) — Primary key — NOT NULL
- MITEM — VARCHAR2(18) — NOT NULL
- MATNR — VARCHAR2(54) — NOT NULL
- MAC_N — NUMBER(22) — NOT NULL
- SE_NO — VARCHAR2(120) — NOT NULL
- DEL_F — VARCHAR2(3) — NOT NULL
- MAC_N1 — VARCHAR2(36) — NOT NULL
- SE_NO2 — VARCHAR2(120) — NOT NULL
- SDATE — VARCHAR2(24) — NOT NULL
- STIME — VARCHAR2(18) — NOT NULL
- UDATE — VARCHAR2(24) — NOT NULL
- UTIME — VARCHAR2(18) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — " — NOT NULL
AM_MATER_IMG
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(162) — Primary key — NOT NULL
- ERDAT — VARCHAR2(72) — NOT NULL
- ERZZT — VARCHAR2(54) — NOT NULL
- AEDAT — VARCHAR2(72) — NOT NULL
- AEZZT — VARCHAR2(54) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MATER_INVERTER_MAPI
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- DRAW_NO — VARCHAR2(51) — Primary key — NOT NULL
- MAIN_IVT_MATNO — VARCHAR2(660) — NOT NULL
- MAIN_BD_MATNO — VARCHAR2(660) — NOT NULL
- ENCD_BD_MATNO — VARCHAR2(660) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MATER_MST
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(108) — Primary key — NOT NULL
- MATER_TYPE — VARCHAR2(24) — NOT NULL
- LGCY_MATER_NO — VARCHAR2(34) — NOT NULL
- MATER_CONT — VARCHAR2(196) — NOT NULL
- BASE_UNIT — VARCHAR2(20) — NOT NULL
- MATER_GCD — VARCHAR2(14) — NOT NULL
- EXN_MATER_GCD — VARCHAR2(108) — NOT NULL
- BLOCK_NO — VARCHAR2(54) — NOT NULL
- TOTWEHT — NUMBER(22) — NOT NULL
- PURE_WEHT — NUMBER(22) — NOT NULL
- WEHT_UNIT — VARCHAR2(20) — NOT NULL
- VOLU — NUMBER(22) — NOT NULL
- VOLU_UNIT — VARCHAR2(20) — NOT NULL
- SIZE1 — VARCHAR2(360) — NOT NULL
- BASE_MATER — VARCHAR2(288) — NOT NULL
- DRAW_NO — VARCHAR2(240) — NOT NULL
- DRAW_NO2 — VARCHAR2(24) — NOT NULL
- ITEMNM — VARCHAR2(300) — NOT NULL
- SPEC — VARCHAR2(360) — NOT NULL
- EXEDT — VARCHAR2(48) — NOT NULL
- EXETM — VARCHAR2(36) — NOT NULL
- EXEID — VARCHAR2(72) — NOT NULL
- CHAF_BF_SALE_UNITP — NUMBER(22) — NOT NULL
- SALE_UNITP — NUMBER(22) — NOT NULL
- GNITEM_COSP — NUMBER(22) — NOT NULL
- RPITEM_COSP — NUMBER(22) — NOT NULL
- SALE_UNITP_RAI_RT — NUMBER(22) — NOT NULL
- PUT_HEADC — NUMBER(22) — NOT NULL
- STD_WORKH_TM — VARCHAR2(120) — NOT NULL
- CURR_KY — VARCHAR2(30) — NOT NULL
- NEW_BOX_NO — VARCHAR2(30) — NOT NULL
- JAMB_TP — VARCHAR2(18) — NOT NULL
- RM_ITEMNM — VARCHAR2(300) — NOT NULL
- SAMTG1 — NUMBER(22) — NOT NULL
- SAMTG2 — NUMBER(22) — NOT NULL
- ZOPEN — VARCHAR2(6) — NOT NULL
- COCM_PEX_DISP_YN — VARCHAR2(6) — NOT NULL
- TPRY_RET_STRT_DT — VARCHAR2(16) — NOT NULL
- TPRY_RET_END_DT — VARCHAR2(16) — NOT NULL
- TPRY_RET_YN — VARCHAR2(2) — NOT NULL
- ATTACHMENT_GROUP_ID — VARCHAR2(100) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
- RMK — VARCHAR2(360) — NOT NULL
- FM_MATER_DCD — VARCHAR2(6) — NOT NULL
AM_MATER_PART_MAPI_HDO
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- DRAW_NO — VARCHAR2(51) — Primary key — NOT NULL
- ITLK_ASSY_MATNO — VARCHAR2(60) — NOT NULL
- ITLK_KEPR_ASSY_MATNO — VARCHAR2(60) — NOT NULL
- ITLK_SW_ASSY_MATNO — VARCHAR2(60) — NOT NULL
- COMPT_MATNO — VARCHAR2(60) — NOT NULL
- HNGR_PLTE_L_MATNO — VARCHAR2(60) — NOT NULL
- HNGR_PLTE_R_MATNO — VARCHAR2(60) — NOT NULL
- HNGR_RLLR_MATNO — VARCHAR2(60) — NOT NULL
- CNCN_RLLR_MATNO — VARCHAR2(60) — NOT NULL
- ROP_ASSY_MATNO — VARCHAR2(60) — NOT NULL
- SPRG_MATNO — VARCHAR2(60) — NOT NULL
- TNSN_PLLY_MATNO — VARCHAR2(60) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MATER_PART_MAPI_MST
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATER_PART_SEQ — NUMBER(22) — Primary key — NOT NULL
- MATER_PART_CD — VARCHAR2(21) — NOT NULL
- ATTH_FILE_GCD_ID — VARCHAR2(150) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MATER_TRANSACTION_MAPI
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- DRAW_NO — VARCHAR2(51) — Primary key — NOT NULL
- ITEM_NM — VARCHAR2(120) — NOT NULL
- DC_CD — VARCHAR2(15) — NOT NULL
- DRAW_FRNT_TENSION_NO — VARCHAR2(24) — NOT NULL
- MAIN_SHE_MATNO — VARCHAR2(180) — NOT NULL
- BARG_1_MATNO — VARCHAR2(180) — NOT NULL
- BARG_2_MATNO — VARCHAR2(180) — NOT NULL
- BRAKE_MATNO — VARCHAR2(180) — NOT NULL
- BRAKE_SW_MATNO — VARCHAR2(180) — NOT NULL
- BRAKE_COIL_MATNO — VARCHAR2(180) — NOT NULL
- BRAKE_ARM_MATNO — VARCHAR2(180) — NOT NULL
- BRAKE_PAD_SHOE_MATNO — VARCHAR2(180) — NOT NULL
- BRAKE_SPRG_MATNO — VARCHAR2(180) — NOT NULL
- ENCDR_MATNO — VARCHAR2(180) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MBEW
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(12) — Primary key — NOT NULL
- MATNR — VARCHAR2(54) — Primary key — NOT NULL
- BWKEY — VARCHAR2(12) — Primary key — NOT NULL
- BWTAR — VARCHAR2(30) — Primary key — NOT NULL
- LVORM — VARCHAR2(3) — NOT NULL
- LBKUM — NUMBER(22) — NOT NULL
- SALK3 — NUMBER(22) — NOT NULL
- VPRSV — VARCHAR2(3) — NOT NULL
- VERPR — NUMBER(22) — NOT NULL
- STPRS — NUMBER(22) — NOT NULL
- PEINH — NUMBER(22) — NOT NULL
- BKLAS — VARCHAR2(12) — NOT NULL
- SALKV — NUMBER(22) — NOT NULL
- VMKUM — NUMBER(22) — NOT NULL
- VMSAL — NUMBER(22) — NOT NULL
- VMVPR — VARCHAR2(3) — NOT NULL
- VMVER — NUMBER(22) — NOT NULL
- VMSTP — NUMBER(22) — NOT NULL
- VMPEI — NUMBER(22) — NOT NULL
- VMBKL — VARCHAR2(12) — NOT NULL
- VMSAV — NUMBER(22) — NOT NULL
- VJKUM — NUMBER(22) — NOT NULL
- VJSAL — NUMBER(22) — NOT NULL
- VJVPR — VARCHAR2(3) — NOT NULL
- VJVER — NUMBER(22) — NOT NULL
- VJSTP — NUMBER(22) — NOT NULL
- VJPEI — NUMBER(22) — NOT NULL
- VJBKL — VARCHAR2(12) — NOT NULL
- VJSAV — NUMBER(22) — NOT NULL
- LFGJA — VARCHAR2(12) — NOT NULL
- LFMON — VARCHAR2(6) — NOT NULL
- BWTTY — VARCHAR2(3) — NOT NULL
- STPRV — NUMBER(22) — NOT NULL
- LAEPR — VARCHAR2(24) — NOT NULL
- ZKPRS — NUMBER(22) — NOT NULL
- ZKDAT — VARCHAR2(24) — NOT NULL
- TIMESTAMP — NUMBER(22) — NOT NULL
- BWPRS — NUMBER(22) — NOT NULL
- BWPRH — NUMBER(22) — NOT NULL
- VJBWS — NUMBER(22) — NOT NULL
- VJBWH — NUMBER(22) — NOT NULL
- VVJSL — NUMBER(22) — NOT NULL
- VVJLB — NUMBER(22) — NOT NULL
- VVMLB — NUMBER(22) — NOT NULL
- VVSAL — NUMBER(22) — NOT NULL
- ZPLPR — NUMBER(22) — NOT NULL
- ZPLP1 — NUMBER(22) — NOT NULL
- ZPLP2 — NUMBER(22) — NOT NULL
- ZPLP3 — NUMBER(22) — NOT NULL
- ZPLD1 — VARCHAR2(24) — NOT NULL
- ZPLD2 — VARCHAR2(24) — NOT NULL
- ZPLD3 — VARCHAR2(24) — NOT NULL
- PPERZ — VARCHAR2(18) — NOT NULL
- PPERL — VARCHAR2(18) — NOT NULL
- PPERV — VARCHAR2(18) — NOT NULL
- KALKZ — VARCHAR2(3) — NOT NULL
- KALKL — VARCHAR2(3) — NOT NULL
- KALKV — VARCHAR2(3) — NOT NULL
- KALSC — VARCHAR2(18) — NOT NULL
- … +52
AM_MMPR_APPV_INFO
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MMPR_MNG_NO — VARCHAR2(120) — Primary key — NOT NULL
- MMPR_NO — VARCHAR2(60) — Primary key — NOT NULL
- MMPR_DCD — VARCHAR2(6) — NOT NULL
- DOC_STAT — VARCHAR2(6) — NOT NULL
- PLANT — VARCHAR2(24) — NOT NULL
- PRJ_NO — VARCHAR2(144) — NOT NULL
- SIMP_CONT — VARCHAR2(240) — NOT NULL
- CAR_NO — VARCHAR2(144) — NOT NULL
- MODEL — VARCHAR2(30) — NOT NULL
- SPEC — VARCHAR2(180) — NOT NULL
- CAPA — VARCHAR2(240) — NOT NULL
- TL_EIN — VARCHAR2(36) — NOT NULL
- TL_NM — VARCHAR2(120) — NOT NULL
- MOB — VARCHAR2(180) — NOT NULL
- INST_BIZC_CD — VARCHAR2(60) — NOT NULL
- PROB_SMAR — VARCHAR2(3600) — NOT NULL
- NOCUR_DT — VARCHAR2(48) — NOT NULL
- WORK_DT — VARCHAR2(48) — NOT NULL
- MAKE_DT — VARCHAR2(48) — NOT NULL
- WRIT_EIN — VARCHAR2(72) — NOT NULL
- WRIT_NM — VARCHAR2(120) — NOT NULL
- CC — VARCHAR2(60) — NOT NULL
- ACP_DT — VARCHAR2(48) — NOT NULL
- ACCP_EIN — VARCHAR2(60) — NOT NULL
- TMNT_HANDL_DT — VARCHAR2(48) — NOT NULL
- TMNT_PROCR_EIN — VARCHAR2(60) — NOT NULL
- CTMS_PIR_EIN — VARCHAR2(60) — NOT NULL
- ACTI_CHGR_EIN — VARCHAR2(60) — NOT NULL
- TRB_PHMEN_CATE — VARCHAR2(6) — NOT NULL
- TRB_PHMEN_CD_GCD — VARCHAR2(48) — NOT NULL
- TRB_PHMEN_CD — VARCHAR2(24) — NOT NULL
- TRB_PHMEN — VARCHAR2(2400) — NOT NULL
- TRB_CAUSE_CATE — VARCHAR2(6) — NOT NULL
- TRB_CAUSE_CD_GCD — VARCHAR2(48) — NOT NULL
- TRB_CAUSE_CD — VARCHAR2(24) — NOT NULL
- TRB_CAUSE — VARCHAR2(2400) — NOT NULL
- WORK_TM_MI — NUMBER(22) — NOT NULL
- IMPT_DCD — VARCHAR2(6) — NOT NULL
- NM_SET — VARCHAR2(144) — NOT NULL
- NM_SET_1 — VARCHAR2(144) — NOT NULL
- CUST_NO — VARCHAR2(60) — NOT NULL
- SP_CURR_AMT — NUMBER(22) — NOT NULL
- SP_CURR_AMT_1 — NUMBER(22) — NOT NULL
- CURR_KY — VARCHAR2(30) — NOT NULL
- BDGT_CRN_DT — VARCHAR2(48) — NOT NULL
- ACCT_COMP_CD — VARCHAR2(24) — NOT NULL
- ACCT_SP_NO — VARCHAR2(60) — NOT NULL
- ACCT_YEAR — VARCHAR2(24) — NOT NULL
- AUTO_TAX_CALC — VARCHAR2(6) — NOT NULL
- SAL_VAT_CD — VARCHAR2(12) — NOT NULL
- ORG_CHRG_NO — VARCHAR2(60) — NOT NULL
- MMPR_DEL_YN — VARCHAR2(6) — NOT NULL
- MMPR_PROG_STAT — VARCHAR2(6) — NOT NULL
- RMTO_DT — VARCHAR2(48) — NOT NULL
- COMPL_ISP_DT — VARCHAR2(48) — NOT NULL
- MI_DT — VARCHAR2(48) — NOT NULL
- PL_CC — VARCHAR2(60) — NOT NULL
- JQPR_ITEM_CLASI_CD — VARCHAR2(42) — NOT NULL
- … +40
AM_MMPR_APRV_INFO
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MMPR_MNG_NO — VARCHAR2(60) — Primary key — NOT NULL
- MMPR_SEQ_NO — VARCHAR2(40) — Primary key — NOT NULL
- MMPR_APRV_STEP — VARCHAR2(6) — Primary key — NOT NULL
- APRB_1_APRV_STAT — VARCHAR2(6) — NOT NULL
- APRB_1_EIN — VARCHAR2(60) — NOT NULL
- APRB_1_NM — VARCHAR2(72) — NOT NULL
- APRB_1_APRV_DT — VARCHAR2(48) — NOT NULL
- APRB_1_APRV_TM — VARCHAR2(36) — NOT NULL
- APRB_2_APRV_STAT — VARCHAR2(6) — NOT NULL
- APRB_2_EIN — VARCHAR2(60) — NOT NULL
- APRB_2_NM — VARCHAR2(72) — NOT NULL
- APRB_2_APRV_DT — VARCHAR2(48) — NOT NULL
- APRB_2_APRV_TM — VARCHAR2(36) — NOT NULL
- APRB_3_APRV_STAT — VARCHAR2(6) — NOT NULL
- APRB_3_EIN — VARCHAR2(60) — NOT NULL
- APRB_3_NM — VARCHAR2(72) — NOT NULL
- APRB_3_APRV_DT — VARCHAR2(48) — NOT NULL
- APRB_3_APRV_TM — VARCHAR2(36) — NOT NULL
- GW_DRAFT_DOC_NO — VARCHAR2(120) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MMPR_SAP_IF_INFO
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- CHRG_NO — VARCHAR2(20) — Primary key — NOT NULL
- TMC — NUMBER(22) — NOT NULL
- LAEX — NUMBER(22) — NOT NULL
- CURR_KY — VARCHAR2(30) — NOT NULL
- INSIDE_DEPT_1 — VARCHAR2(144) — NOT NULL
- INSIDE_DEPT_2 — VARCHAR2(144) — NOT NULL
- INSIDE_DEPT_3 — VARCHAR2(144) — NOT NULL
- INSIDE_DEPT_IMPT_RATIO_1 — NUMBER(22) — NOT NULL
- INSIDE_DEPT_IMPT_RATIO_2 — NUMBER(22) — NOT NULL
- INSIDE_DEPT_IMPT_RATIO_3 — NUMBER(22) — NOT NULL
- ETC_DEPT — VARCHAR2(144) — NOT NULL
- ETC_DEPT_IMPT_RATIO — NUMBER(22) — NOT NULL
- SAP_IF_YN — VARCHAR2(6) — NOT NULL
- SAP_IF_DT — VARCHAR2(48) — NOT NULL
- MMPR_MNG_NO — VARCHAR2(60) — NOT NULL
- TASK_DCD — VARCHAR2(2) — NOT NULL
- TASK_DCD_DESG_DT — VARCHAR2(48) — NOT NULL
- CRDAT_TEMP — VARCHAR2(48) — NOT NULL
- CRTIM_TEMP — VARCHAR2(48) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- SAP_INF_SUCC_YN — VARCHAR2(2) — NOT NULL
- MMPR_SEQ_NO — VARCHAR2(40) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MMPR_TRB_INFO
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MMPR_MNG_NO — VARCHAR2(60) — Primary key — NOT NULL
- MMPR_SEQ_NO — VARCHAR2(40) — Primary key — NOT NULL
- SER_NO — VARCHAR2(12) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(108) — NOT NULL
- MATER_CONT — VARCHAR2(196) — NOT NULL
- TRB_PHMEN_CATE — VARCHAR2(6) — NOT NULL
- TRB_PHMEN_CD_GCD — VARCHAR2(16) — NOT NULL
- TRB_PHMEN_CD — VARCHAR2(24) — NOT NULL
- TRB_PHMEN — VARCHAR2(240) — NOT NULL
- TRB_CAUSE_CATE — VARCHAR2(6) — NOT NULL
- TRB_CAUSE_CD_GCD — VARCHAR2(48) — NOT NULL
- TRB_CAUSE_CD — VARCHAR2(24) — NOT NULL
- TRB_CAUSE — VARCHAR2(94) — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- BASE_UNIT — VARCHAR2(20) — NOT NULL
- CONSN_DT — VARCHAR2(48) — NOT NULL
- RET_MATER_SERI_NO — VARCHAR2(120) — NOT NULL
- INST_CONSN_MATER_SERI_NO — VARCHAR2(120) — NOT NULL
- RET_TYPE — VARCHAR2(6) — NOT NULL
- RET_DT — VARCHAR2(48) — NOT NULL
- ORG_CHRG_NO — VARCHAR2(60) — NOT NULL
- ORG_CHRG_ITEM — VARCHAR2(30) — NOT NULL
- CHRG_KIND — VARCHAR2(2) — NOT NULL
- MMPR_DEL_YN — VARCHAR2(2) — NOT NULL
- MMPR_PROG_STAT — VARCHAR2(6) — NOT NULL
- MMPR_COMPS_CNTR_NO — VARCHAR2(66) — NOT NULL
- ESTMA_TYPE — VARCHAR2(4) — NOT NULL
- RET_MATER_SERI_NO_MB — VARCHAR2(120) — NOT NULL
- INST_CONSN_MATER_SERI_NO_MB — VARCHAR2(120) — NOT NULL
- SPEC — VARCHAR2(360) — NOT NULL
- SAP_INF_SUCC_YN — VARCHAR2(2) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
- IVTCAPA — VARCHAR2(30) — NOT NULL
- IVTECODE — VARCHAR2(12) — NOT NULL
- CTRECODE — VARCHAR2(60) — NOT NULL
AM_MOD_PROC_MNG
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- WBS_NO — VARCHAR2(33) — Primary key — NOT NULL
- PROC_DCD_CD — VARCHAR2(27) — Primary key — NOT NULL
- SUPP_BIZC_ACCT_NO — VARCHAR2(30) — NOT NULL
- PROC_YN — VARCHAR2(9) — NOT NULL
- REPRE_WORKP_NM — VARCHAR2(180) — NOT NULL
- REPRE_WORKP_MOB_NO — VARCHAR2(180) — NOT NULL
- SITE_ADMIN_NM — VARCHAR2(180) — NOT NULL
- SITE_ADMIN_MOB_NO — VARCHAR2(180) — NOT NULL
- BEG_DT — VARCHAR2(72) — NOT NULL
- COMPL_DT — VARCHAR2(72) — NOT NULL
- ANYTM_ISP_DT — VARCHAR2(72) — NOT NULL
- PROC_SCALE — VARCHAR2(9) — NOT NULL
- RMK — VARCHAR2(2295) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_MOVE_IVT_MNG
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- CHRG_NO — VARCHAR2(30) — Primary key — NOT NULL
- CHRG_ITEM — VARCHAR2(15) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(36) — NOT NULL
- ESTMA_TYPE — VARCHAR2(4) — NOT NULL
- MATER_TYPE — VARCHAR2(36) — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- MOVE_IVT_STAT — VARCHAR2(60) — NOT NULL
- DEL_YN — VARCHAR2(3) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_PDM_BOM_ES_IF_INFO
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- CONSTU_NO — VARCHAR2(216) — Primary key — NOT NULL
- CRN_DT — VARCHAR2(24) — Primary key — NOT NULL
- ITEM_SEQ_NO — VARCHAR2(36) — Primary key — NOT NULL
- SEQ_NO — VARCHAR2(36) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(162) — NOT NULL
- MATER_GCD — VARCHAR2(81) — NOT NULL
- MATER_CONT — VARCHAR2(360) — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- BASE_UNIT — VARCHAR2(30) — NOT NULL
- UPPER_MATER_GCD — VARCHAR2(81) — NOT NULL
- DRAW_NO — VARCHAR2(360) — NOT NULL
- BF_QTY — NUMBER(22) — NOT NULL
- PDM_HANDL_DCD — VARCHAR2(9) — NOT NULL
- CHAF_DCD — VARCHAR2(9) — NOT NULL
- SPEC — VARCHAR2(360) — NOT NULL
- RMK — VARCHAR2(900) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_PDM_BOM_IF_INFO
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- CONSTU_NO — VARCHAR2(144) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(108) — Primary key — NOT NULL
- LOW_MATER_NO — VARCHAR2(108) — Primary key — NOT NULL
- MATER_GCD — VARCHAR2(14) — Primary key — NOT NULL
- ITEM_SEQ_NO — VARCHAR2(24) — Primary key — NOT NULL
- CRN_DT — VARCHAR2(16) — Primary key — NOT NULL
- SEQ_NO — VARCHAR2(24) — Primary key — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- BASE_UNIT — VARCHAR2(4) — NOT NULL
- UPPER_MATER_GCD — VARCHAR2(54) — NOT NULL
- DRAW_NO — VARCHAR2(240) — NOT NULL
- BF_MATER_NO — VARCHAR2(108) — NOT NULL
- BF_QTY — NUMBER(22) — NOT NULL
- PDM_HANDL_DCD — VARCHAR2(6) — NOT NULL
- CHAF_DCD — VARCHAR2(2) — NOT NULL
- CHAF_VER — VARCHAR2(12) — NOT NULL
- BOM_LEVL — VARCHAR2(12) — NOT NULL
- SPEC_XIST_YN — VARCHAR2(6) — NOT NULL
- PART — VARCHAR2(6) — NOT NULL
- PDM_MST_CRE_NM — VARCHAR2(120) — NOT NULL
- PDM_MST_CRE_EIN — VARCHAR2(16) — NOT NULL
- CRN_TM — VARCHAR2(12) — NOT NULL
- HANDL_RSLT — VARCHAR2(6) — NOT NULL
- EXCS_MATER_YN — VARCHAR2(6) — NOT NULL
- EXCS_MATER_HANDL_RSLT — VARCHAR2(6) — NOT NULL
- PDT_CHAF_VER — VARCHAR2(12) — NOT NULL
- PDT_VER — VARCHAR2(8) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_PDM_MATER_MST_IF_INFO
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(108) — Primary key — NOT NULL
- CRN_DT — VARCHAR2(16) — Primary key — NOT NULL
- SEQ_NO — VARCHAR2(24) — Primary key — NOT NULL
- MATER_CONT — VARCHAR2(196) — NOT NULL
- BASE_UNIT — VARCHAR2(4) — NOT NULL
- LGCY_MATER_NO — VARCHAR2(34) — NOT NULL
- SPEC — VARCHAR2(360) — NOT NULL
- SIZE1 — VARCHAR2(360) — NOT NULL
- PDM_PRDFM — VARCHAR2(6) — NOT NULL
- DRAW_NO — VARCHAR2(240) — NOT NULL
- DP_OP_DCD — VARCHAR2(6) — NOT NULL
- MATER_GCD — VARCHAR2(14) — NOT NULL
- UPPER_MATER_GCD — VARCHAR2(54) — NOT NULL
- PDM_MATER_TYPE — VARCHAR2(6) — NOT NULL
- PDM_HANDL_DCD — VARCHAR2(12) — NOT NULL
- CHAF_VER — VARCHAR2(12) — NOT NULL
- PDM_MST_CRE_NM — VARCHAR2(120) — NOT NULL
- PDM_MST_CRE_EIN — VARCHAR2(60) — NOT NULL
- CRN_TM — VARCHAR2(12) — NOT NULL
- HANDL_RSLT — VARCHAR2(6) — NOT NULL
- MATER_TYPE — VARCHAR2(24) — NOT NULL
- MATER_CHAF_YN — VARCHAR2(6) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_PDM_SPEC_IF_INFO
- MANDT — VARCHAR2(18) — Primary key — NOT NULL
- BUKRS — VARCHAR2(10) — Primary key — NOT NULL
- CONSTU_NO — VARCHAR2(144) — Primary key — NOT NULL
- SPEC_DCD — VARCHAR2(6) — Primary key — NOT NULL
- CRN_DT — VARCHAR2(16) — Primary key — NOT NULL
- SEQ_NO — VARCHAR2(24) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(108) — Primary key — NOT NULL
- LOW_MATER_NO — VARCHAR2(108) — Primary key — NOT NULL
- MATER_GCD — VARCHAR2(14) — Primary key — NOT NULL
- ITEM_SEQ_NO — VARCHAR2(24) — Primary key — NOT NULL
- TXT_ORDER — VARCHAR2(24) — Primary key — NOT NULL
- TXT_CONT — VARCHAR2(600) — NOT NULL
- CHAF_VER — VARCHAR2(12) — NOT NULL
- PDT_VER — VARCHAR2(8) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_PEX_CHRG_MNG
- CHRG_NO — VARCHAR2(10) — Primary key — NOT NULL
- CHRG_ITEM — VARCHAR2(15) — Primary key — NOT NULL
- MANDT — VARCHAR2(3) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- MATER_NO — VARCHAR2(40) — NOT NULL
- RATIO_ADJ — NUMBER(22) — NOT NULL
- CHRG_PEX — NUMBER(22) — NOT NULL
- DEL_YN — VARCHAR2(1) — NOT NULL
- CRN_DAYTM — VARCHAR2(14) — NOT NULL
- CRE_ID — VARCHAR2(30) — NOT NULL
- CHAF_DAYTM — VARCHAR2(14) — NOT NULL
- CHGP_ID — VARCHAR2(30) — NOT NULL
- LCOSTS — NUMBER(22) — NOT NULL
- RATIO_APP — NUMBER(22) — NOT NULL
- RATIO_ADJ_MA — NUMBER(22) — NOT NULL
- RATIO_APP_MA — NUMBER(22) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
- WORKH_CD_VAL — VARCHAR2(3) — NOT NULL
- ROPE_CD_VAL — VARCHAR2(3) — NOT NULL
- LIFTC_CD_VAL — VARCHAR2(3) — NOT NULL
- SCAF_CD_VAL — VARCHAR2(3) — NOT NULL
- LIFTC_AMT — NUMBER(22) — NOT NULL
- SCAF_AMT — NUMBER(22) — NOT NULL
AM_PO_LIST_IF_INFO
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- PURCH_DOC_NO — VARCHAR2(90) — Primary key — NOT NULL
- PURCH_DOC_ITEM_NO — VARCHAR2(45) — Primary key — NOT NULL
- WBS_NO — VARCHAR2(216) — NOT NULL
- SIMP_CONT — VARCHAR2(360) — NOT NULL
- PO_TP — VARCHAR2(9) — NOT NULL
- PURCH_GCD — VARCHAR2(27) — NOT NULL
- ACCT_DESG_CG — VARCHAR2(9) — NOT NULL
- PURCH_DOC_ITEM_CG — VARCHAR2(9) — NOT NULL
- PLANT — VARCHAR2(36) — NOT NULL
- WH_RM_DCD — VARCHAR2(270) — NOT NULL
- SAVE_LOC — VARCHAR2(36) — NOT NULL
- SAVE_LOC_CONT — VARCHAR2(93) — NOT NULL
- MATER_NO — VARCHAR2(36) — NOT NULL
- MATER_CONT — VARCHAR2(294) — NOT NULL
- SIZE — VARCHAR2(288) — NOT NULL
- DRAW_NO — VARCHAR2(360) — NOT NULL
- PURCH_ORDER_QTY — NUMBER(22) — NOT NULL
- PURCH_ORDER_UNIT — VARCHAR2(30) — NOT NULL
- ITEM_DELV_DT — VARCHAR2(72) — NOT NULL
- SUPP_BIZC_ACCT_NO — VARCHAR2(30) — NOT NULL
- SUPP_BIZC_NM — VARCHAR2(300) — NOT NULL
- PURCH_INFO_REC_NO — VARCHAR2(90) — NOT NULL
- PURCH_INFO_REC_UNITP — NUMBER(22) — NOT NULL
- CURR_KY — VARCHAR2(45) — NOT NULL
- EXN_MATER_GCD — VARCHAR2(162) — NOT NULL
- CORRE_TFP_DT — VARCHAR2(72) — NOT NULL
- CORRE_TFP_DT_CHAF_DT — VARCHAR2(72) — NOT NULL
- CORRE_TFP_DT_CHAF_TM — VARCHAR2(54) — NOT NULL
- CHACT_VAL — VARCHAR2(270) — NOT NULL
- MATER_CHACT — VARCHAR2(2295) — NOT NULL
- MATER_CHACT_CHAF_DT — VARCHAR2(72) — NOT NULL
- MATER_CHACT_CHAF_TM — VARCHAR2(54) — NOT NULL
- PO_APPV_DT — VARCHAR2(72) — NOT NULL
- PO_APPV_TM — VARCHAR2(54) — NOT NULL
- PO_APPV_CHGR — VARCHAR2(90) — NOT NULL
- PO_DEL_DT — VARCHAR2(72) — NOT NULL
- PO_DEL_TM — VARCHAR2(54) — NOT NULL
- PO_DEL_CHGR — VARCHAR2(90) — NOT NULL
- PO_DEL_CD — VARCHAR2(180) — NOT NULL
- BATCH_NO — VARCHAR2(90) — NOT NULL
- HANDL_STAT — VARCHAR2(9) — NOT NULL
- NEW_BOX_APPLY_YN — VARCHAR2(18) — NOT NULL
- MAIL_TRASM_YN — VARCHAR2(9) — NOT NULL
- BIZC_REG_DELV_SCHE_DT — VARCHAR2(72) — NOT NULL
- DELV_SCHE_DT — VARCHAR2(72) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_PROB_RPT_MNG
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- CHRG_NO — VARCHAR2(30) — Primary key — NOT NULL
- MAKE_DT — VARCHAR2(72) — NOT NULL
- TRB_CAUSE_CATE — VARCHAR2(9) — NOT NULL
- TRB_CAUSE_CD_GCD — VARCHAR2(72) — NOT NULL
- TRB_CAUSE_CD — VARCHAR2(36) — NOT NULL
- TRB_CAUSE — VARCHAR2(141) — NOT NULL
- HANDL_RSLT_CD — VARCHAR2(36) — NOT NULL
- HANDL_RSLT — VARCHAR2(360) — NOT NULL
- TRB_MA_CD — VARCHAR2(36) — NOT NULL
- TRB_MA — VARCHAR2(360) — NOT NULL
- PROB_SMAR — VARCHAR2(3600) — NOT NULL
- APPL_REAS — VARCHAR2(1800) — NOT NULL
- PROB_CONT — VARCHAR2(3600) — NOT NULL
- WORK_CONT — VARCHAR2(1800) — NOT NULL
- ATTHFILE_GCD_ID — VARCHAR2(150) — NOT NULL
- VIDEO_ATTHFILE_ID — VARCHAR2(150) — NOT NULL
- DEL_YN — VARCHAR2(3) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- WORKP_NM — VARCHAR2(180) — NOT NULL
- WORKP_MOB_NO — VARCHAR2(180) — NOT NULL
- TRB_PHMEN_CATE — VARCHAR2(9) — NOT NULL
- TRB_PHMEN_CD_GCD — VARCHAR2(24) — NOT NULL
- TRB_PHMEN_CD — VARCHAR2(36) — NOT NULL
- TRB_PHMEN — VARCHAR2(3600) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_QR_MATER_HIST
- MANDT — VARCHAR2(9) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- CHRG_NO — VARCHAR2(30) — Primary key — NOT NULL
- CHRG_ITEM — VARCHAR2(45) — Primary key — NOT NULL
- INST_CONSN_MATER_SERI_NO — VARCHAR2(180) — Primary key — NOT NULL
- INST_CONSN_MATER_SERI_NO_MB — VARCHAR2(180) — Primary key — NOT NULL
- JOB_GBN — VARCHAR2(3) — NOT NULL
- WBS_NO — VARCHAR2(216) — NOT NULL
- MATER_NO — VARCHAR2(162) — NOT NULL
- MATER_CONT — VARCHAR2(360) — NOT NULL
- MATER_TYPE — VARCHAR2(36) — NOT NULL
- BASE_UNIT — VARCHAR2(30) — NOT NULL
- UNITP — NUMBER(22) — NOT NULL
- RET_MATER_DCD — VARCHAR2(9) — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- CHNG_DT — VARCHAR2(24) — NOT NULL
- CHNG_TM — VARCHAR2(18) — NOT NULL
- DEL_YN — VARCHAR2(3) — NOT NULL
- CRN_DAYTM — VARCHAR2(42) — NOT NULL
- CRE_ID — VARCHAR2(90) — NOT NULL
- CHAF_DAYTM — VARCHAR2(42) — NOT NULL
- CHGP_ID — VARCHAR2(90) — NOT NULL
- ORG_CHRG_NO — VARCHAR2(30) — NOT NULL
- ORG_CHRG_ITEM — VARCHAR2(45) — NOT NULL
- RET_MATER_UDSPS_DCD — VARCHAR2(150) — NOT NULL
- RET_MATER_UDSPS_MEMO — VARCHAR2(900) — NOT NULL
- RET_SCHE_DT — VARCHAR2(72) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_QR_SYS_CONSN_CARR
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- ORG_CHRG_NO — VARCHAR2(60) — Primary key — NOT NULL
- ORG_CHRG_ITEM — VARCHAR2(30) — Primary key — NOT NULL
- TRASM_ID — VARCHAR2(102) — Primary key — NOT NULL
- CHRG_KIND — VARCHAR2(2) — NOT NULL
- MATER_NO — VARCHAR2(24) — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- BASE_UNIT — VARCHAR2(20) — NOT NULL
- SMFT_SERI_NO — VARCHAR2(240) — NOT NULL
- BOARD_SERI_NO — VARCHAR2(240) — NOT NULL
- WBS_NO — VARCHAR2(144) — NOT NULL
- SAVE_LOC — VARCHAR2(24) — NOT NULL
- QR_CD — VARCHAR2(120) — NOT NULL
- CONSN_CARR_NO — VARCHAR2(72) — NOT NULL
- NEW_BOX_NO — VARCHAR2(6) — NOT NULL
- CONSN_KIND_CD — VARCHAR2(6) — NOT NULL
- PACKI_DT — VARCHAR2(48) — NOT NULL
- PACKI_TM — VARCHAR2(36) — NOT NULL
- QR_SYS_IOW_CRN_DT — VARCHAR2(48) — NOT NULL
- QR_SYS_IOW_CRN_TM — VARCHAR2(36) — NOT NULL
- SAP_CRN_DT — VARCHAR2(48) — NOT NULL
- SAP_CRN_TM — VARCHAR2(36) — NOT NULL
- CONSN_CARR_HANDL_DT — VARCHAR2(48) — NOT NULL
- CONSN_CARR_HANDL_TM — VARCHAR2(36) — NOT NULL
- CONSN_CARR_HANDL_YN — VARCHAR2(6) — NOT NULL
- RMK — VARCHAR2(600) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
AM_QUOT_DTL
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- QUOT_NO — VARCHAR2(20) — Primary key — NOT NULL
- QUOT_DGRE — VARCHAR2(12) — Primary key — NOT NULL
- SEQ_NO — VARCHAR2(24) — Primary key — NOT NULL
- CAR_NO — VARCHAR2(144) — NOT NULL
- MATER_NO — VARCHAR2(24) — NOT NULL
- MATER_CONT — VARCHAR2(196) — NOT NULL
- RMK — VARCHAR2(120) — NOT NULL
- QTY — NUMBER(22) — NOT NULL
- BASE_UNIT — VARCHAR2(18) — NOT NULL
- UNITP — NUMBER(22) — NOT NULL
- CRTER_SALE_AMT — NUMBER(22) — NOT NULL
- QUOT_AMT — NUMBER(22) — NOT NULL
- CURR_KY — VARCHAR2(30) — NOT NULL
- ORG_CHRG_NO — VARCHAR2(60) — NOT NULL
- ORG_CHRG_ITEM — VARCHAR2(30) — NOT NULL
- HANDL_RSLT — VARCHAR2(6) — NOT NULL
- HANDL_RSLT_TXT — VARCHAR2(360) — NOT NULL
- HANDL_DT — VARCHAR2(16) — NOT NULL
- HANDL_TM — VARCHAR2(12) — NOT NULL
- PROCR_NO — VARCHAR2(60) — NOT NULL
- RSLT_SO_NO — VARCHAR2(60) — NOT NULL
- RSLT_SO_ITEM_NO — VARCHAR2(36) — NOT NULL
- RSLT_PRJ_NO — VARCHAR2(30) — NOT NULL
- CNTR_TYPE — VARCHAR2(12) — NOT NULL
- PLANT — VARCHAR2(24) — NOT NULL
- LCR — NUMBER(22) — NOT NULL
- ESTMA_TYPE — VARCHAR2(4) — NOT NULL
- CHAF_DCD — VARCHAR2(2) — NOT NULL
- DM_IVT_DCD — VARCHAR2(2) — NOT NULL
- MATER_CHACT — VARCHAR2(1530) — NOT NULL
- CHRG_TYPE — VARCHAR2(20) — NOT NULL
- MATER_PUT_NP — NUMBER(22) — NOT NULL
- MATER_STD_WORKH — NUMBER(22) — NOT NULL
- MATER_QUOT_WORKH — NUMBER(22) — NOT NULL
- MATER_STD_PEX — NUMBER(22) — NOT NULL
- MATER_QUOT_PEX — NUMBER(22) — NOT NULL
- MATER_COSP — NUMBER(22) — NOT NULL
- MATER_RATIO_ADJ — NUMBER(22) — NOT NULL
- CAR_NM — VARCHAR2(180) — NOT NULL
- GNITEM_COSP — NUMBER(22) — NOT NULL
- RPITEM_COSP — NUMBER(22) — NOT NULL
- SALE_UNITP_RAI_RT — NUMBER(22) — NOT NULL
- MATER_TYPE — VARCHAR2(24) — NOT NULL
- CHRG_KIND — VARCHAR2(2) — NOT NULL
- QUOT_UNITP — NUMBER(22) — NOT NULL
- QUOT_PR — NUMBER(22) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- PROCR_ID — VARCHAR2(60) — NOT NULL
- DISCO_AMT — NUMBER(22) — NOT NULL
- DISCO_EC_RT — NUMBER(22) — NOT NULL
- CHRG_NO — VARCHAR2(20) — NOT NULL
- CHRG_ITEM — VARCHAR2(30) — NOT NULL
- ZHG_PSPID — VARCHAR2(72) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL
- … +9
AM_QUOT_EFCM_BDGT_MNG
- MANDT — VARCHAR2(6) — Primary key — NOT NULL
- BUKRS — VARCHAR2(4) — Primary key — NOT NULL
- QUOT_NO — VARCHAR2(20) — Primary key — NOT NULL
- QUOT_DGRE — VARCHAR2(12) — Primary key — NOT NULL
- EFCM_BDGT_DGRE — VARCHAR2(18) — Primary key — NOT NULL
- EFCM_BDGT_DCD — VARCHAR2(6) — NOT NULL
- ENFR — NUMBER(22) — NOT NULL
- TMC — NUMBER(22) — NOT NULL
- PEX — NUMBER(22) — NOT NULL
- OOEX_GEN — NUMBER(22) — NOT NULL
- TPCG — NUMBER(22) — NOT NULL
- INSEX — NUMBER(22) — NOT NULL
- ETC_EXP — NUMBER(22) — NOT NULL
- GEN_LAEX — NUMBER(22) — NOT NULL
- DC_TOT — NUMBER(22) — NOT NULL
- INDC — NUMBER(22) — NOT NULL
- LAEX — NUMBER(22) — NOT NULL
- OOEX_INST_PEX — NUMBER(22) — NOT NULL
- OOEX_SMC — NUMBER(22) — NOT NULL
- OOEX_ISPM — NUMBER(22) — NOT NULL
- OOEX_GR — NUMBER(22) — NOT NULL
- OOEX_INEX — NUMBER(22) — NOT NULL
- OOEX_SMC_2 — NUMBER(22) — NOT NULL
- ACTC_INEX — NUMBER(22) — NOT NULL
- GR — NUMBER(22) — NOT NULL
- LIFTC — NUMBER(22) — NOT NULL
- DIRE_LAEX — NUMBER(22) — NOT NULL
- EPLM_IDAC — NUMBER(22) — NOT NULL
- TCP — NUMBER(22) — NOT NULL
- CRTER_SALE_AMT — NUMBER(22) — NOT NULL
- LAST_DCD — VARCHAR2(6) — NOT NULL
- CURR_KY — VARCHAR2(30) — NOT NULL
- CRN_DAYTM — VARCHAR2(28) — NOT NULL
- CRE_ID — VARCHAR2(60) — NOT NULL
- CHAF_DAYTM — VARCHAR2(28) — NOT NULL
- CHGP_ID — VARCHAR2(60) — NOT NULL
- ETC_CONT — VARCHAR2(600) — NOT NULL
- ETL_DAYTM — VARCHAR2(14)
- YYYYMMDDHH24MISS) — NOT — NOT NULL