SAP各模块常用TABLE
- 格式:xls
- 大小:249.50 KB
- 文档页数:2
SAP MM模块常⽤表Nick制作表名描述涉及范围表名描述物料主数据MARA物料常规数据采购申请EBAN采购申请MARC物料⼯⼚数据EBKN采购申请账户设置MARD物料仓库位置采购订单EKBE采购凭证历史MARM物料计量单位EKBEH删除的采购订单历史记录MARV物料控制记录EKBZ每个采购凭证的历史(交货费⽤)MBEW评估EKBZH每个采购凭证的历史(交货费⽤)MAKT说明EKKI采购条件索引MAST BOM连接物料EKKN采购凭证中的账户设置MVKE销售数据EKKO采购凭证抬头MAPR预测的物料索引EKPA采购中的合伙⼈规则MSTA主数据状态EKPB采购凭证中的“已供物料”项供应商主数据LFA1供应商主数据(主数据⼀般数据)EKPO采购凭证项⽬LFAS供应商主数据(增值税号⼀般部分)EKPV采购凭证项⽬的库存转储装运数据LFAT供应商主数据(税务分组)EKRS ERS过程:将被开票的货物(商品)移动LFB1供应商主数据(公司代码)MIGO收货MKPF物料凭证抬头LFB5供应商主数据(催款数据)MSEG物料凭证⾏项⽬LFBK供应商主数据(银⾏明细)MIRO验票RBKP发票收据表头LSBW供应商主数据(预扣税类型RSEG收款发票⾏项⽬LFC1供应商主数据(业务额)装运EQUK配额⽂件抬头LFC3供应商主数据(特殊总分类账交易图表)EQUP配额⽂件⾏项⽬LFCPR每⼀步骤的功能代码参数T027A采购装运须知LFM1供应商主数据购买组织数量T027B装运须知⽂本LFM2供应商主记录:采购数据T027C与装运须知相符的码信息记录EINA采购信息记录-⼀般数据T027D与装运须知相符的码EINE采购信息记录-采购组织数据盘点IKPF盘点凭证抬头EIPA订购价格历史:信息记录ISEG盘点凭证⾏项⽬货源清单EORD采购货源清单批次MCHA批次EKUB有关物料的库存运输单的索引MCHB批量库存ESKN服务包中的账户分配EKHB批准凭证MBPR⽣产仓库的库位EKAN供应商地址:采购凭证MLAN物料的税分类计划协议EKEH计划协议批准凭证MLGN每⼀仓库号物料数据EKES计划协议批准的标题数据LMGT每⼀存储类型的物料数据EKET计划协议计划⾏MVER物料消耗量EKETH计划协议计划:历史表MVKE物料销售数据转储LTBK转储请求抬头T001L仓储地点LTBP转储请求项⽬T00W⼯⼚/分⽀机构LTAK WM转储单抬头VRIV号码氛围LTAP转储单项⽬RKPF凭证抬头:预定库存MARD主库存RESB预定/相关需求MARDH主库存历史记录T024采购组MSLB特殊库存OT024E采购组织MKOL批次库存K/MT024W⼯⼚的有效采购组织MSKA批次库存E涉及范围T024Z采购组织MSKU批次库存V/M T023物料组MCHA批次库存T156移动类型MCHB批次库存T157H移动类型的帮助⽂本物料主数据MARA基本数据KONP条件(项⽬)MAKT⽂本T16FC批准代码MARC⼯⼚视图客户主数据KNA1基本数据MVKB销售视图KNVV销售视图MARM物料的计量单位KNB1公司代码⾃动确定的科⽬CXXX XXX表示三个数字KNVP合作伙伴交货LIKP交货单抬头信⽤主数据KNKK信贷限额、应收总额、特别往来LIPS交货单⾏项⽬S066未清订单VTTK装运抬头S067未交货值物料凭证MKPF物料凭证抬头KNKK应收值(要与BSID表⽐较)MSEG物料凭证⾏项⽬价格数据AXXX主数据表XXX表示三位数VF01销售发票VBRK销售发票抬头KNOH抬头VBRP销售发票⾏项⽬KNOP⾏项⽬业务地址服务ADRC地址KNOV单据的价格STXH抬头销售订单VTTP装运⾏项⽬STXL⾏项⽬VBKA抬头VBAP⾏项⽬VBKD业务数据VBPA合作伙伴VBEP计划⾏数据VBFA单据流VBUK抬头状态VBUP⾏项⽬状态表名描述涉及范围表名描述涉及范围。
经常用到的几个表2008-10-27 22:311,Master data table:CEPC->PROFIT CENTER MASTER DATA TABLE. CSKS->COST CENTER DATA TABLEKNA1->CUSTOMER MASTER.LFA1->VENDOR MASTER DATA TABLEMARA->MATERIAL MASTER DATASKB1->G/L ACCOUNT MASTER DATAT001W->PLANTS/BRANCHST001->COMPANY CODE DATA TALBE2,与生产相关的几个表:Demand ManagementPBED->Independent Requirements DataPBIM->Independent Requirements by Material Repetitive ManufacturingSAFK->RS Header Master DataS025->LIS -- Run Schedule QuantitiesS026->LIS -- Material UsageS028->LIS -- Reporting Point StatisticsCEZP->Reporting Point Document LogsCPZP->Reporting Points - Periodic TotalsMRP RecordsMDKP->MRP Document Header DataPLSC->Planning Scenario (Long-term Planning)MDFD->MRP Firming DatesMDVM->Planning File EntriesS094->LIS Stock/Requirements AnalysisReservationsRESB->Reservations/Dependent Requirements Planned OrdersPLAF->Planned OrdersDiscrete ProductionAFKO->Order HeaderAFPO->Order Item DetailAFVC->Order Operations DetailAFFL->Order Sequence DetailsAFFH->Order PRT AssignmentAFBP->Order Batch Print RequestsAFRU->Order Completion ConfirmationsAFFW->Confirmations -- Goods Movements with Errors AFRC->Confirmations -- Incorrect Cost CalculationsAFRD->Confirmations -- Defaults for Collective ConfirmationAFRH->Confirmations -- Header Info for Confirmation PoolAFRV->Confirmation PoolAFWI->Confirmations -- Subsequently Posted Goods Movements3,销售相关的几个表:KUAGV->售达方客户主记录总览.VBDKA->询价,报价订单的凭证打印标题.VBDPA->询价报价床单的项目明细.BEST->末来库存TVK0->销售组织(组织数据)VBAP/VBAK->销售订单主从数据表KOMVD->打印的价格确定通讯条件记录4,采购相关的几个表.EKKO/EKPO->采购订单主从数据表T024E->采购组织(组织数据)SADR->地址管理,公司数据T166U->采购凭证打印输出的标题EKET->计划协议计划行EKKN->采购凭证中的帐户设置.T166K->采购凭证打印输出中的标题文本,IMG下的DEFINE TEXT FOR PO关联MSEG->凭证段物料RM06P->采购凭证打印输出的辅助字段5;总分类帐几个相关表.SKA1->科目表SKB1->公司代码SKAT->科目表说明SKAS->会计科目代码清单6,物料分类相关几个表.KLAH->Class DetailCABN->Characteristic DetailAUSP->Characteristic ValuesCAWN->Characteristic ValuesCAWNT->Characteristic Value TextsKSML->Characteristic Allocation to ClassKSSK->Material Allocation to Class7,几个用到的系统表.DD03L->TABLE FIELDS OF ALL SAPTBTCO->查看JOB STATUS/OVERVIEW TABLE.T247->月份对照表.DDO2L->ALL SAP TABLESTNAPR->所有相关的OUTPUT报表信息程序,子程序,报表TSTC->SAP ALL TRANSCATION CODEUSR02->保存PASSWORD的表TRDIR->ABAP程序列表。
Table Table Class Applicati on Class Data Class DescriptionNotesEBAN TRANSP ME Transaction Purchase RequisitionEBKN TRANSP ME Transaction Purchase Requisition Account AssignmentEBUB TRANSP ME Transaction Index for Stock Transport Requisitions for Material EINA TRANSP ME Transaction Purchasing Info Record - General DataEINE TRANSP ME Transaction Purchasing Info Record - Purchasing Organization DataEIPA TRANSP ME Transaction Order Price History, Info RecordEKAB TRANSP ME Transaction Release DocumentationEKAN TRANSP ME Transaction Vendor Address: Purchasing Document EKBE TRANSP ME Transaction History of Purchasing DocumentEKBZ TRANSP ME Transaction History of Purchasing Document - Delivery Costs EKET TRANSP ME Transaction Delivery SchedulesEKKN TRANSP ME Transaction Account Assignment in Purchasing Document EKKO TRANSP ME Transaction Purchasing Document HeaderEKPB TRANSP ME Transaction Material Provided Item in Purchasing Document EKPO TRANSP ME Transaction Purchasing Document ItemEKUB TRANSP ME Transaction Index for Stock Transport Orders for Material ESKN TRANSP ME Transaction Account Assignment in Service PackageLFM1TRANSP ME Transaction Vendor master record purchasing organization data MAKT TRANSPMGMaster Material Descriptions MAPR TRANSP MG Master Material Index for ForecastPointer for forecast dataMARA TRANSP MG Master Material Master: General Data MARC TRANSP MG Master Material Master: C SegmentMARD TRANSP MG Master Material Master: Storage Location/Batch Segment MARM TRANSP MG Master Units of MeasureMARV TRANSP MG Master Material Control Record MBEW TRANSP MG Master Material ValuationMBPR TRANSP MG Master Stock at Production Storage Bin MCHA TRANSP MG Master BatchesMCHB TRANSPMGMaster Batch StocksMLAN TRANSP MG Master Tax Classification: MaterialSales Data (for each country)MLGNTRANSP MGMasterMaterial Data per Warehouse NumberWarehouse management inventory data MLGT TRANSP MG Master Material Data per Storage Type Warehouse managementinventory type data MSTA TRANSP MG Master Material Master Status MVER TRANSP MG Master Material consumption MVKETRANSP MGMasterMaterial Master: Sales DataSales Data (for each Sales Org and Distribution Channel)T001L TRANSP MGOrganizationalStorage LocationsT001W TRANSP MG OrganizationalPlants/BranchesMKPFTRANSP MBTransaction Header: Material DocumentSAP常用表MSEG TRANSP MB Transaction Document Segment: MaterialIKPF TRANSP MB Transaction Header: Physical Inventory DocumentISEG TRANSP MB Transaction Physical Inventory Document ItemsAFFL TRANSP CO Transaction Work order sequenceAFFT TRANSP CP Transaction Order process instructionsAFFV TRANSP CP Transaction Order process instruction valuesAFKO TRANSP CO Transaction Order header data PP ordersAFPO TRANSP CO Transaction Order itemAFRU TRANSP CO Transaction Order completion confirmationsCKHS TRANSP CK Transaction Header - Unit costing (control + totals)CKHT TRANSP CK Transaction Texts for CKHSCKIP TRANSP CK Transaction Unit Costing: Period Costs Line ItemCKIS TRANSP CK Transaction Unit Costing: Items / Product Costing: Itemization CKIT TRANSP CK Transaction Texts for CKISCOER TRANSP CN Transaction Sales Order Value RevenueCRCA TRANSP CP Master Work Center Capacity AllocationCRCO TRANSP CP Master Assignment of Work Center to Cost CenterCRHD TRANSP CP Master Work Center HeaderCRTX TRANSP CP Master Text for the Work Center or Production Resource/Tool DOST TRANSP CS Master Document to BOM LinkEQST TRANSP CS Master Equipment to BOM LinkKAKO TRANSP CP Master Capacity Header SegmentKAKT TRANSP CP Master Capacity DescriptionKBED TRANSP CY Transaction Capacity requirements recordsKEKO TRANSP CK Transaction Product Costing - HeaderKEPH TRANSP CK Transaction Product Costing: Cost Components for Cost of Goods Manuf.MAST TRANSP CS Master Material to BOM LinkSTAS TRANSP CS Master BOMs - Item SelectionSTKO TRANSP CS Master BOM HeaderSTPO TRANSP CS Master BOM ItemSTPU TRANSP CS Master BOM Sub-ItemSTZU TRANSP CS Master Permanent BOM dataKDST TRANSP Master Sales Order to BOM Link STST TRANSP Master Standard BOM linkTPST TRANSP Master Functional Location - BOM LinkAxxx Condition key TablesKNMT TRANSP VA Master Customer-Material Info Record Data Table KNMTK TRANSP VA Master Customer-Material Info Record Header Table KNVA TRANSP VV Master Customer Master Loading PointsKNVD TRANSP VD Master Customer master record sales request form KNVI TRANSP VF Master Customer Master Tax IndicatorKNVK TRANSP VP Master Customer Master Contact PartnerKNVL TRANSP VF Master Customer Master LicensesKNVP TRANSP VP Master Customer Master Partner FunctionsKNVS TRANSP VV Master Customer Master Shipping DataKNVT TRANSP VT Master Customer Master Record Texts for Sales KNVV TRANSP V Master Customer Master Sales DataKONA TRANSP VF Master Rebate AgreementsKOND TRANSP VF Master Conditions (Data)KONH TRANSP VF Master Conditions (Header)KONM TRANSP VF Master Conditions (1 Dimensional Quantity Scales) KONP TRANSP VF Master Conditions (Item)KONV CLUSTERVF Master Conditions (Procedure Data)KONW TRANSP VF Master Conditions (1 Dimensional Value Scales) LIKP TRANSP VL Transaction SD Document: Delivery Header Data field LIKP-WADAT_IST -Actual Goods Issue Date - is populated only after Post Goods IssueLIPS TRANSP VL Transaction SD document: Delivery: Item dataNACH TRANSP VN Transaction Detailed output dataNAST TRANSP VN Transaction Message statusVAKGU TRANSP VIND Sales Index: Quotation Validity index table VAKPA TRANSP VIND Sales Index: Orders by Partner Function index table VAPMA TRANSP VIND Sales Index: Order Items by Material index tableVBAG TRANSP VA Transaction Sales Document: Release Data by Schedule Line in Sch.Agrmt.VBAK TRANSP VA Transaction Sales Document: Header DataVBAP TRANSP VA Transaction Sales Document: Item DataVBBE TRANSP V Transaction Sales Requirements: Individual Records VBBS TRANSP V Transaction Sales Requirement Totals Record VBEP TRANSP VA Transaction Sales Document: Schedule Line DataVBFA CLUSTERVA Transaction Sales Document FlowVBFS TRANSP V Transaction Error Log for Collective ProcessingVBKA TRANSP VCK Transaction Sales activitiesVBKD TRANSP VA Transaction Sales Document: Business DataVBKOF TRANSP VIND SD index: Open sales activities by partner function index table VBKPA TRANSP VIND SD index: Sales activities by partner function index table VBLK TRANSP VL Transaction SD Document: Delivery Note HeaderVBLS TRANSP VL Transaction Delivery Notes for Collective ProcessingVBPA TRANSP VP Transaction Sales Document: PartnerVBRK TRANSP VF Transaction Billing: Header DataVBRP TRANSP VF Transaction Billing: Item DataVBSK TRANSP V Transaction Collective Processing for a Sales Document HeaderVBSS TRANSP V Transaction Collective Processing: Sales DocumentsVBUK TRANSP V Transaction Sales Document: Header Status and Administrative DataVBUP TRANSP V Transaction Sales Document: Item StatusVBUV CLUSTERV Transaction Sales Document: Incompletion LogVEPVG TRANSP VIND Delivery Due Index index table VETVG TRANSP VIND Delivery Due Index for Stock Transfer index table VKAOF TRANSP VIND Sales Index: Open Sales Activities index table VKDFS TRANSP VIND SD Index: Billing Initiator index table VLKPA TRANSP VIND SD Index: Deliveries by Partner Functions index table VLPMA TRANSP VIND SD Index: Delivery Items by Material index table VRKPA TRANSP VIND Sales Index: Bills by Partner Functions index table VRPMA TRANSP VIND SD Index: Billing Items per Material index table VTFA TRANSP VA Transaction Shipment Document FlowVTRDI TRANSP VIND Shipment Planning Index index tableT179TRANSP VS OrganizationalMaterials: Product HeirarchiesT179T TRANSP VT OrganizationalMaterials: Product Heirarchies: TextsBKPF TRANSP FB Transaction Accounting document header BNKA TRANSP FB Master Bank master recordBSAD TRANSP FB Transaction Accounting: Secondary index for customers (cleared items)BSAK TRANSP FB Transaction Accounting: Secondary index for vendors (cleared items)BSAS TRANSP FB Transaction Accounting: Secondary index for G/L accounts (cleared items)BSEC CLUSTERFB Transaction One-time account data document segmentBSEG CLUSTERFB Transaction Accounting document segmentAVOID USING!!!Use BSID, BSIK,and/or BSIS foropen itemsand BSAD, BSAK,and/or BSAS forcleared itemsBSET CLUSTERFB Transaction Tax data document segmentBSID TRANSP FB Transaction Accounting: Secondary index for customers BSIK TRANSP FB Transaction Accounting: Secondary index for vendors BSIS TRANSP FB Transaction Accounting: Secondary index for G/L accountsGLT0TRANSP FG Transaction G/L Account Master Record Monthly Debits and CreditsKNA1TRANSP FB Master General Data in Customer MasterKNAS TRANSP FB Master Customer master (VAT registration numbers general section)KNB1TRANSP FB Master Customer master (company code)KNB4TRANSP FB Master Customer payment historyKNB5TRANSP FB Master Customer master (dunning data)KNBK TRANSP FB Master Customer master (bank details)KNC1TRANSP FB Master Customer master (transaction figures)KNC3TRANSP FB Master Customer master (special G/L transaction figures) KNKA TRANSP FB Master Customer master credit management: Central dataKNKK TRANSP FB Master Customer master credit management: Control area dataLFA1TRANSP FB Master Vendor master (general section)LFAS TRANSP FB Master Vendor master (VAT registration numbers general section)LFB1TRANSP FB Master Vendor master (company code)LFB5TRANSP FB Master Vendor master (dunning data)LFBK TRANSP FB Master Vendor master (bank details)LFC1TRANSP FB Master Vendor master (transaction figures)LFC3TRANSP FB Master Vendor master (special G/L transaction figures)NBNK TRANSP FB OrganizationalNumber range for banksNKUK TRANSP FB OrganizationalNumber range for change documentsPAYR TRANSP FBZ Transaction Payment transfer medium filePCEC TRANSP FBZ OrganizationalPrenumbered ChecksREGUA TRANSP FBZ Transaction Change of payment proposals: user and time REGUH TRANSP FBZ Transaction Settlement data from payment programREGUP CLUSTERFBZ Transaction Processed items from payment programREGUS TRANSP FBZ Transaction Acounts blocked by payment proposal REGUV TRANSP FBZ Transaction Control records for the payment program SKA1TRANSP FB Master G/L accounts master (chart of accounts)SKAT TRANSP FB Master G/L account master record (chart of accounts: description)SKB1TRANSP FB Master G/L account master (company code)T001TRANSP FB OrganizationalCompany CodesT001B TRANSP FB OrganizationalPosting periods allowedT005TRANSP FB OrganizationalCountriesT005T TRANSP FB OrganizationalCountry namesT012POOL FB OrganizationalHouse banksT012T POOL FB OrganizationalHouse bank account namesTBSL POOL FB OrganizationalPosting keysTBSLT POOL FB OrganizationalPosting key namesTCURC TRANSP FB OrganizationalCurrency codesTCURF TRANSP FB OrganizationalConversion FactorsTCURR TRANSP FB OrganizationalCurrency exchange ratesTCURT TRANSP FB OrganizationalCurrency code namesTCURV TRANSP FB OrganizationalExchange rate types for currency translationTCUR W TRANSP FBOrganizationalExchange rate type usageTGSB TRANSP FB OrganizationalBusiness AreasTGSBT TRANSP FB OrganizationalBusiness area namesCEPC TRANSP KE Master Profit center master data tableCOBK TRANSP KA Transaction CO Object: Document headerCOEJ TRANSP KA Transaction CO object: year-related line itemsCOEJL TRANSP KA Transaction CO Object: Line Items for Activity Types (by Year) COEJR TRANSP KA Transaction CO Object: Statistical Key Figure Line Items (by Year) COEJT TRANSP KA Transaction CO Object: Activity Price Line Items (by Year)COEP TRANSP KA Transaction CO object: period-related line itemsCOEPB TRANSP KA Transaction CO Object: Line Items Variance/Period-based Results AnalysisCOEPL TRANSP KA Transaction CO Object: Line Items for Activity Types (by Period)COEPR TRANSP KA Transaction CO Object: Statistical Key Figure Line Items (by Period)COEPT TRANSP KA Transaction CO Object: Activity Price Line Items (by Period) COKA TRANSP KA Transaction CO Object: Cost Element Control DataCOKL TRANSP KA Transaction CO Object: Activity type control dataCOKP TRANSP KA Transaction CO Object: Primary Planning Control Data COKR TRANSP KA Transaction CO Object: Statistical Key Figure Control Data COKS TRANSP KA Transaction CO Object: Control Data for Secondary PlanningCOSB TRANSP KA Transaction CO Object: Total Variances/Results Analyses COSBD TRANSP KA Transaction CO Object: Total of variances/accruals, of which settledCOSL TRANSP KA Transaction CO Object: Activity Type TotalsCOSP TRANSP KA Transaction CO Object: Cost Totals - External Postings COSPD TRANSP KA Transaction CO Object: Settled Primary Cost Totals COSR TRANSP KA Transaction CO Object: Statistical Ratio TotalsCOSS TRANSP KA Transaction CO Object: Cost Totals - Internal Postings COSSD TRANSP KA Transaction CO Object: Settled Secondary Cost Totals COST TRANSP KA Transaction CO object: standard rate totalsCSKA TRANSP KS Master Cost elements (data dependent on chart of accounts)CSKB TRANSP KS Master Cost elements (data dependent on controlling area)CSKS TRANSP KSS Master Cost center master CSKT TRANSP KSS Master Cost center texts CSKU TRANSP KS Master Cost element texts CSLA TRANSP KSS Master Activity master CSLT TRANSP KSS Master Activity type textsCSSK TRANSP KSS Master Cost center /cost element CSSL TRANSP KSS Master Cost center / activity。
SAP常用表格与数据项FAGLFLEXA:实际行项目RCLNT:客户端RYEAR:会计年度DOCNR:会计凭证编号RLDNR:总分类账会计核算中分类账RBUKRS:公司代码DOCLN:分类账6个字符的过账项目ACTIV:FI-SL业务交易RMVCT:事务类型RTCUR:货币码RUNIT:基本计量单位AWTYP:参考交易RRCTY:记录类型RVERS:版本LOGSYS:逻辑系统RACCT:账号COST_ELEM:成本要素RCNTR:成本中心RFAREA:功能范围RBUSA:业务范围KOKRS:控制范围SEGMENT:部分报表分段SCNTR:发送方成本中心PPRCTR:伙伴利润中心SFAREA:伙伴功能范围SBUSA:贸易伙伴的业务范围RASSC:贸易伙伴的公司标识PSEGMENT:部分报表的伙伴分段TSL:交易货币值HSL:用本地货币表示的值KSL:集团公司记账货币值OSL:不同币种中的值MSL:数量WSL:原交易货币的值(凭证货币)DRCRK:借方/贷方标识POPER:记账期间RWCUR:原事务货币的货币码GJAHR:会计年度BUDAT:凭证中的过账日期BELNR:会计凭证编号BUZEI:会计凭证中的行项目数BSCHL:记账代码BSTAT:凭证状态LINETYPE:项目种类XSPLITMOD:由凭证分解的更改项目USNAM:用户名TIMESTAMP:简短格式的UTC时戳(YYYYMMDDhhmmss)FAGLFLEXT:总账:总计RCLNT:客户端RYEAR:会计年度OBJNR00~08:表格组的对象号码DRCRK:借方/贷方标识RPMAX:期间ACTIV:FI-SL业务交易RMVCT:事务类型RTCUR:货币码RUNIT:基本计量单位AWTYP:参考交易RLDNR:总分类账会计核算中分类账RRCTY:记录类型RVERS:版本LOGSYS:逻辑系统RACCT:账号COST_ELEM:成本要素RBUKRS:公司代码RCNTR:成本中心PRCTR:利润中心RFAREA:功能范围RBUSA:业务范围KOKRS:控制范围SEGMENT:部分报表分段SCNTR:发送方成本中心PPRCTR:伙伴利润中心SFAREA:伙伴功能中心SBUSA:贸易伙伴的业务范围RASSC:贸易伙伴的公司标识PSEGMENT:部分报表的伙伴分段TSLVT:业务货币的余额结转TSL01~16:按业务货币的期间中的业务总计HSLVT:用本币计算的结转余额HSL01~16:按本位币的期间中的业务总计KSLVT:按集团公司记账货币的期间中的业务总计KSL01~16:按集团公司记账货币的期间中的业务总计OSLVT:第四货币中的余额结转OSL01~16:第四货币中期段的总业务MSLVT:数量的余额结转MSL01~16:胺剂量单位的期间中的业务总计TIMESTAMP:简短格式的UTC时戳BSEG:会计核算凭证段MANDT:客户端BUKRS:公司代码BELNR:会计凭证编号GJAHR:会计年度BUZEI:会计凭证中的行项目数BUZID:行项目标识AUGDT:清账日期AUGCP:清算分录日期AUGBL:清算单据的单据号码BSCHL:记账代码KOART:科目类型UMSKZ:特殊总账标识UMSKS:特殊总分类账事务类型ZUMSK:目标特别总账标志SHKZG:借方/贷方标识GSBER:业务范围PARGB:贸易伙伴的业务范围MWSKZ:销售税代码QSSKZ:预提税代码DMBTR:按本位币计的金额WRBTR:凭证货币金额KZBTR:以本币计算的原始消减金额PSWBT:总账中更新的金额PSWSL:更新总分类账交易数字货币TXBHW:以本币计的原始税收基本金额TXBFW:以凭证货币计的原始税收基本金额MWSTS:用本币表示的税收金额WMWST:用凭证货币表示的税收金额HWBAS:以本币计的税款基额FWBAS:用凭证货币表示的税基额HWZUZ:以本币计的预付金额FWZUZ:以凭证货币计的附加税SHZUZ:现金折扣的附加借方/贷方STEKZ:版本号组件MWART:税收类型TXGRP:税务行项目的集团标志KTOSL:事务关键字QSSHB:扣交税款基础金额KURSR:套购汇率GBETR:外汇套期交易额BDIFF:估价差额BDIF2:第二本币的评估差额VALUT:起息日ZUONR:分配编号SGTXT:项目文本ZINKZ:从利息计算中免除VBUND:贸易伙伴的公司标识BEWAR:事务类型ALTKT:组科目号VORGN:总账事务类型BKPF:会计核算凭证标题ZRLYJ:日立公司按分配号月结。
SAP_常用业务数据表分类:SAP-ALL ABAP SAP-TABLE 2011-08-17 11:46 2248人阅读评论(0) 收藏举报目录(?)[+]表的要求表中使用的字段请尽量参照各模块的SAP字段标准使用习惯;例:“ZXSLRZX销售组织对应的利润中心”中的销售组织应该使用VKORG、利润中心应该使用PRCTR。
根据表的用途,需确定是否属于配置目的、还是业务目的。
配置表的建议:需要加入MANDT字段例:“ZQJQD缺件清单”就没有MANDT字段需提供相应的维护视图;例:如ZCHECK_MM01工厂和利润中心的对应为保证DEV/QAS/PRD系统的一致性,不应该对配置表提供批量维护的功能,而应该走Request传输流程;例:“ZMM_GSJJGLJ公司间物料转卖价格逻辑”就是一个失败的开发案例。
若有必要,可激活日志功能,便于对配置的更改查询;在定义表的时候,请不要偷懒使用“预定义数据类型”这种方式;业务表的建议:若无特殊目的,也请加入MANDT字段在定义关键字段的时候,请务必慎重,在理解业务需求的前提下,合理设置;(数据存在后,关键自动的变更存在较大风险)为减少系统存储空间,一般不需要激活更改日志;在定义表的时候,请不要偷懒使用“预定义数据类型”这种方式;程序的要求程序的选择屏幕,如果需要提供缺省值,请尽量通过Memory ID的方式实现,不要使用硬代码。
例:“ZPOOIS采购订单信息报表”中的公司代码(BUK)、工厂(WRK)。
程序的选择屏幕上的选择文本,如果属于标准字段,若无特殊需求,请尽量使用Dictionary,避免造成在不同语言环境中显示错误的情况。
例:ZPOOIS的选择屏幕在英文环境下完全错误,而ZJSJSNEW就相对正确。
程序变式(选择变式、输出变式)的灵活使用ALV报表,请提供变式功能(IS_VARIANT ,I_SAVE等变量);例:ZPOOIS的输出格式就无法保存。