数据源2lis_03_BF

来源:互联网 发布:淘宝定时上架 编辑:程序博客网 时间:2024/05/16 09:56

关于BW标准数据源 2lis_03_BF  几乎是所有BW项目都会用到这个物料凭证数据源,它主要来源于MKPF物料凭证抬头和MSEG物料凭证行项目两个透明表。它广泛用于进行出库、入库统计,库存统计,库龄分析。  当建立该数据源与信息源、DSOmapping时,仅以公司代码、凭证年度、物料移动凭证号和物料移动凭证行项目作为主键是容易出问题的,而应该添加行项目计数器共同作为主键。    

字段   中文描述    英文描述

LFDAT_V交货日期 Delivery Date

WERKS_D工厂Plant

MB_INSMK库存类型Stock Type

CO_PRZNR业务处理Business Process

LLIEF商品供应商Supplying Vendor

LSTAR活动类型Activity Type

EVERE依照装运通知Compliance with Shipping Instructions

EVERS装运须知Shipping Instructions

MB_GRBEW移动原因Reason for Movement

PLPLA差异的分配Distribution of Differences

SHKZG借方/贷方标识Debit/Credit Indicator

WAERS货币码Currency Key

MBLNR物料凭证编号Number of Material Document

MJAHR物料凭证年度Material Document Year

MBLPO物料凭证中的项目Item in Material Document

CPUDT会计凭证输入日期Day On Which Accounting Document Was Entered

CPUTM输入时间Time of Entry

ROCANCEL标识符:取消数据记录ndicator: Cancel Data Record

BLART凭证类型Document Type

USNAM用户名User Name

CHAR4没有更多的定义范围,可以使用插入级Not More Closely Defined Area, Possibly Used for Patchlevels

WAKTION促销Promotion

AUFNR订单号Order Number

CO_AUFPL订单中工序的工艺路线号Routing number of operations in the order

BKLAS评估类Valuation Class

BLDAT凭证中的凭证日期Document Date in Document

MC_BNBTR用本币计算的交货成本Delivery costs in local currency

BSTAUS后勤信息系统中的库存值Stock Values in the Logistics Information System

BSTTYP后勤信息系统中的库存种类Stock categories in the Logistics Information System

BUDAT凭证中的过帐日期Posting Date in the Document

BUKRS公司代码Company Code

RSAPPLNM应用程序组件Application Component

BWART移动类型(库存管理)Movement Type (Inventory Management)

MCBW_BRELBW: 相关库存BW: Stock Relevance

MCBW_COUNTERBW: 行项目的唯一标识BW: Unique Identification of Line Item

MCBW_GEOBW: 按本币的成本值BW: Cost Value in Local Currency

MCBW_GVOBW: 按本币的零售值BW: Retail Value in Local Currency

MCBW_GVPBW: 按本币的含税零售值BW: Retail Value with Tax in Local Currency

BWKEY评估范围Valuation Area

MCBW_MNGBW: 按基本计量单位的数量BW: Quantity in Base Unit of Measure

PS_PSPEX工作细目结构元素 (外部) Work Breakdown Structure Element (External)

BWTAR_D评估类型Valuation Type

MCW_BWVORGSAP BW 事务代码SAP BW transaction key

CHARG_D批号Batch Number

MC_DMBTR按本位币计的金额Amount in local currency

EBELN采购凭证号Purchasing Document Number

EBELP采购凭证的项目编号Item Number of Purchasing Document

ERFME条目单位Unit of Entry

ERFMG以输入单位计的数量Quantity in Unit of Entry

MB_GRUND货物移动原因Reason for goods movment

GSBER业务范围Business Area

KDAUF销售订单数Sales Order Number

KDEIN销售订单的交货计划Delivery Schedule for Sales Order

KDPOS销售订单中的项目编号Item Number in Sales Order

KOKRS控制范围Controlling Area

KOSTL成本中心Cost Center

KSTRG成本对象Cost Object

EKUNN客户的帐户号Account Number of Customer

KZBEW移动标识Movement Indicator

KZBWS特定库存的评估Valuation of Special Stock

LGNUM仓库号/混合仓库Warehouse Number / Warehouse Complex

LGORT_D库存地点Storage Location

LGPLA仓位Storage Bin

LGTYP仓储类型Storage Type

ELIFN供应商帐户号Vendor Account Number

MATNR物料号Material Number

MBLNR物料凭证编号Number of Material Document

MEINS基本计量单位Base Unit of Measure

MC_MENG数量Quantity

MJAHR物料凭证年度Material Document Year

NPLNR科目分配的网络号Network Number for Account Assignment

PALAN   WMS 货盘数WMS Number of pallets

RKEOBJNR获利能力段编号(CO-PA) Profitability Segment Number (CO-PA)

PRCTR利润中心Profit Center

PS_PSP_PNR工作分解结构元素 (WBS元素) Work Breakdown Structure Element (WBS Element)

SAKNR总帐科目编号G/L Account Number

SHKZG借方/贷方标识Debit/Credit Indicator

SOBKZ特殊库存标识Special Stock Indicator

UMWRK收货/发货工厂Receiving/Issuing Plant

HWAER本币Local Currency

WEMPF收货方/运达方Goods Recipient/Ship-To Party

WERKS_D工厂Plant

MBLPO物料凭证中的项目Item in Material Document

PERIV会计年度变式Fiscal Year Variant

MC_NOPOS项目计数器Counter for Items

WRF_BW_ITEM_CATEGORYEA 零售 BW 提取增强:项目类型EA Retail BW Extr. Enhancement: Item Type

WRF_BW_RECORD_TYPEEA 零售 BW 提取增强:数据记录类型EA Retail BW Extr. Enhancement: Data Record Type

ATTYP物料类别Material Category

VLFKZ工厂种类Plant category

MB_XAUTO项目自动创建Item automatically created

STRNR结构化的物料Structured material

VKWRT含增值税的销售价格价值Value at Sales Prices Including Value-Added Tax

VKWRA排除增值税的销售价格值Value at sales prices excluding value-added tax

UMLKZ标识:移动类型是转储Indicator: Movement type is stock transfer

RETKZ标识:从调用中返回Indicator: Return from call

INVKZ标识:移动类型是盘点库存Indicator: Movement type is physical inventory

KORR标识:移动类型是库存更正Indicator: Movement type is inventory correction

UMMATKZ将过帐物料传输到物料Transfer Posting Material to Material

WAERS货币码Currency Key

 

 

 

原创粉丝点击