BizDoc.Infrastructure.SAP 0.1.16

SAP for BizDoc

In program.cs

builder.Services.AddBizDoc().
  AddSAP(options => 
    {
      options.ConnectionString = "sap";
    });

app.UseBizDoc().UseSAP();

Analysis

Configure UseAnalysis base on SAP account segmentations.

app.UseBizDoc().
    UseSAP().
    UseAnalysis();

BizDoc configure two cubes in bizdoc.json with axes and default views.

{
    "Cubes": [{
        "Type": "BizDoc.SAP.Configuration.DocumentCube, BizDoc.Infrastructure.SAP",
        "Axes": [...],
        "Views": [...]
    }, {
        "Type": "BizDoc.SAP.Configuration.ItemCube, BizDoc.Infrastructure.SAP",
        "Axes": [...],
    }]
}

{
    "Widgets": [{
        "Type": "BizDoc.Configuration.Widgets.CubeAnalysis",
        "Options": {
            "XAxis": "..."
        }
    }]
}

Object type

Set ObjectType in options to relevant types.

using BizDoc.SAP.Storage.Models;
builder.Services.AddBizDoc().
  AddSAP(options => 
    {
      options.ObjectType.Add(ObjectType.Delivery);
    });

Mapping

Implement CubeBase.IAxesMapping.

public class ShippingDateMapping : CubeBase.IAxesMapping
{
    public IDictionary<string, string> GetMapping()
    {
        Dictionary<string, string> map = new()
        {
            {"year", "EXTRACT(YEAR FROM ShipDate)" },
            {"quarter","TO_CHAR(ShipDate, 'Q')"},
            {"month", "'M' + TO_CHAR(ShipDate, 'MM')" },
            {"branch", "Branch"},
        };
        return map;
    }
}

To synchronize individual document type, use ScheduleDocumentsSynchronize.

app.UseBizDoc().
    UseSAP().
    ScheduleDocumentsSynchronize<ShippingDateMapping>(ObjectType.Delivery, Cron.Daily());

Set DocumentMappingPolicy, ItemMappingPolicy and GlMappingPolicy in options.

Workflow

DirectManager node

Assign document owner employee manager, if exists.

Position node

Assign user(s) to w/f by employee position.

Components

Types added to bizdoc.SAP.json.

Configure AccountSegmentationCategories in bizdoc.json:

{
  "Types": [
    {
        "Name": "departments",
        "Type": "BizDoc.SAP.Configuration.AccountSegmentationCategories, BizDoc.SAP",
        "Options": {
            "SegmentName": "region"
        }
    }
  ]
}

Database

Access database by injecting the SAPStorage service.

using BizDoc.SAP.Storage;

public class MyService {
  private readonly SAPStorage _storage;

  public MyService (SAPStorage storage) => _storage = storage;

  private void List() {
    foreach (var order in _storage.PurchaseOrders) {
	  ...
    }
  }
}

API

Security notice: Restrict api.

Angular

npm @bizdoc/sap package.