Multiple Sales Document Item line

[ROLLS123]

base in this below codes only 1 item line support there's a way to set table to multiple Document Item line

YaNco/samples/netcore3.1/CreateSalesOrder/CreateSimpleSalesDocument.cs

Lines 43 to 98 in 0bf4705

	return _rfcContext.CallFunction("BAPI_SALESDOCU_CREATEFROMDATA1",
	Input: f => f
	// sets the input fields
	.SetStructure("SALES_HEADER_IN",s => s
	.SetField("DOC_TYPE", _customizingSettings.DocumentType ?? "")
	.SetField("SALES_ORG", _customizingSettings.SalesOrganization ?? "")
	.SetField("DISTR_CHAN", _customizingSettings.DistributionChannel ?? "")
	.SetField("DIVISION", _customizingSettings.Division ?? "")
	)
	.SetStructure("SALES_HEADER_INX", s => s
	.SetField("UPDATEFLAG", "I") // this enables handling of X structures
	.SetField("DOC_TYPE", _customizingSettings.DocumentType != null ? "X": "")
	.SetField("SALES_ORG", _customizingSettings.SalesOrganization != null ? "X" : "")
	.SetField("DISTR_CHAN", _customizingSettings.DistributionChannel != null ? "X" : "")
	.SetField("DIVISION", _customizingSettings.Division != null ? "X" : "")
	)
	//we only support documents with one item line
	.SetTable("SALES_ITEMS_IN", OneLine, (s, _) => s
	.SetField("MATERIAL", ProductId)
	)
	.SetTable("SALES_ITEMS_INX", OneLine, (s, _) => s
	.SetField("MATERIAL", "X")
	)
	.SetTable("SALES_PARTNERS", OneLine, (s, _) => s
	.SetField("PARTN_ROLE", "AG")
	.SetField("PARTN_NUMB", CustomerNo)
	)
	.SetTable("SALES_SCHEDULES_IN", OneLine, (s, _) => s
	//item numbers are not necessary, the function will automatically assign it to the item
	.SetField("REQ_DATE", DateTime.Now)
	.SetField("REQ_QTY", Quantity)
	)
	.SetTable("SALES_SCHEDULES_INX", OneLine, (s, _) => s
	.SetField("REQ_DATE", "X")
	.SetField("REQ_QTY", "X")
	),
	Output: f => f
	.HandleReturnTable() //map result of RETURN table to RfcErrorInfo
	.GetField<string>("SALESDOCUMENT_EX")
	)
	.CommitAndWait(_rfcContext)
	//alternative to:
	//.Bind(result => _rfcContext.CommitAndWait().Map(_ => result))
	.MatchAsync(
	LeftAsync:async l=>
	{
	await Console.Error.WriteLineAsync($"Failed to create sales document. Error: {l.Message}");
	return -1;
	},
	RightAsync: async result => {
	await Console.Out.WriteLineAsync($"Created Sales document: {result}");
	return 0;
	});
	}

//we only support documents with one item line
.SetTable("SALES_ITEMS_IN", OneLine, (s, _) => s
.SetField("MATERIAL", ProductId)
)
.SetTable("SALES_ITEMS_INX", OneLine, (s, _) => s
.SetField("MATERIAL", "X")
)
.SetTable("SALES_PARTNERS", OneLine, (s, _) => s
.SetField("PARTN_ROLE", "AG")
.SetField("PARTN_NUMB", CustomerNo)
)

Thank you,

[fw2568]

Hi,
sure.
The second argument of SetTable (inputList) is a IEnumerable<TInput>. TInput could be any type.
SetTable will create a row in the function table for each entry in inputList.

So you simple fill a array or list or any other enumerable with the data you would like to be mapped to the function table.

For example:

 // partner data
  var partners = new[]
  {
      new { Role = "AG", No = "4711" },
      new { Role = "WE", No = "4712" }
  };

// later in function definition: 
....
    .SetTable("SALES_PARTNERS", partners, (s, partner) => s  //this function will be called for each entry in partners
        .SetField("PARTN_ROLE", partner.Role)
        .SetField("PARTN_NUMB", partner.No)
    )

See also readme (Input mapping).

Best Regards,
Frank

[ROLLS123]

thanks @fw2568 this is working from my side