OCC Specification composition upload error

[#1]

Hallo all,

I was trying to upload the specification composition via OCC in OCC upload format. I was uploaded REAL_SUB and LIST_SUB via OCC, i just want to create composition SAP_EHS_1012_003 . But i'm getting following errors sm37.

Please help me on this.

When i was trying to create composition its working fine, OCC upload its giving above error.LIST_SUB already available in the system

Help me Out.

Thanks

Satya

[former_member408313]

Hi Satya,

I understand you are using SAP OCC to create a *.dat file and then trying to import into the system using Import / Export Option.

You are loading identifiers as well as composition in the single excel sheet. The best practice is to load them in pieces that is load the header data first, then identifiers and then value assignments and then compositions so on.

Try to separate out the identifiers as a load file and use only the components in the current load. I have used the below format previously and I could successfully load the data.

Please try this format

Other option to check also is using the EH&S OCC online mode where you connect to SAP system and call the excel and load the data.

Thanks and Regards

Jayakumar

[satya11719]

Hi Jaya ji,

Thanks for your reply,

Actually i did the same uploaded Header data and identifiers first for REAL,LIST sub first.

Then i was trying to upload the composition i tried the above mentioned format also, i was getting an error in cg33 like syntax $ESTRI is missing. Please check my previous reply.

Is there any configuration related to syntax ?

Online mode we have to OCC via user exit right ?

Thanks

Satya

[former_member408313]

Hi Satya,

We need to look into the generated *.dat file for the line segment 23.

Please check the syntax as mentioned in the help text Specification Import structure Via Dat Format

Thanks and Regards

Jayakumar

[christoph_bergemann]

Dear Jayakumar

I am not sure if your load file is correct. If you use the "ORD" in combinaiton with the "property" I would assume that any line of the file will get an "own" VAT. But the story is: one VAT should be generated with many components.

So we need some link to "ESTVA" and "ESTVP" in the load file. to seperate the "VAT" par (ESTVA) from "Composition" part (ESTVP)

C.B:

[former_member408313]

Hello Chrstoph,

Here "ORD" is a order number of the component. When it is used in composition load it takes the order number of the component against the composition in the specification. The reference structure from which this file is created are the below two references

1) Provides the structure and the mandatory fields and optional fields to load the data

2) Load structure as per the reference guide

-

Now coming to the error which Satya is getting is due to he using the *.dat file being used to import which do not have Identifiers in them. As per the syntax structure shown in above 1 item - identifiers are mandatory.

Thanks and Regards

Jayakumar

[satya11719]

Hello Jaya ji,

i was uploaded the same format into fresh system which is doesn't have any REAL_SUB and LIST_SUB , The upload was successful and system created REAL_SUB and LIST_SUB without any identifier cause my upload doesn't contain any identifiers and composition was updated as required.

My question is i have to delete the header of all REAL & LIST subs ??? and upload a new single file which includes composition also.

But i i didn't understand logic of this OCC ,why it is not working with existing REAL & LIST substances.

Thanks

Satya

[former_member408313]

Hello Satya,

Based on the information I understand that there is already data existing in the system for which it is not able to create new data.

When you have chosen a system with no data, it could create since it do not have conflict.

Thanks and Regards

Jayakumar