Tuesday, December 19, 2017

Database Tables for PP

Table: SNUM  BOM explosion number

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
SERNRSERNRCHAR8BOM explosion number
BRUTRBRUTRDATS8Fixed key date

By means of the BOM explosion number , you can define a common explosion date ( fixed key date) for all BOM levels. BOM explosion is then carried out with this fixed key date for all levels.
TECHSTECHSCHAR12Parameter Variant/Standard Variant
SONDBSONDBCHAR1Special stock allowed for the serial number
MATNRMATNRCHAR18MARAMaterial Number
WERKSWERKS_DCHAR4T001WPlant
SNTXTSNTXTCHAR40Short description of BOM explosion number
SNSTASNSTACHAR1BOM explosion number status
XLOEKXLOEKCHAR1Item is Deleted


Table: STKOB  BOM Header Document

Field
Component Type
Data Typelength (Decimals)ChecktableDescription
.INCLUDESTKOBOM Header
MANDTMANDTCLNT3T000Client
STLTYSTLTYCHAR1BOM category
STLNRSTNUMCHAR8Bill of material
STLALSTALTCHAR2Alternative BOM
STKOZCIM_COUNTNUMC8Internal counter
STKOB-DATUVDATUVDATS8Valid-From Date
TECHVTECHVCHAR12Technical status from
AENNRAENNRCHAR12AENRChange Number
LKENZLKENZCHAR1Deletion Indicator
LOEKZLOKNZCHAR1Deletion flag for BOMs
VGKZLVGKZLNUMC8Previous header counter
ANDATANDATDATS8Date record created on
ANNAMANNAMCHAR12User who created record
AEDATAEDATDATS8Changed On
AENAMAENAMCHAR12Name of Person Who Changed Object
BMEINBASMEUNIT3T006Base unit of measure for BOM
BMENGBASMNQUAN13(3)Base quantity
CADKZCADKZCHAR1CAD Indicator
LABORLABORCHAR3T024LLaboratory/design office
LTXSPLTXSP_CPLANG1T002Long Text Language, for Creation of a Change Document
STKTXSTKTXCHAR40Alternative BOM Text
STLSTSTLSTNUMC2T415SBOM status
WRKANWRKANCHAR4T001WPlant where BOM or alternative/variant created
DVDATDVDATDATS8Date of last date shift
DVNAMDVNAMCHAR12Name of the user who carried out the date shift
AEHLPCC_AEHLPNUMC2Date Shift Hierarchy Indicator
ALEKZCS_ALEKZCHAR1ALE indicator
GUIDXCS_GUIDBRAW16Global identification of a BOM header change status
ZFIELD32LAND1CHAR3
*
Country Key
ZFIELD33LIFNRCHAR10
*
Account Number of Vendor or Creditor
.INCLUDESTKOSSTKO - Details
LTXPSLTXPSINT410Long text working name
LTXVBLVBKZCHAR1Long text update indicator
VBKZVBKZCHAR1Update indicator
MVBKZVBKZCHAR1Update indicator
DATUBDATUBDATS8Valid-to date
AENRAAENRACHAR12
*
Change Number To
AENKZSAENKZCHAR1Change indicator
SELKZCSSELCHAR1Selection of valid records
KZDOCCS_KZDOCCHAR1Indicator: Maintain document assignment in BOM complete
EFRNKCC_EFRNKNUMC20ECM: level during explosion

SAP giới thiệu mã hỗ trợ AI trong ngôn ngữ ABAP riêng của mình

SAP đã ra mắt một loạt tính năng mã hỗ trợ AI trong môi trường phát triển ứng dụng dựa trên đám mây của mình, đồng thời tham gia vào danh sá...