SAP Scan PP ZLWLGJB Table Definition and Java Bean
SAP Scan PP ZLWLGJB Table Definition
This document provides a detailed definition of the 'sap_scan_pp_zlwlgjb' table in SAP, along with a generated Java bean class for easy data mapping and manipulation.
Table Definition:
CREATE TABLE `sap_scan_pp_zlwlgjb` (
`ID` int NOT NULL COMMENT 'ID',
`MANDT` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '集团',
`ZDATAID` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'SAPID',
`ZBATNUM` int DEFAULT NULL COMMENT '输出批次号',
`AUFNR` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'MO单号',
`POSNR` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项次',
`WERKS` char(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '工厂',
`MATNR` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '物料编号',
`MATXT` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '物料描述',
`ZZGROES` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '规格',
`MEINS` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '基本计量单位',
`ZSTDMNG` int DEFAULT NULL COMMENT '单位标准用量',
`BDMNG` int DEFAULT NULL COMMENT '组件数量',
`ZSMNG` int DEFAULT NULL COMMENT '损耗量',
`ZSTKMNG` int DEFAULT NULL COMMENT '库存量',
`ZPLNMNG` int DEFAULT NULL COMMENT '应发数量',
`ENMNG` int DEFAULT NULL COMMENT '提货数',
`ZNIMNG` int DEFAULT NULL COMMENT '需求量',
`ZNGMNG` int DEFAULT NULL COMMENT '总在途量',
`ZPOMNG` int DEFAULT NULL COMMENT '采购订单数量',
`ZPRMNG` int DEFAULT NULL COMMENT '采购申请数量',
`ZBANFN` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '采购申请单号',
`BADAT` datetime DEFAULT NULL COMMENT '申请日期',
`ZPREED` datetime DEFAULT NULL COMMENT '采购订单日期',
`ZEBELN` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '采购凭证编号',
`BEDAT` datetime DEFAULT NULL COMMENT '采购订单日期',
`ZPOEED` datetime DEFAULT NULL COMMENT '采购承诺交期',
`ZGRMNG` int DEFAULT NULL COMMENT '收货数量',
`ZGRDAT` datetime DEFAULT NULL COMMENT '入库日期',
`ZGRLNR` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '入库单号',
`ZGQMNG` int DEFAULT NULL COMMENT '收货数量',
`ZGSMNG` int DEFAULT NULL COMMENT '收货数量',
`ZGQLNR` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '检验单号',
`ZGGMNG` int DEFAULT NULL COMMENT '收货数量',
`ZGGDAT` datetime DEFAULT NULL COMMENT '进货日期',
`ZGGLNR` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '进货单号',
`ZGIDAT` datetime DEFAULT NULL COMMENT '领料日期时间',
`ZGILNR` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '领料单号',
`ZRTLNR` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '验收退回单号',
`ZRTMNG` decimal(9,0) DEFAULT NULL COMMENT '收货数量',
`ZRTDAT` datetime DEFAULT NULL COMMENT '退货日期',
`MCOD1` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '采购对象',
`ZZBRANT` varchar(140) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '品牌',
`POTX1` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'BOM备注',
`MATKL` varchar(9) DEFAULT NULL COMMENT '物料组',
`WGBEZ` varchar(40) DEFAULT NULL COMMENT '类别说明',
`ZCLOSE` char(1) DEFAULT NULL COMMENT '复选框',
`LGORT` char(4) DEFAULT NULL COMMENT '库存地点',
`LIFNR` varchar(10) DEFAULT NULL COMMENT '供应商编码',
`KUNNR` varchar(10) DEFAULT NULL COMMENT '售达方',
`RSNUM` varchar(10) DEFAULT NULL COMMENT '相关需求的编号',
`RSPOS` varchar(4) DEFAULT NULL COMMENT '相关需求的项目编号',
`ZZPROJE` varchar(20) DEFAULT NULL COMMENT '项目编号',
`ZZMCLAS` varchar(2) DEFAULT NULL COMMENT '项目节点',
`LFSPJ` varchar(2) DEFAULT NULL COMMENT '客户项目阶段',
`ZZPRTMG` decimal(9,0) DEFAULT NULL COMMENT '件数',
`ZZPRTME` varchar(3) DEFAULT NULL COMMENT '单位',
`PSMNG` decimal(9,0) DEFAULT NULL COMMENT '订单项目计划总数量',
`AUSCH` decimal(9,0) DEFAULT NULL COMMENT '组件报废百分比',
`ZZREF_DOC` varchar(36) DEFAULT NULL COMMENT '参考号码',
`KDAUF` varchar(10) DEFAULT NULL COMMENT '销售订单数',
`ZGICARD` varchar(20) DEFAULT NULL COMMENT '领料人工号',
`ZGICNAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '领料人姓名',
`ZGITIME` varchar(20) DEFAULT NULL COMMENT '领料时间',
`BISMT` varchar(20) DEFAULT NULL COMMENT '旧物料号',
`ZZSTLOC` varchar(40) DEFAULT NULL COMMENT '储位',
`LENGTH` decimal(9,0) DEFAULT NULL COMMENT '长度',
`WIDTH` decimal(9,0) DEFAULT NULL COMMENT '宽度',
`HEIGHT` decimal(9,0) DEFAULT NULL COMMENT '高度',
`DIAME` decimal(9,0) DEFAULT NULL COMMENT '直径',
`IDIAME` decimal(9,0) DEFAULT NULL COMMENT '内径',
`EDIAME` decimal(9,0) DEFAULT NULL COMMENT '外径',
`DENSI` decimal(9,0) DEFAULT NULL COMMENT '密度',
`LUNIT` varchar(10) DEFAULT NULL COMMENT '计量单位',
`DUNIT` varchar(10) DEFAULT NULL COMMENT '密度单位',
`ZDSTKMNG` decimal(9,0) DEFAULT NULL COMMENT '需求仓库存量',
`BNAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '定货人名字',
`LBOMGR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'BOM工程师',
`VMIMENGE` decimal(9,0) DEFAULT NULL COMMENT 'VMI安全库存数'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
Java Bean Class:
public class SapScanPpZlwlgjb {
private int ID;
private String MANDT;
private String ZDATAID;
private Integer ZBATNUM;
private String AUFNR;
private String POSNR;
private String WERKS;
private String MATNR;
private String MATXT;
private String ZZGROES;
private String MEINS;
private Integer ZSTDMNG;
private Integer BDMNG;
private Integer ZSMNG;
private Integer ZSTKMNG;
private Integer ZPLNMNG;
private Integer ENMNG;
private Integer ZNIMNG;
private Integer ZNGMNG;
private Integer ZPOMNG;
private Integer ZPRMNG;
private String ZBANFN;
private Date BADAT;
private Date ZPREED;
private String ZEBELN;
private Date BEDAT;
private Date ZPOEED;
private Integer ZGRMNG;
private Date ZGRDAT;
private String ZGRLNR;
private Integer ZGQMNG;
private Integer ZGSMNG;
private String ZGQLNR;
private Integer ZGGMNG;
private Date ZGGDAT;
private String ZGGLNR;
private Date ZGIDAT;
private String ZGILNR;
private String ZRTLNR;
private Long ZRTMNG;
private Date ZRTDAT;
private String MCOD1;
private String ZZBRANT;
private String POTX1;
private String MATKL;
private String WGBEZ;
private String ZCLOSE;
private String LGORT;
private String LIFNR;
private String KUNNR;
private String RSNUM;
private String RSPOS;
private String ZZPROJE;
private String ZZMCLAS;
private String LFSPJ;
private Long ZZPRTMG;
private String ZZPRTME;
private Long PSMNG;
private Long AUSCH;
private String ZZREF_DOC;
private String KDAUF;
private String ZGICARD;
private String ZGICNAME;
private String ZGITIME;
private String BISMT;
private String ZZSTLOC;
private Long LENGTH;
private Long WIDTH;
private Long HEIGHT;
private Long DIAME;
private Long IDIAME;
private Long EDIAME;
private Long DENSI;
private String LUNIT;
private String DUNIT;
private Long ZDSTKMNG;
private String BNAME;
private String LBOMGR;
private Long VMIMENGE;
// getters and setters
}
Explanation:
- The table 'sap_scan_pp_zlwlgjb' is likely related to material requirements planning (MRP) and material management within SAP.
- The table contains fields for various aspects of material planning and management, including:
- Material information (MATNR, MATXT, ZZGROES, MEINS, etc.)
- Procurement data (ZBANFN, ZEBELN, ZPOEED, etc.)
- Stock information (ZSTKMNG, ZPLNMNG, ZNGMNG, etc.)
- Production orders (AUFNR, POSNR, ZSTDMNG, etc.)
- Vendor and customer information (LIFNR, KUNNR, etc.)
- The generated Java bean class maps the table columns to class attributes, allowing for easier access and manipulation of the data from within Java applications.
This information can be used to better understand the data structure of 'sap_scan_pp_zlwlgjb' and to develop applications that interact with this table.
原文地址: https://www.cveoy.top/t/topic/mVQT 著作权归作者所有。请勿转载和采集!