C_JP_SubcontrgPaymentTerm

DDL: C_JP_SUBCONTRGPAYMENTTERM Type: view_entity CONSUMPTION Package: GLO_LOG_JP_SC_PPT
27 Fields 1 Data Sources 1 OData Services

Print Payment term for JP Subcontracting

C_JP_SubcontrgPaymentTerm is a Consumption CDS View that provides data about "Print Payment term for JP Subcontracting" in SAP S/4HANA. It reads from 1 data source (R_JP_SubcontrgPaymentTerm) and exposes 27 fields with key fields Supplier, CompanyCode, PurchasingOrganization. It is exposed through 1 OData service (UI_JP_SUBCONTRGPAYMENTTERM). Part of development package GLO_LOG_JP_SC_PPT.

Data Sources (1)

SourceAliasJoin Type
R_JP_SubcontrgPaymentTerm R_JP_SubcontrgPaymentTerm projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Print Payment term for JP Subcontracting view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_JP_SUBCONTRGPAYMENTTERM UI_JP_SUBCONTRGPAYMENTTERM_V4 V4 C1 NOT_RELEASED

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY CompanyCode CompanyCode Receiver Company Code
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
CompanyName CompanyName Text
BPSupplierName BPSupplierName Supplier Name
JP_SubcontractorType JP_SubcontractorType
JP_SubcontractorTypeDomainText JP_SubcontractorTypeDomainText
PurchasingOrganizationName PurchasingOrganizationName Purch. Org. Name
BankName BankName Bank Name
PaymentTerms PaymentTerms Pyt Terms
PaymentTermsDescription PaymentTermsDescription
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodDescription PaymentMethodDescription
JP_CompletionDateOfInspValue JP_CompletionDateOfInspValue
CityName
PostalCode
StreetName
BankCountry BankCountry Bank Ctry/Rgn. Key
BankInternalID BankInternalID Bank Key
EffectiveDate EffectiveDate Effective Date
_CompanyCode _CompanyCode
_Supplier _Supplier
_BankDetails _BankDetails
_SupplierPurchasingOrg _SupplierPurchasingOrg
_PurchasingOrg _PurchasingOrg
_TermsOfPayment _TermsOfPayment
_PaymentTermsText _PaymentTermsText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_JP_SubcontrgPaymentTerm.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_JP_SubcontrgPaymentTerm AS
SELECT
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  CompanyName,
  BPSupplierName,
  JP_SubcontractorType,
  JP_SubcontractorTypeDomainText,
  PurchasingOrganizationName,
  BankName,
  PaymentTerms,
  PaymentTermsDescription,
  PaymentMethod,
  PaymentMethodDescription,
  JP_CompletionDateOfInspValue,
  _CompanyCode._Address.CityName AS CityName,
  _CompanyCode._Address.PostalCode AS PostalCode,
  _CompanyCode._Address.StreetName AS StreetName,
  BankCountry,
  BankInternalID,
  EffectiveDate
FROM R_JP_SubcontrgPaymentTerm
;

Learn More