GET https://hanaserver:50000/b1s/v1/sml.svc/AveragePurchasingPriceQuery
{
"@odata.context": "https://hanaserver:50000/b1s/v1/sml.svc/$metadata#AveragePurchasingPriceQuery",
"value": [
{
...
"PurchaseAmountLC": 5000,
"PurchaseQuantityInInventoryUoM": 100,
"AverageUnitPriceLC": 50,
"id__": 1
},
{
...
"PurchaseAmountLC": 2000,
"PurchaseQuantityInInventoryUoM": 10,
"AverageUnitPriceLC": 200,
"id__": 2
},
...
]
}
GET
https://hanaserver:50000/b1s/v1/sml.svc/AveragePurchasingPriceQuery?$select=PostingYear,BusinessPart...
kip=1&$filter=PostingYear eq '2017' and startswith(BusinessPartnerCode,
'1')&$orderby=PostingYear
{
"@odata.context": "https://hanaserver:50000/b1s/v1/sml.svc/$metadata#AveragePurchasingPriceQuery",
"value": [
{
"PostingYear": "2017",
"BusinessPartnerCode": "1071287676"
},
{
"PostingYear": "2017",
"BusinessPartnerCode": "1100270398"
},
{
"PostingYear": "2017",
"BusinessPartnerCode": "124052273"
},
{
"PostingYear": "2017",
"BusinessPartnerCode": "1785286082"
}
]
}
SELECT * FROM
"_SYS_BIC"."sap.sbodemous.fin.fi/BalanceSheetQuery"('PLACEHOLDER'=('$$P_AddVoucher$$',
'N'),'PLACEHOLDER'=('$$P_FinancialPeriod$$','2017'))"
GET
https://hanaserver:50000/b1s/v1/sml.svc/BalanceSheetQueryParameters(P_FinancialPeriod='2017',P_AddVoucher='N')
/BalanceSheetQuery?$select=FiscalYear, AccountCode
{
"@odata.context": "https://hanaserver:50000/b1s/v1/sml.svc/$metadata#BalanceSheetQuery",
"value": [
{
"FiscalYear": 2017,
"AccountCode": "_SYS00000000049"
},
{
"FiscalYear": 2017,
"AccountCode": "_SYS00000000009"
},
...
{
"FiscalYear": 2017,
"AccountCode": "_SYS00000000029"
}
],
"@odata.nextLink": "BalanceSheetQueryParameters(P_FinancialPeriod='2017',P_AddVoucher='N')/BalanceSheetQuery?$select=FiscalYear,%20AccountCode&$skip=20"
}
GET https://hanaserver:50000/b1s/v1/sml.svc/$metadata
<?xml version="1.0" encoding="UTF-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
<edmx:DataServices>
<Schema Namespace="SAPB1" xmlns="http://docs.oasis-open.org/odata/ns/edm">
<EntityType Name="AveragePurchasingPriceQuery">
<Key> <PropertyRef Name="id__"/> </Key>
<Property MaxLength="160" Name="LineDocumentOwner" Nullable="true" Type="Edm.String"/>
<Property MaxLength="15" Name="PaymentMethodCode" Nullable="true" Type="Edm.String"/>
<Property Name="PostingDateSQL" Nullable="true" Type="Edm.DateTime"/>
...
<Property Name="id__" Nullable="false" Type="Edm.Int32"/>
</EntityType>
<EntityType Name="OnTimeReceiptStatisticsQuery">
<Key> <PropertyRef Name="id__"/> </Key>
<Property MaxLength="160" Name="DocumentOwner" Nullable="true" Type="Edm.String"/>
<Property Name="NumberOfPurchaseOrder" Nullable="true" Type="Edm.Int32"/>
<Property Name="id__" Nullable="false" Type="Edm.Int32"/>
</EntityType>
<EntityContainer Name="SemanticLayer">
<EntitySet EntityType="SAPB1.PurchaseOrderFulfillmentCycleTimeQuery" Name="PurchaseOrderFulfillmentCycleTimeQuery"/>
...
<EntitySet EntityType="SAPB1.BalanceSheetComparisonQueryParameter" Name="BalanceSheetComparisonQueryParameters">
<NavigationPropertyBinding Path="BalanceSheetComparisonQuery" Target="BalanceSheetComparisonQuery"/>
</EntitySet>
...
<EntitySet EntityType="SAPB1.KPICashFlowStatementQueryParameter" Name="KPICashFlowStatementQueryParameters">
<NavigationPropertyBinding Path="KPICashFlowStatementQuery" Target="KPICashFlowStatementQuery"/>
</EntitySet>
</EntityContainer>
</Schema>
</edmx:DataServices>
</edmx:Edmx>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |