SAP MM PO Item Category 内部code的用处?

SAP MM PO Item Category
本文探讨了SAP MM PO Item Category中内部代码的作用。内部代码用于分类,并在启用审批策略且依赖ITEMCATEGORY时,在特征值中使用其内部表示。

SAP MM PO Item Category 内部code的用处?


CpRJifAAAAAElFTkSuQmCC


这个内部号码在Classification里会使用到。如果你想启用审批策略,并且依赖ITEM CATEGORY,你就必须在特征值里使用ITEM CATEGORY的内部表示值了。

 

CREATE TABLE "XMC_PO_DETL" ( "POITEM_ID" NUMBER(*,0) PRIMARY KEY USING INDEX ( CREATE INDEX "IDX_POITEM_PK" ON "XMC_PO_DETL"("POITEM_ID") ), "PO_ID" NUMBER(*,0) NOT NULL, "PO_NO" VARCHAR2(10) NOT NULL, "PO_ITEM" VARCHAR2(10) NOT NULL, "PLANT" VARCHAR2(30), "MAT_GRP" VARCHAR2(20), "MC_NO" VARCHAR2(18), "MC_DESC" VARCHAR2(40), "ITEM_QTY" NUMBER(16,3) CHECK ("ITEM_QTY" > 0), "UNIT" VARCHAR2(4), "UNIT_PRICE" NUMBER(23,4) CHECK ("UNIT_PRICE" >= 0), "TOTAL_AMOUT" NUMBER(23,4) CHECK ("TOTAL_AMOUT" >= 0), "INFO_REC" VARCHAR2(20), "VEND_MAT" VARCHAR2(35), "TAX_CODE" VARCHAR2(2) NOT NULL, "DELIV_COMPL_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("DELIV_COMPL_FLAG" IN ('YES','NO')), "DELIV_DATE" DATE, "ITEM_CAT" VARCHAR2(1), "PR_NO" VARCHAR2(10), "PR_ITEM" VARCHAR2(10), "ACCT_ASSCAT" VARCHAR2(1), "GR_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("GR_FLAG" IN ('YES','NO')), "GR_BY" VARCHAR2(10), "DEL_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("DEL_FLAG" IN ('YES','NO')), "PO_REF_NO" VARCHAR2(10), "REMAIN_BALANCE_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("REMAIN_BALANCE_FLAG" IN ('YES','NO')), "SAP_UDATE" DATE, "FORECAST_DELIV_DATE" DATE, "RECEIVE_QTY" NUMBER(16,3) DEFAULT 0 CHECK ("RECEIVE_QTY" >= 0), "RECEIVE_PERCENT" NUMBER(10,4) DEFAULT 0 CHECK ("RECEIVE_PERCENT" BETWEEN 0 AND 100), "EQ_SEQ_ID" VARCHAR2(10), "MANUFACTURER" VARCHAR2(60), "EQ_MAKER_PART_NO" VARCHAR2(30), "GL_ACCT" VARCHAR2(10), "TAX_FREE_ENG" VARCHAR2(92), "TAX_FREE_CHI" VARCHAR2(92), "DRAW_DOC" VARCHAR2(22), "DOC_VEND_MAT" VARCHAR2(60), "ORIGINAL_MC_NO" VARCHAR2(20), "PRICE_UNIT" NUMBER(*,0), "REQUISITIONER" VARCHAR2(20), "FINAL_INVOICE_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("FINAL_INVOICE_FLAG" IN ('YES','NO')), "FREE_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("FREE_FLAG" IN ('YES','NO')), "IR_QTY" NUMBER(16,3) CHECK ("IR_QTY" >= 0), "IR_AMOUNT" NUMBER(16,3) CHECK ("IR_AMOUNT" >= 0), "INVOICE_PLAN_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("INVOICE_PLAN_FLAG" IN ('YES','NO')), "GR_NOVALUE_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("GR_NOVALUE_FLAG" IN ('YES','NO')), "UNLOAD_POINT" VARCHAR2(20), "ASSET_NO" VARCHAR2(50), "ASSET_SUBNO" VARCHAR2(20), "COST_CENTER" VARCHAR2(20), "COAREA" VARCHAR2(30), "COMMIT_ITEM" VARCHAR2(20), "FUND_YEAR" VARCHAR2(10), "FUND_CENTER" VARCHAR2(20), "CDATE" DATE DEFAULT SYSDATE, "UDATE" DATE DEFAULT SYSDATE, "SHIP_QTY" NUMBER(16,3) DEFAULT 0 CHECK ("SHIP_QTY" >= 0), "SHIP_AMOUNT" NUMBER(23,4) DEFAULT 0 CHECK ("SHIP_AMOUNT" >= 0), "AUTO_ACTION" VARCHAR2(10), "REM_SHELF_LIFE" NUMBER(16,4) CHECK ("REM_SHELF_LIFE" >= 0), "RFQ_NO" VARCHAR2(10), "RFQ_ITEM" VARCHAR2(6), "INFOUPDATE_FLAG" VARCHAR2(3), "FACILITY_PO_STATUS" VARCHAR2(20), "TMP_DEL" VARCHAR2(3), "PRICE_PRIORITY" VARCHAR2(255), "BUDGET_CODE" VARCHAR2(20), "COST_CATEGORY" VARCHAR2(30), "ECCN" VARCHAR2(80), "COSTDOWN_BASE" NUMBER(23,4), CONSTRAINT "FK_PO_MAST" FOREIGN KEY ("PO_ID") REFERENCES "SP_PO_MAST"("PO_ID"), CONSTRAINT "FK_TAX" FOREIGN KEY ("TAX_CODE") REFERENCES "SP_TAX"("TAX_CODE") ); -- 创建常用查询索引 CREATE INDEX "IDX_PO_NO_ITEM" ON "XMC_PO_DETL"("PO_NO", "PO_ITEM"); CREATE INDEX "IDX_PR_NO" ON "XMC_PO_DETL"("PR_NO", "PR_ITEM"); CREATE INDEX "IDX_TAX_CODE" ON "XMC_PO_DETL"("TAX_CODE"); 只要单纯的字段 视图校验全部去掉
08-23
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值