Windchill Attribute Name
|
API Structure
|
API Field
|
API Field Description
|
Value If Default
|
Source
|
Transform
|
Assembly Part Number
|
HEADER
|
MATERIAL
|
Material Number
|
N/A
|
Windchill
|
N/A
|
TargetID
|
HEADER
|
PLANT
|
Plant
|
N/A
|
Windchill
|
Sub-string
|
N/A
|
HEADER
|
BOM_USAGE
|
BOM usage
|
1 = Production
|
Default
|
N/A
|
Effectivity Date
|
HEADER
|
VALID_FROM
|
Effectivity date
|
Current Date
|
Windchill, Default if not sent
|
N/A
|
Change Number
|
HEADER
|
CHANGE_NO
|
Change number
|
N/A
|
Windchill
|
N/A
|
N/A
|
HEADER
|
FL_COMMIT_AND_WAIT
|
Flag for commit and wait
|
X
|
Default
|
N/A
|
N/A
|
T_STPO
|
ITEM_CATEG
|
Item category
|
L=Stock Item
|
Default
|
N/A
|
Line #s
|
T_STPO
|
ITEM_NO
|
Item number
|
N/A
|
Windchill
|
N/A
|
Part Number
|
T_STPO
|
COMPONENT
|
Material number
|
N/A
|
Windchill
|
N/A
|
Substitute Part Number
|
T_STPO
|
COMPONENT
|
Material number
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_STPO
|
COMP_QTY
|
Component quantity
|
N/A
|
Windchill
|
N/A
|
Alt Item Group
|
T_STPO
|
AI_GROUP
|
Alternate item group number
|
N/A
|
Windchill
|
N/A
|
N/A
|
T_STPO
|
AI_PRIO
|
Alternate item priority
|
1 for the component2 for all substitutes of that component.
|
Default
|
N/A
|
N/A
|
T_STPO
|
AL_STRATEG
|
Alternate Strategy
|
“2”
|
Default
|
N/A
|
N/A
|
T_STPO
|
USAGE_PROB
|
Component Usage Probability
|
100 for the component1 for all substitutes of that component.
|
Default
|
N/A
|
N/A
|
T_STPO
|
SORTSTRING
|
Sort String 1 (Component)
|
"000"
|
Default
|
N/A
|
Alt Item Group
|
T_STPO
|
SORTSTRING
|
Sort String1 (Substitute)
|
N/A
|
Windchill
|
N/A
|
Windchill Attribute Name
|
API Structure
|
API Field
|
API Field Description
|
Value If Default
|
Source
|
Transform
|
||
Transaction Number
|
BOM GROUP
|
BOM_GROUP_IDENTIFICATION
|
maximum 32 characters unique group identification
|
N/A
|
Windchill and TIBCO
|
Concatenate transaction number with date/time (ddHHmmssSSS)
|
||
N/A
|
BOM GROUP
|
OBJECT_TYPE
|
fixed value 'BGR'
|
‘BGR’
|
Default
|
N/A
|
||
Transaction Number
|
BOM GROUP
|
OBJECT_ID
|
unique maximum 32 character object identification
|
N/A
|
Windchill and TIBCO. Same value as BOM_GROUP_IDENTIFCATION
|
Concatenate transaction number with date/time (ddHHmmssSSS)
|
||
N/A
|
BOM GROUP
|
TECHNICAL_TYPE
|
M’. Space – Simple BOM V – Variant BOM M- Multiple BOM
|
‘M’
|
Default
|
N/A
|
||
BOM Usage
|
BOM GROUP
|
BOM_USAGE
|
BOM Usage value For e.g. ‘1’ for production. Refer table T416 for various BOM Usage values
|
N/A
|
Windchill
|
Cross Reference
|
||
Transaction Number
|
BOM Group
|
BOM_GROUP
|
same as BOM_GROUP_IDENTIFICATION
|
N/A
|
Windchill TIBCO
|
Concatenate transaction number with date/time (ddHHmmssSSS)
|
||
Distribution Target
|
BOM GROUP
|
CREATED_IN_PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
||
N/A
|
BOM Group
|
LTXT_LANG
|
Language: The long text was stored in this language
|
“E”
|
Default
|
Default
|
||
Transaction Number
|
BOM Group
|
BOM_TEXT
|
BOM text
|
N/A
|
Windchill TIBCO
|
Concatenate Date time ,”TxnNO:-“,Transaction Number
|
||
Transaction Number
|
ITEMASSIGNMENT
|
BOM_GROUP_IDENTIFICATION
|
N/A
|
N/A
|
N/A
|
N/A
|
||
N/A
|
ITEMASSIGNMENT
|
SUB_OBJECT_TYPE
|
Type of subobject BOMs
|
“ITM”
|
Default
|
Default
|
||
Component Part Number
|
ITEMASSIGNMENT
|
SUB_OBJECT_ID
|
Material Number
|
N/A
|
Windchill
|
N/A
|
||
N/A
|
ITEMASSIGNMENT
|
SUPER_OBJECT_TYPE
|
Type of super object BOM
|
“BOM”
|
Default
|
Default
|
||
BOM Header Part Number (Assembly Part Number)
|
ITEMASSIGNMENT
|
SUPER_OBJECT_ID
|
Object ID super object BOM Material Number
|
N/A
|
Windchill
|
N/A
|
||
Effectivity
|
ITEMASSIGNMENT
|
VALID_FROM_DATE
|
Valid-From Date
|
TIBCO system date in case of Change number does not exists.
|
TIBCO
|
Transform TIBCO date to SAP date format.
|
||
ECN Number
|
ITEMASSIGNMENT
|
CHANGE_NO
|
Change Number
|
N/A
|
Windchill
|
N/A
|
||
N/A
|
ITEMASSIGNMENT
|
FUNCTION
|
Function
|
“NEW”
|
Default
|
N/A
|
||
ITEMS
|
BOM_GROUP_IDENTIFICATION
|
|||||||
ITEMS
|
OBJECT_TYPE
|
Type of object in a BOM group
|
“ITM”
|
N/A
|
N/A
|
|||
Component Part Number
|
ITEMS
|
OBJECT_ID
|
Identification of the object in a BOM group Material Number
|
N/A
|
Windchill
|
N/A
|
||
Component Line Number Or Substitute Part Number
|
ITEMS
|
ITEM_NO
|
BOM Item Number
|
N/A
|
Windchill
|
N/A
|
||
N/A
|
ITEMS
|
ITEM_CAT
|
Item Category (Bill of Material)
|
“L”
|
Default
|
Default
|
||
Alternate Item Group
|
ITEMS
|
SORTSTRING
|
Sort String
|
N/A
|
Windchill
|
N/A
|
||
Component Line Number Or Substitute Part Number
|
ITEMS
|
COMPONENT
|
BOM component
|
N/A
|
Windchill
|
N/A
|
||
Component Quantity
|
ITEMS
|
COMP_QTY
|
Component Quantity
|
N/A
|
Windchill
|
N/A
|
||
N/A
|
ITEMS
|
ALT_ITEM_STRATEGY
|
Alternative item: strategy
|
“2”
|
Default
|
Default
|
||
N/A
|
ITEMS
|
ALT_ITEM_PRIO
|
Alternative item: ranking order
|
1 for the component 2 for all substitutes of that component.
|
Default
|
Default
|
||
Alternate Item Group
|
ITEMS
|
ALT_ITEM_GROUP
|
Alternative item: group
|
N/A
|
Windchill
|
N/A
|
||
N/A
|
ITEMS
|
USAGE_PROB
|
Usage probability in % (alternative item)
|
100 for the component 1 for all substitutes of that component.
|
||||
Effectivity
|
ITEMS
|
VALID_FROM_DATE
|
Valid From Date
|
TIBCO System Date in case of Change number does not exists
|
TIBCO
|
Transform TIBCO date to SAP date format.
|
||
ECN Number
|
ITEMS
|
CHANGE_NO
|
Change Number
|
N/A
|
Windchill
|
N/A
|
||
MATERIALRELATIONS
|
BOM_GROUP_IDENTIFICATION
|
|||||||
Assembly Part Number
|
MATERIALRELATIONS
|
MATERIAL
|
Material Number
|
N/A
|
Windchill
|
N/A
|
||
Distribution Target (Target ID)
|
MATERIALRELATIONS
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
||
BOM Usage
|
MATERIALRELATIONS
|
BOM_USAGE
|
BOM Usage
|
N/A
|
Windchill
|
Cross Reference
|
||
BOM Alternate
|
MATERIALRELATIONS
|
ALTERNATIVE_BOM
|
Alternative BOM
|
N/A
|
Windchill
|
Cross Reference
|
||
N/A
|
MATERIALRELATIONS
|
LOT_SIZE_FROM
|
From Lot Size
|
“1”
|
Default
|
Default
|
||
N/A
|
MATERIALRELATIONS
|
LOT_SIZE_TO
|
To Lot Size
|
“10”
|
Default
|
Default
|
||
Transaction Number
|
VARIANTS
|
BOM_GROUP_IDENTIFICATION
|
Identification BOM group
|
N/A
|
Windchill, TIBCO
|
|||
N/A
|
VARIANTS
|
OBJECT_TYPE
|
Type of object in a BOM group
|
“BOM”
|
TIBCO
|
N/A
|
||
Assembly Part Number
|
VARIANTS
|
OBJECT_ID
|
Identification of the object in a BOM group
|
N/A
|
Windchill
|
N/A
|
||
BOM Alternate
|
VARIANTS
|
ALTERNATIVE_BOM
|
Alternative BOM
|
N/A
|
Windchill
|
Cross Reference
|
||
N/A
|
VARIANTS
|
BOM_STATUS
|
BOM status
|
“01”
|
Default
|
Default
|
||
N/A
|
VARIANTS
|
BASE_QTY
|
Base quantity
|
1
|
Default
|
Default
|
||
N/A
|
VARIANTS
|
LTXT_LANG
|
Language: The long text was stored in this language
|
“E”
|
Default
|
Default
|
||
N/A
|
VARIANTS
|
LANGU_ISO
|
Language according to ISO 639
|
“EN”
|
Default
|
Default
|
||
Effectivity
|
VARIANTS
|
VALID_FROM_DATE
|
Valid From Date
|
TIBCO System Date in case of Change number does not exists
|
TIBCO
|
Transform TIBCO date to SAP date format.
|
||
ECN Number
|
VARIANTS
|
CHANGE_NO
|
Change Number
|
N/A
|
Windchill
|
N/A
|
||
N/A
|
VARIANTS
|
FUNCTION
|
Function
|
“NEW”
|
TIBCO
|
N/A
|
Windchill Attribute Name
|
API Structure
|
API Field
|
API Field Description
|
Value If Default
|
Source
|
Transform
|
N/A
|
N/A
|
N/A
|
N/A
|
N/A
|
N/A
|
N/A
|